To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=45456
Issue #:|45456
Summary:|unstable internal error ERR:527 / internal overflow
Component:|Spreadsheet
Version:|OOo 1.1.4
Platform:|PC
URL:|
OS/Version:|Windows XP
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|viewing
Assigned to:|spreadsheet
Reported by:|rustleg
------- Additional comments from [EMAIL PROTECTED] Fri Mar 18 13:58:21 -0800
2005 -------
When opening this spreadsheet a cell (E20) in one of the sheets ("Calc") has
error code ERR:527 instead of a value in the cell. The message "Error: Internal
Overflow" appears in the bottom right hand corner message area.
This cell will then revert to a correct value if (a) you switch windows or (b)
move the view so that the cell is off the page then move it back to see the cell
or (c) hit F9 to recalculate.
I suspect the cause is in VLOOKUP(Search criterion;array;index;sort order),
specifically when the sort order is zero (FALSE). I say this because I have had
other trouble with a later version of this spreadsheet where this function
returns #N/A when there are multiple instances of what it is looking for (if you
want me to post an example of this please let me know, unfortunately it is also
unstable and only sometimes doesn't work). I suggest you focus on the formulae
in columns R and W.
---------------------------------------------------------------------
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]
