https://issues.apache.org/ooo/show_bug.cgi?id=120818
Priority: P3
Bug ID: 120818
Assignee: [email protected]
Summary: When import the .ods file which contain duplicate
names, it will not update and refresh the formula
result
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: [email protected]
Hardware: All
Status: CONFIRMED
Version: AOO350-dev
Component: open-import
Product: spreadsheet
Created attachment 79292
--> https://issues.apache.org/ooo/attachment.cgi?id=79292&action=edit
Sample
Find this bug 120478:Name Scope enhancement for spreadsheet
In this Enhancement there have a limitation
Limitation:
1. If duplicate names are used in a formula,save file to ODF format, the
formula for the name("aaa") defined in a sheet is of:=SUM(aaa) the formula for
the anme defined in a workbook is of:=SUM(aaa) if reload the exported file to
Aoo,all will be marked as the name in a sheet.
But In my testing, when i Import the sample file and save it to .ods, then
reload the .ods file in AOO, i find the formula result are correct, this is not
as the Limitation description.
--
You are receiving this mail because:
You are the assignee for the bug.