To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82725 Issue #|82725 Summary|Same empty cell evaluted differently when referenced d |irectly vs through (v)lookup Component|Spreadsheet Version|OOo 2.2 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|ronleach
------- Additional comments from [EMAIL PROTECTED] Wed Oct 17 17:29:36 +0000 2007 ------- An empty cell is evaluated as '0' (numeric zero) when directly referenced (eg such as 'J10') but is evaluated as <something else (I do not know what but NOT a zero)> when that same cell is referenced indirectly as the result of a vlookup. Subsequent cells that depend on or use the 'zero' give one result if the cell was directly referenced but another result of the cell has been looked up. I found this issue when trying to run a financial model implemented in Excel under OOo. The behaviour of OOo is consistent with Excel when the empty cell is directly referenced, but inconsistent with Excel when referencing empty cells through a 'lookup'. I have prepared a very simple spreadsheet which shows the inconsistency. A simple data table is shown highlighted in orange. (The data table contains numbers, text, and an empty cell.) Two different references to that data are shown highlighted in green. The 'looked up' reference to an empty cell gives a blank, while the direct reference to the same empty cell gives a zero. At the bottom of the sheet a simple test checks whether two answers are consistent or inconsistent. I have run this on 2 different PCs, one under Debian Etch and OOo 2.0, the other under Windows 98 OOo 2.2, with the same result that OOo is returning different numeric values depending on the nature of the cell reference. Apologies if this report is a duplicate - I found lots of reports about 'empty cells' - mostly fixed in fact - but nothing that suggested that anyone else had reported inconsistent answers from the same cell depending on the manner of cell access. Apologies, also, if this issue has already been dealt with - I only have dialup, and cannot easily obtain either 2.3 for Windows, or a backport of OOo 2.x for Debian Etch / 4 / stable. regards, Ron (grateful for what is being achieved, wishing the team all the best) --------------------------------------------------------------------- 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]