Bug 56611 - FILESAVE: No warning message if result file format has any limitations in rows or columns (xlsx -> xls)
Summary: FILESAVE: No warning message if result file format has any limitations in row...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 3.6.2.2 release
Hardware: x86 (IA32) All
: medium enhancement
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-10-31 11:09 UTC by Timon
Modified: 2012-11-03 14:48 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:

Attachments
Example .xlsx file with 129 383 rows (1.44 MB, application/zip)
2012-10-31 11:09 UTC, Timon 		Details
View All

Description Timon 2012-10-31 11:09:22 UTC 
Created attachment 69349 [details]
Example .xlsx file with 129 383 rows

We have .xlsx file that contain 129 383 rows. If we try to save this file in Microsoft Excel 97/2000/XP/2003 (.xls) file format , then after saving we have .xls file truncated to 65 536 rows (all the rest is missed). And program did not show any warnings like "Document contains more rows or columns than supported in the selected file format". Risk of data loss is very large and you can not always immediately detect it.
Comment 1 Timon 2012-11-01 04:26:21 UTC 
We see only standart message that is shown in almost all cases "when not saving in ODF format" - "This document may contain formatting of content that cannot be saved in the currently selected file format Microsoft Excel 97/2000/XP/2003. Use the default ODF file format to be sure that the document is saved correctly." And no a word, that some of content would be missed.
Comment 2 Jean-Baptiste Faure 2012-11-03 11:50:25 UTC 
Indeed.

But:
1/ xls is a obsolescent format
2/ saving with "save as" does not remove the original file, so the data are not lost.

Best regards. JBF
Comment 3 Timon 2012-11-03 14:48:45 UTC 
In any case, there is need to notify user. Not all users save their files as... and they may not even know that lost of data could occur because of obsolescent format. Apache Open Office show warning in such case "Document contains more rows than supported in the selected file format" but after saving file.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.