To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=111762
Issue #|111762
Summary|getCellRangeByName("Name1:Name2") causes exception
Component|Spreadsheet
Version|OOO320m12
Platform|PC
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|programming
Assigned to|spreadsheet
Reported by|jimavera
------- Additional comments from jimav...@openoffice.org Sat May 22 00:01:54
+0000 2010 -------
Names defined using Insert->Names->Define can be used to label individual cells,
and such names can be used in formulas such as SUM(Label1:Label2).
However, if a macro tries to access a range constructed with such labels by
calling
ThisComponent.GetCurrentController.ActiveSheet.getCellRangeByName("Foo:Bar")
then an exception occurs. The exception has an empty message string, so there
is something fishy about it.
getCellRangeByName works when getting a single cell ("Foo") or a single
user-defined name which is pre-defined to be a range (e.g. Foo = A1:E1).
Please see the attached demo spreadsheet.
(Found in Ubuntu 10.04 on amd64)
---------------------------------------------------------------------
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
