Difference between revisions of "QA/Report/AOO3.5FeatureReport/NameRange"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Created page with "* 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. Whe…")
 
(→‎Test execution result)
 
(16 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
* 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.  
+
=Calc name range enhancement=
−
 
+
==Reference:==
−
 
+
===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.
  
 +
===Wiki ===
 +
Wiki link: [[Calc/Features/Calc_name_range_enchancement(step1)|Calc name range enhancement]]<br />
 +
Bug id: [https://issues.apache.org/ooo/show_bug.cgi?id=120478 Issue 120478 ]&nbsp;
  
−
Now we only done step 1.
+
==Test plan==
 +
Test plan you can find in [https://issues.apache.org/ooo/show_bug.cgi?id=120804 bug 120804]
  
−
Wiki link: [http://wiki.openoffice.org/wiki/Calc/Features/Calc_name_range_enchancement(step1) Calc name range enhancement]
 
  
 +
==Test case ==
 +
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]
  
 +
{| class="prettytable"
 +
|-
 +
|
 +
Index
  
−
Bug id: [https://issues.apache.org/ooo/show_bug.cgi?id=120478 Issue 120478 ]&nbsp;
+
|
 +
Title
  
 +
|-
 +
|
 +
1
  
 +
|
 +
[http://aootesting.adfinis-sygroup.org/lib/testcases/archiveData.php?edit=testcase&id=159 Delete duplicate range names and ranges]
  
−
* Test plan link
+
|-
 +
|
 +
2
  
−
Test plan you can find in [https://issues.apache.org/ooo/show_bug.cgi?id=120804 bug 120804]
+
|
 +
[http://aootesting.adfinis-sygroup.org/lib/testcases/archiveData.php?edit=testcase&id=155 Update duplicate range names and ranges]
  
 +
|-
 +
|
 +
3
  
 +
|
 +
[http://aootesting.adfinis-sygroup.org/lib/testcases/archiveData.php?edit=testcase&id=151 Import and export .ods file which contain duplicate range names]
  
−
* Test case link store in TestLink Apache OpenOffice testproject/AOO Calc/NameRange
+
|-
 +
|
 +
4
  
−
[http://aootesting.adfinis-sygroup.org/index.php http://aootesting.adfinis-sygroup.org/index.php]
+
|
 +
[http://aootesting.adfinis-sygroup.org/lib/testcases/archiveData.php?edit=testcase&id=150 Import and export .xls file which contain duplicate range names]
  
 +
|-
 +
|
 +
5
  
 +
|
 +
[http://aootesting.adfinis-sygroup.org/lib/testcases/archiveData.php?edit=testcase&id=148 Import .xlsx file which contain duplicate range names]
  
−
* Test execution record list
+
|-
 +
|
 +
6
  
−
Total run 22 on Win7/XP/Mac/Ubuntu/Redhat/Suse 64bit
+
|
 +
[http://aootesting.adfinis-sygroup.org/lib/testcases/archiveData.php?edit=testcase&id=162 Limitation: Use Duplicate name range in other file]
  
 +
|-
 +
|
 +
7
  
 +
|
 +
[http://aootesting.adfinis-sygroup.org/lib/testcases/archiveData.php?edit=testcase&id=163 Duplicate name cell range in other file workbook]
  
−
* Execution result, pass rate(including first round pass rate, pass rate after defect fixed retest)
+
|-
 +
|
 +
8
  
−
Pass 12, failed 10 pass rate 55%
+
|
 +
[http://aootesting.adfinis-sygroup.org/lib/testcases/archiveData.php?edit=testcase&id=164 Duplicate names scope only for different sheets no workbook]
  
−
Most 10 case failed by '''[https://issues.apache.org/ooo/show_bug.cgi?id=120818 Bug&nbsp;120818''']
+
|-
 +
|
 +
9
  
 +
|
 +
[http://aootesting.adfinis-sygroup.org/lib/testcases/archiveData.php?edit=testcase&id=165 Reload action after save duplicate name range file]
  
 +
|-
 +
|
 +
10
 +
 +
|
 +
[http://aootesting.adfinis-sygroup.org/lib/testcases/archiveData.php?edit=testcase&id=199 Insert name that same name with Sheet scope name]
 +
 +
|-
 +
|
 +
11
 +
 +
|
 +
[http://aootesting.adfinis-sygroup.org/lib/testcases/archiveData.php?edit=testcase&id=211 Change the sheet name that contain duplicate name]
 +
 +
|}
  
−
* Defect analysis
+
==Test execution result ==
 +
Total run 22 on Win7/XP/Mac/Ubuntu/Redhat/Suse 64bit<br />
  
 
{| class="prettytable"
 
{| class="prettytable"
 
|-
 
|-
 
|
 
|
−
Bug ID
+
Platform
  
 
|
 
|
−
Product
+
Total
  
 
|
 
|
−
Component
+
Not Run
  
 
|
 
|
−
Priority
+
<nowiki>[%]</nowiki>
  
 
|
 
|
−
Status
+
Passed
 +
 
 +
|
 +
<nowiki>[%]</nowiki>
 +
 
 +
|
 +
Failed
 +
 
 +
|
 +
<nowiki>[%]</nowiki>
 +
 
 +
|
 +
Blocked
 +
 
 +
|
 +
<nowiki>[%]</nowiki>
  
 
|
 
|
−
Summary
+
<nowiki>Completed[%]</nowiki>
  
 
|-
 
|-
 
|
 
|
−
'''[https://issues.apache.org/ooo/show_bug.cgi?id=120818 Bug&nbsp;120818''']
+
MacOS X
  
 
|
 
|
−
SpreadSheet
+
3
  
 
|
 
|
−
Open-import
+
0
  
 
|
 
|
−
P3
+
0
  
 
|
 
|
−
CONFIRMED
+
3
  
 
|
 
|
−
When import the saved .ods file which contain duplicate names, it will not update and refresh the formula result
+
100%
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
100%
  
 
|-
 
|-
 
|
 
|
−
'''[https://issues.apache.org/ooo/show_bug.cgi?id=120820 Bug&nbsp;120820''']
+
Linux 32-bit
  
 
|
 
|
−
SpreadSheet
+
3
  
 
|
 
|
−
Save-export
+
0
  
 
|
 
|
−
P3
+
0
  
 
|
 
|
−
CONFIRMED
+
2
  
 
|
 
|
−
Define name which cell range in other file will saved incorrect to .xls and .ods
+
67%
 +
 
 +
|
 +
1
 +
 
 +
|
 +
33%
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
100%
  
 
|-
 
|-
 
|
 
|
−
'''[https://issues.apache.org/ooo/show_bug.cgi?id=120860 Bug&nbsp;120860''']
+
SuSE Linux 64-bit
  
 
|
 
|
−
SpreadSheet
+
5
  
 
|
 
|
−
editing
+
0
  
 
|
 
|
−
P3
+
0
  
 
|
 
|
−
CONFIRMED
+
5
 +
 
 +
|
 +
100%
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
100%
 +
 
 +
|-
 +
|
 +
Ubuntu Linux 32-bit
 +
 
 +
|
 +
3
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
3
 +
 
 +
|
 +
100%
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
100%
 +
 
 +
|-
 +
|
 +
Windows 7
 +
 
 +
|
 +
5
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
4
 +
 
 +
|
 +
80%
 +
 
 +
|
 +
1
 +
 
 +
|
 +
20%
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
100%
 +
 
 +
|-
 +
|
 +
Windows XP
 +
 
 +
|
 +
3
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
3
 +
 
 +
|
 +
100%
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
100%
 +
 
 +
|-
 +
|
 +
Total
 +
 
 +
|
 +
22
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
20
 +
 
 +
|
 +
91%
 +
 
 +
|
 +
2
 +
 
 +
|
 +
9%
 +
 
 +
|
 +
0
 +
 
 +
|
 +
0
 +
 
 +
|
 +
100%
 +
 
 +
|}
 +
 
 +
==Bug analysis ==
 +
 
 +
{| class="prettytable"
 +
|-
 +
|
 +
Bug Type
 +
 
 +
|
 +
ID
 +
 
 +
|
 +
Status
 +
 
 +
|
 +
Title
 +
 
 +
|-
 +
|
 +
Feature related
 +
 
 +
|
 +
'''[https://issues.apache.org/ooo/show_bug.cgi?id=120954 Bug&nbsp;120954''']
 +
 
 +
|
 +
Confirm
 +
 
 +
|
 +
The validity which have same range name is not correct when saved from .xlsx to .ods
 +
 
 +
|-
 +
|
 +
Non-Feature related
 +
 
 +
|
 +
'''[https://issues.apache.org/ooo/show_bug.cgi?id=120820 Bug&nbsp;120820''']
 +
 
 +
|
 +
Confirm
 +
 
 +
|
 +
Define name which cell range in other file will saved incorrect to .xls and .ods
 +
 
 +
|-
 +
|
 +
 
 +
 
 +
|
 +
'''[https://issues.apache.org/ooo/show_bug.cgi?id=120860 Bug&nbsp;120860''']
 +
 
 +
|
 +
Confirm
  
 
|
 
|
Line 131: Line 445:
  
 
|}
 
|}
 +
 +
[[Category:Quality Assurance]]

Latest revision as of 06:55, 21 September 2012

Calc name range enhancement

Reference:

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 id: Issue 120478  

Test plan

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

Index

Title

1

Delete duplicate range names and ranges

2

Update duplicate range names and ranges

3

Import and export .ods file which contain duplicate range names

4

Import and export .xls file which contain duplicate range names

5

Import .xlsx file which contain duplicate range names

6

Limitation: Use Duplicate name range in other file

7

Duplicate name cell range in other file workbook

8

Duplicate names scope only for different sheets no workbook

9

Reload action after save duplicate name range file

10

Insert name that same name with Sheet scope name

11

Change the sheet name that contain duplicate name

Test execution result

Total run 22 on Win7/XP/Mac/Ubuntu/Redhat/Suse 64bit

Platform

Total

Not Run

[%]

Passed

[%]

Failed

[%]

Blocked

[%]

Completed[%]

MacOS X

3

0

0

3

100%

0

0

0

0

100%

Linux 32-bit

3

0

0

2

67%

1

33%

0

0

100%

SuSE Linux 64-bit

5

0

0

5

100%

0

0

0

0

100%

Ubuntu Linux 32-bit

3

0

0

3

100%

0

0

0

0

100%

Windows 7

5

0

0

4

80%

1

20%

0

0

100%

Windows XP

3

0

0

3

100%

0

0

0

0

100%

Total

22

0

0

20

91%

2

9%

0

0

100%

Bug analysis

Bug Type

ID

Status

Title

Feature related

Bug 120954

Confirm

The validity which have same range name is not correct when saved from .xlsx to .ods

Non-Feature related

Bug 120820

Confirm

Define name which cell range in other file will saved incorrect to .xls and .ods


Bug 120860

Confirm

AOO can't change define names, we can only change define names cell range

Retrieved from "https://wiki.openoffice.org/w/index.php?title=QA/Report/AOO3.5FeatureReport/NameRange&oldid=205426"
Personal tools