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...
Status: CLOSED NOT_AN_OOO_ISSUE
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:
URL:
Keywords:
Depends on:
Blocks:
 
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: ---

Attachments
Sample (12.04 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2012-09-05 06:16 UTC, Terry Yang 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

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]
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.
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.
Thanks!