Issue 103547 - Named Ranges Not Recognized Without base-cell-address
Summary: Named Ranges Not Recognized Without base-cell-address
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOO300m9
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-07-14 17:10 UTC by eric_mcdonald
Modified: 2013-01-29 21:50 UTC (History)
2 users (show)

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

Attachments
Sheet Having Named Ranges (and Expressions) with base-cell-address (6.37 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-07-20 15:33 UTC, eric_mcdonald 		no flags Details
Sheet Having Named Ranges (and Expressions) without base-cell-address (6.08 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-07-20 15:37 UTC, eric_mcdonald 		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 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".