https://bugs.documentfoundation.org/show_bug.cgi?id=119457
Bug ID: 119457
Summary: inserting named ranges with special characters, e.g.
operators ':', '+', ... in name are allowed via api
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
inserting named ranges with special characters, e.g. operators ':', '+',...
are allowed via api but disallowed using named ranges dialog (Strg+F3).
Example:
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_23.08.2018_18:05:00"
sC = "$'" & oDoc.getSheets().getByIndex(0).getName() & "'." & "$A$1"
oNRanges.AddNewbyName(sN, sC, oDummy, l)
End Sub
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
