Difference between revisions of "QA/Report/AOO3.5FeatureReport/NameRange"
m (external -> internal link) |
Terry Yang (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | + | =Calc name range enhancement= | |
| − | + | ||
| − | + | ||
| + | ==Introduce== | ||
| + | Calc name range enhancement: MS Excel can support worksheet scope defined name. Excel 2007 can define duplicate name for different sheet, while Excel 2003 cannot in its UI. When AOO loading an xlsx file which has duplicated defined name, AOO will only change the name. But any other place which uses the defined name is not changed, which will cause problems. This enhancement will support loading worksheet scope defined name from xlsx/xls file. | ||
This enhancement will be completed in 2 steps. | This enhancement will be completed in 2 steps. | ||
In step 1, we want to just focus on the interoperability of MS Excel range based defined name. | In step 1, we want to just focus on the interoperability of MS Excel range based defined name. | ||
| − | |||
When user open a Excel file which has range based defined name, the duplicated range name will be kept. AOO will use sheet scoped name in prior to workbook scoped name when do calculation. And some indicator is shown in name define dialog. | When user open a Excel file which has range based defined name, the duplicated range name will be kept. AOO will use sheet scoped name in prior to workbook scoped name when do calculation. And some indicator is shown in name define dialog. | ||
| − | |||
In step 1 we will not modify the ODF file format. When save Excel xls/xlsx file with sheet scoped defined name to ods file, AOO will rename sheet scoped defined name as "sheet_name" plus "defined name", like SheetName_DefinedName. | In step 1 we will not modify the ODF file format. When save Excel xls/xlsx file with sheet scoped defined name to ods file, AOO will rename sheet scoped defined name as "sheet_name" plus "defined name", like SheetName_DefinedName. | ||
| − | |||
In step 2, we want to support create worksheet scope defined name from GUI. We will refer the file format from LibreOffice if their implementation is in ODF standard or ODF standard candidate. | In step 2, we want to support create worksheet scope defined name from GUI. We will refer the file format from LibreOffice if their implementation is in ODF standard or ODF standard candidate. | ||
| − | |||
| − | |||
Now we only done step 1. | Now we only done step 1. | ||
| + | ==Wiki == | ||
Wiki link: [[Calc/Features/Calc_name_range_enchancement(step1)|Calc name range enhancement]] | Wiki link: [[Calc/Features/Calc_name_range_enchancement(step1)|Calc name range enhancement]] | ||
| − | + | ==Bug == | |
Bug id: [https://issues.apache.org/ooo/show_bug.cgi?id=120478 Issue 120478 ] | Bug id: [https://issues.apache.org/ooo/show_bug.cgi?id=120478 Issue 120478 ] | ||
| − | + | ==Test plan link == | |
| − | + | ||
| − | + | ||
Test plan you can find in [https://issues.apache.org/ooo/show_bug.cgi?id=120804 bug 120804] | Test plan you can find in [https://issues.apache.org/ooo/show_bug.cgi?id=120804 bug 120804] | ||
| − | + | ==Test case == | |
* Test case link store in TestLink Apache OpenOffice testproject/AOO Calc/NameRange | * Test case link store in TestLink Apache OpenOffice testproject/AOO Calc/NameRange | ||
| − | |||
[http://aootesting.adfinis-sygroup.org/index.php http://aootesting.adfinis-sygroup.org/index.php] | [http://aootesting.adfinis-sygroup.org/index.php http://aootesting.adfinis-sygroup.org/index.php] | ||
| − | + | ==Test execution result == | |
| − | + | ||
| − | + | ||
Total run 22 on Win7/XP/Mac/Ubuntu/Redhat/Suse 64bit | Total run 22 on Win7/XP/Mac/Ubuntu/Redhat/Suse 64bit | ||
| − | + | Execution result, pass rate(including first round pass rate, pass rate after defect fixed retest) | |
| − | + | ||
| − | + | ||
| − | + | ||
Pass 12, failed 10 pass rate 55% | Pass 12, failed 10 pass rate 55% | ||
| − | + | 10 case failed by '''[https://issues.apache.org/ooo/show_bug.cgi?id=120818 Bug 120818'''] | |
| − | + | ||
| − | + | ==Bug analysis == | |
{| class="prettytable" | {| class="prettytable" | ||
Revision as of 07:13, 12 September 2012
Contents
Calc name range enhancement
Introduce
Calc name range enhancement: MS Excel can support worksheet scope defined name. Excel 2007 can define duplicate name for different sheet, while Excel 2003 cannot in its UI. When AOO loading an xlsx file which has duplicated defined name, AOO will only change the name. But any other place which uses the defined name is not changed, which will cause problems. This enhancement will support loading worksheet scope defined name from xlsx/xls file. This enhancement will be completed in 2 steps.
In step 1, we want to just focus on the interoperability of MS Excel range based defined name. When user open a Excel file which has range based defined name, the duplicated range name will be kept. AOO will use sheet scoped name in prior to workbook scoped name when do calculation. And some indicator is shown in name define dialog. In step 1 we will not modify the ODF file format. When save Excel xls/xlsx file with sheet scoped defined name to ods file, AOO will rename sheet scoped defined name as "sheet_name" plus "defined name", like SheetName_DefinedName. In step 2, we want to support create worksheet scope defined name from GUI. We will refer the file format from LibreOffice if their implementation is in ODF standard or ODF standard candidate.
Now we only done step 1.
Wiki
Wiki link: Calc name range enhancement
Bug
Bug id: Issue 120478
Test plan link
Test plan you can find in bug 120804
Test case
- Test case link store in TestLink Apache OpenOffice testproject/AOO Calc/NameRange
http://aootesting.adfinis-sygroup.org/index.php
Test execution result
Total run 22 on Win7/XP/Mac/Ubuntu/Redhat/Suse 64bit Execution result, pass rate(including first round pass rate, pass rate after defect fixed retest)
Pass 12, failed 10 pass rate 55% 10 case failed by Bug 120818
Bug analysis
|
Bug ID |
Product |
Component |
Priority |
Status |
Summary |
|
SpreadSheet |
Open-import |
P3 |
CONFIRMED |
When import the saved .ods file which contain duplicate names, it will not update and refresh the formula result | |
|
SpreadSheet |
Save-export |
P3 |
CONFIRMED |
Define name which cell range in other file will saved incorrect to .xls and .ods | |
|
SpreadSheet |
editing |
P3 |
CONFIRMED |
AOO can't change define names, we can only change define names cell range |
