To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=63452
User gercokees changed the following:
What |Old value |New value
================================================================================
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Tue Mar 20 08:15:52 +0000
2007 -------
Hi,
I can confirm this behavour. To reproduce follow the following procedure (force
frequent autorecovery saving, toggle a simple basic function, use the function a
lot in the sheet and recalculate, so that an autorecovery-saving is done in the
end of the calculation...)
0) Start a worksheet, save it somewhere
1) Goto: Tools > Options > Load/Save > General > Check autorecoveryinformation
and choose: 1 minute.
2) Goto: Tools > Macros > Organize macros > OpenOfice.Org Basic > New and enter
the following function:
Function test(one, two)
tmp = iif(one <> 0, 1, 2)
test = 0 + tmp * two
End Function
3) In your sheet, in cell a3 enter: =test(0;1)
4) Copy cell a3 down until cell 1003
5) In cell a1 enter: sum(a3:a1003)
Now, force a recalculation a few times (use {ctrl}+{f9}
when an autosave is performed during a recalculation, one of the 1000 cells
contains an error: Err522. You can see that in cell a1 ofcourse.
The workaround for this is to save the sheet, just before recalculating it, so
that no autosaving is performed during the calculatingproces (ofcourse set
autosaving to 15 minutes then...)
Greetz,
---------------------------------------------------------------------
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]
