Bug 48552 - Slow to process "PROCV" formula
Summary: Slow to process "PROCV" formula
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Libreoffice (show other bugs)
Version: 3.5.2 release
Hardware: x86-64 (AMD64) All
: medium critical
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-04-11 05:16 UTC by Rui Simoes
Modified: 2015-01-06 10:19 UTC (History)
1 user (show)

See Also:
i915 platform:
i915 features:

Attachments
slow in formula "procv" (1.21 MB, application/vnd.oasis.opendocument.spreadsheet)
2012-04-11 05:16 UTC, Rui Simoes 		Details
View All

Description Rui Simoes 2012-04-11 05:16:59 UTC 
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
Comment 1 bfoman 2012-08-31 13:06:02 UTC 
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.
Comment 2 Rui Simoes 2012-08-31 13:20:32 UTC 
With LO 3.6.1 the problem is the same.
Comment 3 vlb 2012-09-18 14:36:14 UTC 
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
Comment 4 bfoman 2012-10-11 12:50:23 UTC 
NEW per comment 3.
Comment 5 QA Administrators 2015-01-05 17:52:24 UTC 
** 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
Comment 6 Rui Simoes 2015-01-06 10:19:27 UTC 
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

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.