View Issue Details

IDProjectCategoryView StatusLast Update
0001348Database Workbench v6Data Import & Exportpublic2022-01-12 11:52
ReporterJeroen Pluimers Assigned ToMartijn Tonies  
Status confirmedResolutionopen 
PlatformWindowsOSWindowsOS VersionAny
Product Version5.1.12 
Summary0001348: Show hint/warning for CSV/XLS(X) when exporting too many rows and columns
DescriptionExcel has these limitations: Worksheet size 1,048,576 rows by 16,384 columns.

When exporting more than that many rows or columns, show a warning for XLS/XLSX and a hint when exporting CSV.

Reason: Excel will barf when opening bigger files and complain they are "broken" and suggests "repair" without telling the actual cause.
Steps To ReproduceCreate a result set that has more than 1,048,576 rows or 16,384 columns.

Export that to XLS/XLSX/CSV.

Open these files in Excel.
TagsNo tags attached.


Martijn Tonies

2018-01-17 12:35

administrator   ~0000447

Another limit: 255 char column width.

Issue History

Date Modified Username Field Change
2016-03-30 09:01 Jeroen Pluimers New Issue
2016-03-30 15:05 Martijn Tonies Assigned To => Martijn Tonies
2016-03-30 15:05 Martijn Tonies Status new => confirmed
2018-01-17 12:35 Martijn Tonies Note Added: 0000447
2022-01-12 11:52 Martijn Tonies Project Database Workbench v5 => Database Workbench v6