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.
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.
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
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.
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: 18.104.22.168
Operating System: Linux Mint 17.2
Yes, I see a warning message. But it's better to shown it NOT AFTER saving, but BEFORE saving.
I am using LibreOffice Version 22.214.171.124 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 . . .
As i have checked with latest version 126.96.36.199 , this problem is also present in this latest version.
(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