To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101544 Issue #|101544 Summary|Named ranges don't work with range operator (colon) Component|Spreadsheet Version|OOo 3.1 RC2 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|jes
------- Additional comments from j...@openoffice.org Mon May 4 16:39:12 +0000 2009 ------- Steps to reproduce: 1) Define names for two cells; e.g., A1:"Top", B10:"Bottom". 2) Create a formula using either or both names with the colon operator; e.g., =SUM(A1:Bottom) or =SUM(Top:Bottom). 3) The result is #NAME? instead of the expected sum. This seems to work correctly in OOo 3.0 and 3.0.1 --------------------------------------------------------------------- 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
