[Libreoffice-bugs] [Bug 119457] New: inserting named ranges with special characters, e.g. operators ':', '+', ... in name are allowed via api

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: oliver.brinzing at gmx.de

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180823/50167090/attachment-0001.html>