Issue 103547

Summary: Named Ranges Not Recognized Without base-cell-address
Product: Calc Reporter: eric_mcdonald <mcdonald>
Component: viewingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, kpalagin
Version: OOO300m9   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Sheet Having Named Ranges (and Expressions) with base-cell-address
none
Sheet Having Named Ranges (and Expressions) without base-cell-address none

Description eric_mcdonald 2009-07-14 17:10:53 UTC
I have been generating Open Document spreadsheets via code (using the ODFpy API
provided by the Open Document Fellowship). Named ranges created with only the
'name' and 'cell-range-address' attributes are not recognized by OOo Calc. If I
include the 'base-cell-address' attribute as well, then OOo Calc recognizes the
named range.

According to the OASIS Open Document 1.1 specification [1], 'base-cell-address'
is optional and is only required if 'cell-range-address' contains relative
addresses. However, the 'cell-range-address' attributes that I am generating
only contain absolute addresses, and thus 'base-cell-address' should not be
required.

Here is an example of named range that OOo Calc does not recognize:

<table:named-range table:name="NR_0b245631ba6b335a44285d70445024b69b6fef1e" 
table:cell-range-address="$'Unit Types (Post)'.$A$3:.$A$65536"/>

and here is an example of one that it does recognize:

<table:named-range table:name="NR_0b245631ba6b335a44285d70445024b69b6fef1e"
table:base-cell-address="$'Unit Types (Post)'.$A$3"
table:cell-range-address="$'Unit Types (Post)'.$A$3:.$A$65536"/>

Thanks for considering this issue.

[1] Section 8.5.5 of http://docs.oasis-open.org/office/v1.1/OS/OpenDocument-v1.1.pdf
Comment 1 kpalagin 2009-07-20 13:07:52 UTC
Eric,
please attach two files - one with 'base-cell-address' attribute and one 
without that attribute.
Thanks.
Comment 2 eric_mcdonald 2009-07-20 15:33:29 UTC
Created attachment 63649 [details]
Sheet Having Named Ranges (and Expressions) with base-cell-address
Comment 3 eric_mcdonald 2009-07-20 15:37:05 UTC
Created attachment 63650 [details]
Sheet Having Named Ranges (and Expressions) without base-cell-address
Comment 4 eric_mcdonald 2009-07-20 15:43:57 UTC
Attachments have now been provided. As an additional comment, I would like to
mention that the same issue seems to exist with named named expressions. The
attached sheets contain both named expressions and named ranges.

If you go to Insert -> Names -> Define... (CTRL+F3), you will see named ranges
(starting with "NR_" prefix) and named expressions (starting with "NE_" prefix)
for the case with base-cell-address and not see them for the case without
base-cell-address.

Thanks.
Comment 5 kpalagin 2009-07-20 16:05:39 UTC
Confirming with m50 on WinXP - Navigator would not show any named ranges 
in "test-nobca.ods".