Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Text evaluated as zero in formulae | ||
---|---|---|---|
Product: | Calc | Reporter: | groundczero <groundczero> |
Component: | ui | Assignee: | spreadsheet <spreadsheet> |
Status: | CLOSED DUPLICATE | QA Contact: | issues@sc <issues> |
Severity: | Trivial | ||
Priority: | P4 | CC: | issues, sjb |
Version: | OOo 1.1.3 | Keywords: | oooqa |
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | Windows XP | ||
Issue Type: | DEFECT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
groundczero
2004-10-19 17:04:53 UTC
Hi groundczero: I would tend to agree here. For the development team, here is a comparison of the way that OOo (both 1.1.3 and m56) and MS Excel (2000) handle these situations. MS Excel seems to give more sensible errors in each case: A1=22 [a number] B1=a [text] FORMULA OOo EXCEL -------------------------------- =A1/B1 Err:503 #VALUE =22/a #REF #NAME =A1*B1 0 #VALUE =22*a #REF #NAME According to OOo help, #VALUE should be displayed when a cell that is referenced in the formula contains text instead of a number, and so this seems most appropriate in cases 1 and 3. As you indicate, it appears that the text is being evaluated as a zero value by Calc. #NAME should be displayed when no valid reference / column or row label is found. However, cases 2 and 4 are more debatable -- at least #REF indicates that the user may have entered an incomplete cell reference. Have changed subcomponent to the more general 'ui', and modified the summary slightly -- hope that's ok. Hi, Point 1) Err:503 vs #VALUE : The Error 503 (Illegal floating point operation) is much more productive than #VALUE as you can much easier determin what's going wrong. VALUE just states that there is a problem with the calculation but the Error message (in the statusbar) just tells you that you try to calculate with a wrong type of data. Point 2) #REF vs #NAME : a single 'A' is just a broken Refference, so the 'REF is more appropriate than #NAME. Point 3) This is a double to Issue 5658 Point 4) It's the same as Point 2) Frank *** This issue has been marked as a duplicate of 5658 *** closed double |