To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=104175 Issue #|104175 Summary|Ref to blank cell behaves differently than Excel Component|Spreadsheet Version|OOo 3.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|viewing Assigned to|spreadsheet Reported by|luke_d
------- Additional comments from [email protected] Wed Aug 12 01:24:55 +0000 2009 ------- In Excel, a cell whose formula is a cell reference to a blank cell will have a value of zero. The value of this cell compares "not equal" to an empty string. In OpenOffice Calc, a cell whose formula is a cell reference to a blank cell will have some kind of hybrid value which looks like zero but also compares "equal" to an empty string. --------------------------------------------------------------------- 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]
