Hi,
Thanks for looking into this issue.
I notice that 75877 has issue type of ENHANCEMENT. However I would say
this is definitely a DEFECT for the following reasons:
Conditional formatting used to work correctly in all previous versions.
This is a "Show Stopper" for anybody relying on conditional formats
involving formulae.
The issue is definitely related to conditional formats.
If I remove conditional formats recalculation returns to normal speed.
I have provided a sample spread-sheet to [EMAIL PROTECTED] We
have many large sheets which make extensive use of conditional formats for
error checking.
It seems that the conditional format algorithm has been broken in 2.2.
Seems to be evaluating for all cells not just the visible cells.
Also the range of the conditional format affects the speed. If the range
of the conditional format is an entire column, even though there only 3000
cells with data and formulae, recalculate may never complete. If you
change the range of the conditional format to just 3000 cells
recalculation may eventually complete.
Previous versions did not have this behaviour.
Looking forward to testing a fix for the next release.
Regards,
elindsay.
On Tue, 22 May 2007 16:51:29 +1000, <[EMAIL PROTECTED]> wrote:
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=76880
User gercokees changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |DUPLICATE
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue May 22
06:51:28 +0000 2007 -------
Hi,
Thanks for your report. You can help us making OOo better!
1) If this works better in OOo 2.1 than in OOo 2.2 i would say this is a
regression bug. Can you please confirm?
2) I will mark this as a duplicate of Issue 75877. Please add your
comments
there to keep everything together.
Greetz,
Gerco-Kees
*** This issue has been marked as a duplicate of 75877 ***
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
