To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=82725
------- Additional comments from [EMAIL PROTECTED] Thu Oct 18 09:37:11 +0000 2007 ------- Additional information: Gnumeric 1.6.3 on Debian 4 is consistent in its evaluation of an empty cell; Gnumeric returns the same value regardless of whether the reference is 'direct' or 'via lookup'. (It is this inconsistency in OOo that is the issue raised in this report.) I tried and failed to check what KOffice did - KOffice uses an '@' function similar to early Lotus 123, and my first attempt at @LOOKUP failed - I think I have forgotten how to define a range in Lotus, it has been so long since I used it. My version of Corel Office (v8) does not read xls files so I have not been able to check what Corel does. Is it relevant or helpful to check whether other competitor applications handle cells consistently? - if it is, I will try to create an L123 equivalent to run through KOffice and Corel to see what they do so I can report back. Incidentally, Gnumeric evaluates empty cells to 'zero' in the same manner as Excel does. I don't really think the problem of inconsistency in OOo can be put down to a 'bug in Excel', or even to any uncertainty on the part of a user as to his intentions in processing sparse data arrays. As a user, I strongly recommend that the application handles cells consistently. And as an advocate of OOo, may I plead that the application handles empty cells in the same manner that Gnumeric and Excel do, so that those of us working with Governments and the Consultancies worldwide can be confident that existing models and spreadsheets using in-built functions will run? regards, and thanks for taking the time on this. Ron --------------------------------------------------------------------- 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]
