https://bugs.documentfoundation.org/show_bug.cgi?id=99086
Bug ID: 99086
Summary: NamedRanges.getByName().ReferencePosition.Column Err
Product: LibreOffice
Version: 5.1.1.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 124070
--> https://bugs.documentfoundation.org/attachment.cgi?id=124070&action=edit
Minimal spreadsheet exhibiting error
Windows 10
I have two named ranges in the same column, but their ReferencePosition.Column
values are different, when I would anticipate them to be the same.
The attached spreadsheet (cut down from the one I was working on to bare
essentials) illustrates this, with the okay range (Tst2) highlighted green and
the bad one (DataW1C) red. You can see if you choose the named ranges from the
gui droplist that they jump to these locations.
They have the same column, but if you open spreadsheet (enable macros) and run
the Main() code, which is below, the code reports different columns.
Cheers,
David
SPREADHEET CODE:
Option Explicit
Sub Main()
Msgbox ThisComponent.NamedRanges.getByName("DataW1C").ReferencePosition.Column
' Fail (Red)
Msgbox ThisComponent.NamedRanges.getByName("Tst2").ReferencePosition.Column '
Good (Green)
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
