To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=59423
User ecastro changed the following:
What |Old value |New value
================================================================================
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Fri Dec 16 02:31:53 -0800
2005 -------
The issue is reproducible on OOo2.0 series on Windows and Linux.
The offending part is range O4:O24 that contains circular references. Deleting
this range (or the circular reference within that formulas) eliminates the
problem. I have tried to bypass it writing in a non-circular form (see attached
Bio_20051213_issue-2.sxc). However, the formulas emit a "result not converge"
message in the status bar and spreadsheet stops updating. I have observed that
simply going to Tools>Options>calc>Calculate>Iterations and changing either
setting will immediatly freeze spreadsheet updating.
OOo 1.1.4 and MS-Excel XP obviate the issue, they simply declare ERROR on that
formulas and the rest of the sheet continue to work properly. I am confirming
this as NEW bug since I think this behaviour is safer than alowing spreadsheet
freezing. This issue is related to #23446, that is quite old (2 years)
On the other hand, I do not understand the purpouse of the calculation.
Please volkerme, could you explain the rationale of formulae in O4:O24, what
calculation are you interested in? Perhaps can be done in another way.
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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]
