[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 --- Comment #37 from QA Administrators --- Dear gmarco, 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 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 --- Comment #38 from gmarco --- YES, I confirm that repeating the case as per comment #10 nothing has changed (LO 7.4.6.2) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 --- Comment #39 from ady --- (In reply to gmarco from comment #38) > YES, I confirm that repeating the case as per comment #10 nothing has > changed (LO 7.4.6.2) @gmarco, I'd like to ask for confirmation of the following test(s). Test A (as in comment 10): 1. Open attachment 116681 from comment 9. 2. Select rows _headers_ from row 1 to 10. 3. [CTRL]+[+] (> insert full rows) 4. [CTRL]+[Z] (> undo, the _entire_ rows from row 1 to 10 are still selected) 5. Menu File > Save as > testA.xls (> I get the message about too many columns for the xls file format). Test B (as in comment 10, but with small difference): 1. Open attachment 116681 from comment 9. 2. Select rows _headers_ from row 1 to 10. 3. [CTRL]+[+] (> insert full rows) 4. [CTRL]+[Z] (> undo, the _entire_ rows from row 1 to 10 are still selected) 5. [CTRL]+[HOME] (> no row is selected; only cell A1 has focus) 6. Menu File > Save as > testB.xls With testA, I get the message about too many columns for the xls file format. With testB, no such message. @gmarco, Could you please confirm whether you experience the aforementioned respective behaviors with each of these two tests? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 --- Comment #40 from ady --- FWIW, I can get an even simpler test. 1. Open attachment 116681 [details] from comment 9. 2. Click on the _header_ for row 1 (> the _entire_ row 1 is selected) 3. Menu File > Save as > testB.xls (the name must change from the original). With that, the message about too many columns for xls file format is displayed once the file is saved for the first time with a new name. Note that no real action was performed on the file; only the entire row is selected and a new name is used (in order to trigger the check and thus the message). When only cell A1 has focus (so, no full row is selected), there is no message. BTW, the title subject of this report is incorrect. It is _not_ about too many rows, but about too many columns, and the only requirement is to have "too many columns selected by the time the file is saved as xls" in order to trigger the message. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 --- Comment #41 from ady --- (In reply to ady from comment #40) Sorry, we don't need any prior attachment either. 1. Open Calc. then. > 2. Click on the _header_ for row 1 (> the _entire_ row 1 is selected) 3. [CTRL]+[S] as xls. The rest is of course valid. > > With that, the message about too many columns for xls file format is > displayed once the file is saved for the first time with a new name. > > Note that no real action was performed on the file; only the entire row is > selected and a new name is used (in order to trigger the check and thus the > message). > > When only cell A1 has focus (so, no full row is selected), there is no > message. > > BTW, the title subject of this report is incorrect. It is _not_ about too > many rows, but about too many columns, and the only requirement is to have > "too many columns selected by the time the file is saved as xls" in order to > trigger the message. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 --- Comment #42 from gmarco --- Well, the substance doesn't change and perhaps it becomes more complicated, selecting only line 1 and saving the file as xls this is the result: - saving with [CTRL]+[S] everything is OK - saving with [CTRL]+[Uppercase]+[S] the warning is (translated from IT): "Be careful when saving the test document: The document contains more columns than the limit supported in the selected format. The excess columns have not been saved." NOTE: IT SAYS columns ! but ... selecting only column A and saving the file as xls with [CTRL]+[Uppercase]+[S] the warning is: "Be careful when saving the test document: The document contains more lines than the limit supported in the selected format. The excess lines have not been saved." NOTE: IT SAYS lines ! I confirm that the problem occurs only when saving the file with SAVE AS changing the name and every time after that it is re-saved with SAVE AS changing the name again. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 --- Comment #43 from gmarco --- I add: same problem also opening a new sheet [CTRL]+[N] and copying only the used cells A1:P305 there, then selecting a column or a row and saving it as xls with a different name. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 --- Comment #44 from ady --- (In reply to gmarco from comment #43) > I add: > same problem also opening a new sheet [CTRL]+[N] and copying only the used > cells A1:P305 there, then selecting a column or a row and saving it as xls > with a different name. You don't need to copy anything. When starting Calc with a new (yet to be saved for the first time) spreadsheet, and then selecting entire rows (or entire columns), the first save (as) with a new name will trigger the message. IOW, by just _selecting_ more rows or more columns than xls supports, the xls filter attempts to save all those selected columns/rows as if all of them were part of the active range, while in fact they are only selected. The behavior I am describing here is not not present in AOO and was not present in LO 3.3. It is indeed present in LO 4.4. I have not tested versions between them. Maybe by solving the "selection-only" part of the problem will solve the original problem too, with simpler STR. ATM most of the 40+ prior comments in this report seem obsolete by now. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 --- Comment #45 from gmarco --- ... and then? Just for information, as of today I have no more potentially affected xls files. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 --- Comment #46 from ady --- (In reply to gmarco from comment #45) > ... and then? > > Just for information, as of today I have no more potentially affected xls > files. One possibility would be to open a new bug report, with the following STR: 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. Expected result: Avoid either of the 2 possible warnings 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 R256C65536). Then this bug 92164 could be set as "See also" of the new one (not as duplicate, just in case, unless QA team decides it is what it should be). Advantages: * simple STR, * covers the 2 possible warnings (i.e. both cases should be solved), * no need to read 40+ comments (most of them obsolete by now). Having said that, I would rather have some feedback/comment about this suggestion from someone from the QA team before doing anything of that sort. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 --- Comment #47 from gmarco --- (In reply to ady from comment #46) Following up on my comment 45, as I said, I'm personally no longer affected by the problem (it was from 2015) and you can do what you prefer. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 ady changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||5007 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 Buovjaga changed: What|Removed |Added Summary|FILESAVE: excessive number |FILESAVE XLS Excessive |of rows warning saving .xls |number of rows warning (see ||comment 10) CC||todven...@suomi24.fi Keywords|preBibisect, regression |filter:xls OS|Windows (All) |All Version|4.3.0.4 release |Inherited From OOo --- Comment #33 from Buovjaga --- Warning is already present in 4.2.0.0alpha1 (first commit of win32-4.3 bibisect repo) What's more, the warning is present already in 3.5.0 and 3.3.0! What's EVEN more is that the warning is also present on Linux!!@@ Arch Linux 64-bit Version: 6.3.0.0.alpha0+ Build ID: 9030ffb1a1b282eb2c6d1773930b0de0d42df447 CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3; Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US Calc: threaded Built on 13 April 2019 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 --- Comment #34 from QA Administrators --- Dear gmarco, 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://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 --- Comment #35 from gmarco --- Repeating the case as per comment #10 nothing has changed (LO 7.1.1.2): see attached scr.shot. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 92164] FILESAVE XLS Excessive number of rows warning (see comment 10)
https://bugs.documentfoundation.org/show_bug.cgi?id=92164 gmarco changed: What|Removed |Added CC||gmmell...@inwind.it --- Comment #36 from gmarco --- Created attachment 171188 --> https://bugs.documentfoundation.org/attachment.cgi?id=171188&action=edit last screenshot -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs