Bug Hunting Session
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: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.2.2 release
Hardware: x86 (IA32) All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-10-31 11:09 UTC by Timon
Modified: 2017-12-21 08:29 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


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

Note You need to log in before you can comment on or make changes to this bug.
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.
Comment 4 David Fischer 2015-08-22 04:58:55 UTC
I tried to save your attached example file as a .xls file and received the following message.



Warning saving the document Example 23:
The document contains more rows than supported in the selected format.
Additional rows were not saved.



Looks like this prompt is meeting the intent of your request so I am going to mark this bug as resolved.

LibreOffice Version: 5.0.0.5
Operating System: Linux Mint 17.2
Comment 5 Timon 2015-08-24 06:00:48 UTC
Yes, I see a warning message. But it's better to shown it NOT AFTER saving, but BEFORE saving.
Comment 6 Prabhdeep Singh 2017-12-20 12:13:48 UTC
Dear Sir,

I am using LibreOffice Version 5.3.1.2 and this bug still exist in this version also.I create a test file with 450 columns and save that file with .ods extension and i got no warning and when i open the file there is no data lose and columsn shows same as 450. 

But when i save the file again with .xls extension , first i got that "warning message of data lose" and i click OK on it save the file as it is.Then i open the file i got only 256 columns and rest disappeared.

Please assist  . . .

Regards
Prabhdeep Singh
Comment 7 Prabhdeep Singh 2017-12-21 05:25:03 UTC
Dear Sir,

As i have checked with latest version 5.4.4.2 , this problem is also present in this latest version.
Comment 8 Jean-Baptiste Faure 2017-12-21 08:29:55 UTC
(In reply to Prabhdeep Singh from comment #6)
> [...]
> But when i save the file again with .xls extension , first i got that
> "warning message of data lose" and i click OK on it save the file as it
> is.Then i open the file i got only 256 columns and rest disappeared.

Well, you got a warning message about data loss, you said OK, you got data loss.
There is no bug, you got what you asked for.

Closing again as WorksForMe.

Best regards. JBF