Edit: Hagar: changed the title and corrected the error code as said by OP (removed that post). |
[Solved] Error code "err: 522" in spreadsheet
[Solved] Error code "err: 522" in spreadsheet
I regularly get err:522 appear in the cells in Calc for the current file i have been working on. If I place the cursor over the cell with the error code, the formula in the cell appears correct. If i retype the formula again into the cell, or drags the formula from the adjoining cell if it is a row with the same formula, then the correct results appear in that error cell. Sometimes I notice the err code re-appear in the same cell, and i have to re-type the formula again. Please see the attached tif file for sample of the problem. How can I eliminate this problem? This is quite a large model and it is quite disconcerting for the audience to see error codes randomly peppering the model. Thank you for your help.
- Attachments
-
- err 552.tif (40.53 KiB) Viewed 57737 times
Last edited by johnlim on Tue Aug 12, 2008 6:29 pm, edited 1 time in total.
OOo 2.4.X on Ms Windows XP
Re: err: 552
See F1 online help, OpenOffice.org Calc, error codes
Check Tools>Options>OpenOffice.org Calc>Calculate and activate "Iterations".
Does this help?
Check Tools>Options>OpenOffice.org Calc>Calculate and activate "Iterations".
Does this help?
Re: Error code "err: 522" in spreadsheet
Thank you Winfried.
Yes, that seem to solve the problem.
Yes, that seem to solve the problem.
OOo 2.4.X on Ms Windows XP