To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109140 Issue #|109140 Summary|adding named ranges with ":" not possible (Insert -Nam |es-Define...) Component|Spreadsheet Version|OOo 3.2 RC5 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P4 Subcomponent|ui Assigned to|spreadsheet Reported by|brinzing
------- Additional comments from [email protected] Thu Feb 11 08:02:48 +0000 2010 ------- it's possible to insert a named range containing a ":" using api but it's not possible to add/change it via Insert - Names - Define... it was possible in oo 1.1.5 ... REM ***** BASIC ***** OPTION EXPLICIT Sub Main Dim oDoc as Object Dim oNRanges as Object Dim sN as String Dim sC as String Dim oDummy as New com.sun.star.table.CellAddress Dim l as Long oDoc = ThisComponent oNRanges = oDoc.NamedRanges sN = "TIMESTAMP_10.02.2010_09:00:00" sC = "$'" & oDoc.getSheets().getByIndex(0).getName() & "'." & "$A$1" oNRanges.AddNewbyName(sN, sC, oDummy, l) End Sub --------------------------------------------------------------------- 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]
