To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=100252
                 Issue #|100252
                 Summary|Error 522 only after a save or autosave. Perfect other
                        |wise.
               Component|Spreadsheet
                 Version|1.0.3
                Platform|Other
                     URL|
              OS/Version|Linux
                  Status|UNCONFIRMED
       Status whiteboard|
                Keywords|
              Resolution|
              Issue type|DEFECT
                Priority|P3
            Subcomponent|save-export
             Assigned to|spreadsheet
             Reported by|billgradwohl





------- Additional comments from [email protected] Tue Mar 17 
00:20:06 +0000 2009 -------
I have a spreadsheet that always produces a 522 error (circular reference) ONLY
immediately after either a save or autosave. 

The sheet works flawlessly until I either force a save or the system autosaves
for me. Then the next cell I touch causes a cell relying on it to fail with a
522 error. If I rekey that same cell with a different value the error goes away.
If I ctrl-shift-F9 the error disappears and the correct answer appears. 

This only happens immediately after a save or auto save.

The fact that I can rekey the cell or force a sheet recalc and that clears it up
should prove that the 522 is bogus. I wrote the spreadsheet and its largely a
data entry screen as a few thousand lines of macro code actually make everything
happen. The actual cell calcs in it are trivial.

When I was using V2.4, I believe, The same thing would happen if I tried using
full screen mode. In a normal screen, everything worked fine. As soon as I tried
full screen mode it would fail on a 522. Put back to regular and the sheet
worked flawlessly. I just gave up on full screen mode and waited for the latest
version, but now I have a similar 522 issue in regular mode.

I can reproduce the error every time. I force a save and the error appears. I
rekey the same cell and all is well. Every time.

BTW - I'm running Version 3.0 of OpenOffice. I have no idea what "version" of
calc that is. When I ask calc it says build 9379. I hope that clears up any
version issues.

---------------------------------------------------------------------
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]

Reply via email to