Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Equals, setting, testing unset values | ||
---|---|---|---|
Product: | Calc | Reporter: | drc <drc> |
Component: | code | Assignee: | bettina.haberer |
Status: | CLOSED NOT_AN_OOO_ISSUE | QA Contact: | issues@sc <issues> |
Severity: | Trivial | ||
Priority: | P3 | CC: | issues |
Version: | OOo 1.1 RC3 | ||
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
drc
2003-08-22 23:30:54 UTC
Hi Chris, this is a different design philosophy between Excel and OOo. So this is not a defect but an enhancement. So I set the flags and reassign it to the feature guys. Frank It may be the intention that an unset cell is zero, but that is not the case for PRODUCT(). I think there is an inconsistency in the internal representation of cells - or in the implementation of PRODUCT(). If you enter this formula into cell A1: '=PRODUCT(B1:C1)' Cells B1 and C1 are both unset. The result is - as expected - zero. However, enter '42' into B1 and the result is '42'!! That is not the behaviour I want or expect from a function like PRODUCT(). If you set C1 equal to an unset cell result zero appears. I havn't looked at the code, but either there is an error in PRODUCT () implementaion or a flaw in the cell implementation for un- initialised cells. First of all: Calc behaves identical to Excel in this case. One of our main requirements is to be as compatible as possible in functionality, also known as interoperability, therefore we will not change this behavior, and I'll close this issue. Now some details: Of course also Excel displays a 0 if a cell references an empty cell like =A1. I don't know how you encountered the opposite by other means than unchecking the "display zero values" option. Regarding your PRODUCT() example, even that behaves identical to Excel. And you simply don't want empty cells in a range to be calculated as zero in this case. Expand your example to the AVERAGE() function, would you like to have AVERAGE() calculate empty cells as zero? I don't think so. And neither does the competetive product. closing Created attachment 73509 |