https://issues.apache.org/ooo/show_bug.cgi?id=124828
Issue ID: 124828
Issue Type: DEFECT
Summary: ZÄHLENWENN() returns incorrect result when
Excel97-export is opened with Excel2010
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Windows XP
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: save-export
Assignee: [email protected]
Reporter: [email protected]
Created attachment 83341
--> https://issues.apache.org/ooo/attachment.cgi?id=83341&action=edit
Contains 2 screenshots (Excel2010 and OpenOffice 4.0.1), and the exported
.xls-file
In the attached .xls-file the function ZÄHLENWENN() returns an incorrect result
when it is opened by Excel2010. In OpenOffice though the result is correct. The
.xls-file was exported from OpenOffice 4.0.1.
----------------------------------------------------------------------------------
The error might be connected to the fact that I use ZÄHLENWENN() on combined
cells, possibly resulting in multi-counts for every combined cell. In formula
F32
=F31/ZÄHLENWENN(B18:H18;"<>''")
ZÄHLENWENN() divides by 4 (4 combined cells) as it schould in OpenOffice,
whereas in Excel2010 it divides by 7 (the amount of uncombined cells in range).
----------------------------------------------------------------------------------
I already checked release 4.1.0 and the error still occurs.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
