To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103547 Issue #|103547 Summary|Named Ranges Not Recognized Without base-cell-address Component|Spreadsheet Version|OOO300m9 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|viewing Assigned to|spreadsheet Reported by|eric_mcdonald
------- Additional comments from [email protected] Tue Jul 14 16:10:53 +0000 2009 ------- 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 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
