I may be using LO Calc incorrectly, or it's the wrong tool, but I now have 3 files that won't open and LO crashes with timeout "waiting for threadpool tasks". When one file wouldn't open, I created a new file and saved copies at each step. The first sheet has a large amount of data -- 81,000 text rows that were filtered into a 2nd sheet, and further reduced in size to a 3rd sheet. I learned in the process that SUMPRODUCT can't handle a large number of rows, but I managed to get my results in stages of adjusting the range. A sample formula: =SUMPRODUCT($D$2:$D$1092=D3,$j$2:$j$1092=$B$2:$B$1092) It took quite a while to get through the file. I can once again create a new file, but I need to know what is causing the crash so I can avoid the problem on yet another file. CGH
Which LO version did you use? Please copy information from Menu "Help/About LibreOffice" To be certain the reported issue is not related to corruption in the user profile, could you please reset your Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and re-test? If the bug is still present please attach a sample document, as this makes it easier for us to verify the bug. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.) I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the issue is still present
Created attachment 152691 [details] Sample of original data
Version: 6.2.4.2 (x64) Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64 CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; Locale: en-US (en_US); UI-Language: en-US Calc: threaded I'm a new user. See https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=98440&p=472895&e=472895 for a discussion of what I'm trying to do, and the solution. The problem in opening the file occurs during "Adapt row height". There are 81,000+ rows in the failing file on Sheet1. Resetting the profile to factory settings did not solve the problem. I also experienced the problem while doing drag fill in a column where I'm using SUMPRODUCT. In about the middle of the file, after changing the range in the formula, I went beyond the range in the formula with the drag fill. CGH
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to res06atk@verizon.net from comment #3) > The problem in opening the file occurs during "Adapt row height". attached file does not contain formulas, and it has only 35 rows. please attach a sample where we can reproduce the problem.
The file in question has 81,000 rows and contains names, userids and DNA identifiers, as well as URLs that contain some of this info. I can't anonymize it, even a subset, without adding irrelevant formulas. I have been able to open a 3rd copy that I could upload to Dropbox, but I don't want it to be public.I haven't experienced the problem on smaller files with similar formulas. The formulas I used are the same ones in the forum posts I included earlier.I think the size of the file is part of the problem.
What are the limits of SUMPRODUCT? LO CALC again crashed with Fatal Error: timeout waiting for threadpool tasks I was working on a file with 350,000+ rows and performing this formula: =SUMPRODUCT($D$220000:$D$260100=D240929). The data in this file looks like the sample I've already uploaded. D=matchid. I had already gone through the file and executed =D2<>D3. Is there a limit on how many rows are included in an array? Or, is there a limit on how many rows can be selected using Drag Fill? I think one of these is the culprit.
Attached document opens fine in Version: 7.0.0.0.alpha0+ Build ID: 28d844a589e52abfe62dc66b888e78665221ba28 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); UI-Language: en-US Calc: threaded Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
I'm sorry, but I'm no longer working on that project and won't be able to test for the bug.
Then we have to close