Hi,
On 2007-05-22, at 23:02 , [EMAIL PROTECTED] wrote:
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]
You have responded to an automatically generated message from the
Issue Tracker. You cannot respond directly to these messages. Please
log onto the website, go to the issue, and enter your comments in the
Additional Comments box. When you are finished with your edits to the
issue, click the submit button to update the issue report with your
comments. This is how we keep all notes related to issues organized
and available to all in the community.
To see the Additional Comments box on the issue report, you must be
logged in, and your cookies must be enabled. Type in your user name
and password into fields displayed in the upper right corner, then
click the Login button. If you do this from the Home page, you may
have to click Login again on the Login Page. When you are logged in,
it will show that you are Logged In, and there will be a button
displayed in the upper right corner for you to click when you are
ready to log out.
Once you are logged in, you will be presented with a page called My
Start Page under the My Pages tab, and the left menu will show links
to tools. You can jump directly to your issue, by typing a number in
the input box in the right column of My Start Page, or you can select
My Issues from the Tools menu to see a list of your issues with an
open status. You can show a list of *all* your issues by choosing
'Edit Query' and selecting additional choices in the Status field, by
clicking on them with your Control key pressed down, then click on
'Submit Query'.
To send attachments regarding issues, please attach the file directly
to the issue. Use the link "Create a new attachment" on the issue and
then select Binary file (application/octet-stream) where asked, "What
kind of file is this?" if your file's type does not show in the list.
Thanks,
The OpenOffice.org Team
---------------------------------------------------------------------
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]
