Issue 120818 - When import the saved .ods file which contain duplicate names, it will not update and refresh the formula result
Summary: When import the saved .ods file which contain duplicate names, it will not up...
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 4.0.0-dev
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2012-09-05 06:16 UTC by Terry Yang
Modified: 2012-10-09 08:16 UTC (History)
2 users (show)

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

Sample (12.04 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-09-05 06:16 UTC, Terry Yang
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Terry Yang 2012-09-05 06:16:43 UTC
Created attachment 79292 [details]

Find this bug 120478:Name Scope enhancement for spreadsheet
In this Enhancement there have a 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.
Comment 1 Terry Yang 2012-09-05 06:19:38 UTC
Build:AOO Trunk Revision :1380503 
Add build info
Comment 2 Terry Yang 2012-09-07 03:29:36 UTC
This bug is about when import .ods file, AOO can't refresh after open the file.
Comment 3 zhaoshzh 2012-09-13 07:57:00 UTC
Can be refreshed on the Aoo version of 20120904.
the root cause is my testing executed in read-only mode.
Comment 4 Terry Yang 2012-09-13 07:58:47 UTC
Change the status
Comment 5 Shenfeng Liu 2012-10-09 08:16:02 UTC
Let's me clarify, if this defect is due to test environment, we should not set Resolution as FIXED. The FIXED means there is code change in the product.
So I changed it to INVALID. Please tell me if any one has any concern.