Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Named Ranges Not Recognized Without base-cell-address|
|Component:||viewing||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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 , '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.  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".