Issue 121230 - Empty argument appears in the end of a formula, the argument should use a number '0' to instead.
Summary: Empty argument appears in the end of a formula, the argument should use a num...
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.1
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-10-18 07:30 UTC by binguo
Modified: 2012-10-18 12:53 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
Sample file created by MS Excel 2007 (8.04 KB, application/octet-stream)
2012-10-18 07:30 UTC, binguo
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description binguo 2012-10-18 07:30:15 UTC
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).
Comment 1 binguo 2012-10-18 07:30:46 UTC
See solution about Bug 119942: https://issues.apache.org/ooo/show_bug.cgi?id=119942