Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Empty argument appears in the end of a formula, the argument should use a number '0' to instead. | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | binguo <binbjguo> | ||||
Component: | open-import | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Normal | ||||||
Priority: | P3 | CC: | rb.henschel | ||||
Version: | 3.4.1 | ||||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
See solution about Bug 119942: https://issues.apache.org/ooo/show_bug.cgi?id=119942 |
Created attachment 79790 [details] Sample file created by MS Excel 2007 Build: Aoo_Trunk\Aoo_Trunk_20121012.1800 Steps: 1. New a excel document, in a cell input formula =AVERAGEA(1,2,3,) 2. Save it and load in Spreadsheet Defect: The last comma is removed, and result is different with MS Excel. Expected: The last comma maybe removed, but result should be the same as that in MS Excel. Notes: 1. It does not occur on =AVERAGE(1,2,3,). 2. It does not occur on =AVERAGEA(,1,2,3) OR =AVERAGEA(1,2, ,3).