To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=83917
Issue #|83917
Summary|Empty cells referenced through an array are incompatib
|le with Excel
Component|Spreadsheet
Version|OOo 2.3
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|ui
Assigned to|spreadsheet
Reported by|jes
------- Additional comments from [EMAIL PROTECTED] Sat Nov 24 07:59:22 +0000
2007 -------
A range of cells where the user enters data may be referenced at a different
location for processing. It is convenient to 'copy' the entry data using an
array formula, the results of which are then processed.
If the source area contains empty cells, the array result in Calc is different
than what Excel produces. In Calc the empty cells test as empty strings, whereas
in Excel the empty cells are numeric zero.
This difference can lead to failure of Excel sheets opened by Calc.
The difference can be worked around using an explicit test. If the array formula
in Excel is {=A1:A3}, it may be changed to {=IF(ISBLANK(A1:A3}; 0; A1:A3}.
This problem may be related to Issue 32340
---------------------------------------------------------------------
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]
