1. New Calc. 2. [CTRL]+[A] 3. [CTRL]+[SHIFT]+[S] 4. Use a new/different file name; select the type of file to be 97-2003 XLS; [OK] 5. In the first dialog, confirm the XLS file format (instead of the suggested ODS file format). Actual result: There is a warning, either about too many rows or about too many columns not supported by the (XLS) file format. " The document contains more rows than supported in the selected format. Additional rows were not saved. " Expected result: Avoid either of the 2 possible warnings (too many rows, too many columns) when it is about selection _only_ and there is no real dependency on columns/rows beyond the XLS limit (i.e. beyond cell IV65536, or R65536C256).
Yes, selection only gives the warning but should consider whether cells contain any data. Not sure if this topic is covered in the see also or other tickets.
(In reply to Heiko Tietze from comment #1) > Yes, selection only gives the warning but should consider whether cells > contain any data. Not only data contained within a cell, but any kind of valid dependency (e.g. conditional format depending on some other cell, Validity, etc.). All that, except if the only thing is selection of the cell. Selection by itself (without any "real" dependency) should not trigger a warning, because there is no real loss (of any kind of data) when saving. Apparently, the selected area is being "saved", so when cells above the limit of XLS format are selected, the warnings are triggered (either rows or columns, depending on which area was selected). > Not sure if this topic is covered in the see also or other > tickets. Other reports have contradicting comments and apparently some behavior has been tracked to older versions (which I doubt, but OK). This has a simple STR for both warnings. See bug 92164 comment 38 and up.
Bibisected the behaviour change with linux-43max to 28e9efe5b4d6699b33498953e798f76008edaeda fdo#40694 - Error in message when truncating col/row numbers in calc It looks like while older version (3.5.x) gives a wrong warning The newer version doesn't give any warnings. With this it gives the warning with correct message.
That's bug 40694
> fdo#40694 - Error in message when truncating col/row numbers in calc > > It looks like while older version (3.5.x) gives a wrong warning > The newer version doesn't give any warnings. > With this it gives the warning with correct message. In LO 4.2, there was no warning when some data would had been lost while saving as XLS (i.e. beyond cell IV65536). In LO 4.3, the warning indeed exists. The problem is that, even with no relevant/real dependency beyond cell IV65536, by just selecting (for instance) an entire row/column while saving as XLS, the warning is shown even if there is no real data loss. In such cases, the warning is misleading. Is the "selected area(s)" even really "saved" somewhere in the XLS file? If there is no real data loss, the warning should not be shown.
(In reply to ady from comment #5) > > fdo#40694 - Error in message when truncating col/row numbers in calc > > > > It looks like while older version (3.5.x) gives a wrong warning > > The newer version doesn't give any warnings. > > With this it gives the warning with correct message. > > In LO 4.2, there was no warning when some data would had been lost while > saving as XLS (i.e. beyond cell IV65536). > > In LO 4.3, the warning indeed exists. > > The problem is that, even with no relevant/real dependency beyond cell > IV65536, by just selecting (for instance) an entire row/column while saving > as XLS, the warning is shown even if there is no real data loss. In such > cases, the warning is misleading. > > Is the "selected area(s)" even really "saved" somewhere in the XLS file? > > If there is no real data loss, the warning should not be shown. Maybe I should have added that that was me quoting the commit message.
To sum up... Each of the possible messages (depending on the specific "selected area") are: " The document contains more columns than supported in the selected format. Additional columns were not saved. " " The document contains more rows than supported in the selected format. Additional rows were not saved. " The messages themselves are not the real problem. The problem is that the "selected" area should not really be part of the active area – or however the actually-relevant area is supposed to be named – to be (checked for limits in XLS format and) saved. I guess the problem is in: sc/source/filter/excel/xehelper.cxx
Dear ady, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug