Created attachment 59803 [details] slow in formula "procv" When i create a comparation between 2 sheets and use the formula "procv", the libreoffice calc hangs for a long time. When i open the same file in "Microsoft Office" is 85% more fast. Try with the file I sent in attach, take a look in the sheet "Analise". Thanks
Confirmed with: LO 3.5.6.2 Build ID: own W7 debug build Windows 7 Professional SP1 64 bit Very slow opening of the file, stuck for minutes at Adapt Row Height.
With LO 3.6.1 the problem is the same.
I can confirm this. I have too a file what is very slow in the calculation in the sheet and hangs by calculation, when i change a cel in calc. I have check it in excel and there was no problem. The sheet have different formulas. LO 3.6.1.2 windows 7 professional 64 bits
NEW per comment 3.
** Please read this message in its entirety before responding ** 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 on a currently supported version of LibreOffice (4.3.5 or later): https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) Thank you for your help! -- The LibreOffice QA Team
Now i'm using Version 4.4.0.1 pt_PT, Windows and Linux, and the problem continuous. Windows 7 Sp1 x64 pt_PT Linux Ubuntu 14.04LTS 64bits
(component calc)
** Please read this message in its entirety before responding ** 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 http://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
Changed the locale function name PROCV to the default English function name. Opening attachment 59803 [details] on a 6 year old Windows machine (with Windows 10) with LibreOffice version 5.4.7 takes about 6 seconds, which IMO is not very slow given the almost 26000 calls to VLOOKUP. Opening attachment 59803 [details] on an 8 year old Linux machine (with openSUSE Leap15) with LibreOffice version 6.0.4 takes about 6 seconds too. Since reporting this bug some fundamental improvements in the efficiency of Calc have been implemented. @Rui Simoes: Do you still experience extreme slow opening of attachment 59803 [details] when using a recent version of LibreOffice (i.e 5.4 or 6.0)?
(In reply to Winfried Donkers from comment #9) > Changed the locale function name PROCV to the default English function name. > > Opening attachment 59803 [details] on a 6 year old Windows machine (with > Windows 10) with LibreOffice version 5.4.7 takes about 6 seconds, which IMO > is not very slow given the almost 26000 calls to VLOOKUP. > Opening attachment 59803 [details] on an 8 year old Linux machine (with > openSUSE Leap15) with LibreOffice version 6.0.4 takes about 6 seconds too. > > Since reporting this bug some fundamental improvements in the efficiency of > Calc have been implemented. > > @Rui Simoes: Do you still experience extreme slow opening of attachment > 59803 [details] when using a recent version of LibreOffice (i.e 5.4 or 6.0)? I'm using now the 6.0.4 version and de VLOOKUP formula runs like expected with no problem.
(In reply to Rui Simoes from comment #10) > I'm using now the 6.0.4 version and de VLOOKUP formula runs like expected > with no problem. Thank you for your feedback. OK, I will set this bug report to RESOLVED/WORKSFORME.