Description: I'm having a Writer document that mainly consists of a very big table. The table has 3 columns and 21895 lines. It increases each week by about 30 lines, as I add new entries. Each week I select the whole table and do a sorting (extras / Sort). At some point in time (as the table exceeded about 21000 lines) I noticed that sorting went wrong for about 40 lines: - several lines get lost - for other lines the cells are moved, so that e.g. text that was in column 2 was moved to column 1 or 3 I reduced the number of lines of the file by about 1000 lines: Then the sorting was correct again. The occurrence of the problem was reproducible. Steps to Reproduce: 1. File is ok, number of lines is about 21000. Sorting is ok 2. Increase number of lines of the file to about 21900 lines 3. Do sorting and check outcome manually by walking through the file: About 40 lines are wrong Actual Results: Sorting is wrong for about 40 lines. Text that was in column 2 has moved to columns 1 or 3. Expected Results: Sorting is ok, no text gets moved to other columns. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: If helpful, I could provide the file that showed the problem
Hello, Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document. (Please note that the attachment will be public, remove any sensitive information before attaching it.) How can I eliminate confidential data from a sample document? https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F Thank you
Created attachment 157892 [details] This is the file that shows the problem. It is in this state before sorting. I did sorting this file. Sorting was per column 2, upwards.
I tried to reproduce it, but writer freezed, when I tried to open your document. It also seems, that you use an old version of LO. If this is the case, please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/
(In reply to Dieter from comment #3) > I tried to reproduce it, but writer freezed, when I tried to open your > document. confirming, tried to open with LO 6.0.7.3 but freezes. Btw: The document contains 7 file "version" (-> "File/Version...")
After more than five minutes the document was open, but you really can't work with this document (LO always becomes unresponsive). Document has a size of more than 12 MB (but only around 95 pages). Does it contain images? If this is the case, could you please remove them, so we can work with it?
No, sorry, the file has no images I could remove. It consists of a single table containing about 21900 lines and three columns. I edit this table once per week. I know, some patience is necessary. Also sorting takes several minutes (measured the time now for loading on my computer: 6 minutes 40 seconds). May be, when it's loaded, it might take some additional time until you can work with it, but then it's no problem. Of course, as I wrote above, sorting takes relatively long time, also saving it takes, I guess, 10 to 20 seconds (and saving reveals a memory leak).
Perhaps, anybody else can help. I'm not an expert, but I think, there is something wrong with your document. 12MB ist too much I think, although the table is really huge.
Thanks to Oliver who recognized that the file has 7 "versions", I was not aware of this. I removed all versions and will upload now the new file that has 1.6 MB only now. I was sorting the new file as usual, the outcome shows the same problems.
Created attachment 157942 [details] Same file as previously, all versions are removed, so it's much smaller now.
(In reply to Fritz Schmidt from comment #0) > - for other lines the cells are moved, so that e.g. text that was in column > 2 was moved to column 1 or 3 (In reply to Fritz Schmidt from comment #2) > Sorting was per column 2, upwards. Reproduced with attachment 157942 [details]. Considered regression testing, but the file takes seemingly forever to open with 4.4 so I won't bother. Arch Linux 64-bit Version: 7.0.0.0.alpha1+ Build ID: c73418d8d1258ea0a8c77c07672fd182e2b28b26 CPU threads: 8; OS: Linux 5.6; UI render: default; VCL: kf5; Locale: fi-FI (fi_FI.UTF-8); UI: en-US Calc: threaded Built on 9 May 2020
Dear Fritz Schmidt, 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
I retested this using LibreOffice 7.2.7.2: The problem is still present. I generated a new file that is much smaller and so eases testing. Loading the new file is relatively quickly, however sorting still takes some time. I did some more testing and found out that the problem happens when the line count of the table in the file exceeds 21845 lines. I will provide this new file named Table-21846Lines.odt. When selecting the complete table and sorting it, the problem happens: - line 1 is wrong: 1 - 1 - 10 - this line is wrong too: 21846 - 21846 - 1 - and this one too: 21846 - 10 - 10 The numbers in the three columns have different colors, so the error can be seen more easily now. If the last line of the table is removed, so that the table has 21845 lines, the sorting result is ok. I would like to ask somebody who has the rights to do this to remove my originally file provided and to substitute it by this new one. (Reason: New one is much easier for testing, old one is somewhat private ...). Thanks.
Created attachment 180377 [details] Please see my previous comment, testing is much easier now Please see my previous comment, testing is much easier now. Please substitute original files by the new one.
The content of attachment 157942 [details] has been deleted for the following reason: Uploader request
The content of attachment 157892 [details] has been deleted for the following reason: Uploader request