[Libreoffice-bugs] [Bug 136233] New: Error in sheet Names property (Option VBASupport 1)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136233

            Bug ID: 136233
           Summary: Error in sheet Names property (Option VBASupport 1)
           Product: LibreOffice
           Version: 7.0.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: sokol at comec92.ru

Description:
The sheet Names property returns the names of the document, not the sheet

Steps to Reproduce:
1.Open TestNamedRange.ods.
  There are 2 Names in document:
  - Doc_name. Scope: Document
  - Sheet1_name. Scope: Sheet1 (sheet)

2. Run document Basic Macro Standard.Module1.Test1

Option VbaSupport 1
Sub Test1
  Dim VBAWorksheet, VBAWorksheetName
  VBAWorksheet=ThisWorkbook.Worksheets("Sheet1")
  For Each VBAWorksheetName In VBAWorksheet.Names
    Msgbox VBAWorksheetName.Name
  Next VBAWorksheetName   
End Sub



Actual Results:
Result of Msgbox - Doc_Name

Expected Results:
Sheet1_Name


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.0.3 (x64)
Build ID: 8061b3e9204bef6b321a21033174034a5e2ea88e
CPU threads: 6; OS: Windows 10.0 Build 18363; UI render: default; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded

-- 
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/20200828/c42fb5a4/attachment-0001.htm>