To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102969 Issue #|102969 Summary|Distinguish an empty cell from a cell with a zero in a | Calc Basic function Component|Spreadsheet Version|OOO310m9 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|squenson
------- Additional comments from [email protected] Sat Jun 20 16:53:49 +0000 2009 ------- In OOo Calc Basic, when you create a function that refers to a range of cells, you can access the values in the range of cells in a variant array. For example: Function MyFunction(byVal vRange() as Variant) When you access the array vRange, you cannot distinguish the empty cells from the cells that contain a 0: both have a value 0. This is for me an issue and I think it would be better to use either "" (empty string) or 'null' or 'empty' when a cell is actually empty. Note that such behavior should not break any user-defined functions, as even if some developers have in the past relied in the fact that all values will be numeric, vRange(2) will return 0 in a mathematical expression if vRange(2) is empty. --------------------------------------------------------------------- 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]
