https://bugs.freedesktop.org/show_bug.cgi?id=47479
Bug #: 47479
Summary: LibO Calc Macro .getCellRangeByName with named range
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.1 Release
Platform: x86-64 (AMD64)
OS/Version: Windows (All)
Status: NEW
Severity: normal
Priority: medium
Component: BASIC
AssignedTo: [email protected]
ReportedBy: [email protected]
I got an error message after updating Calc to LibO 3.5(.0 and still now with
.1.2) when running a previously flawless macro.
The offending (?) statement is .getCellRangeByName("namedcell") where
namedcell is a global named cell range (of one cell, in this instance).
Response from system:
Basic runtime error.
An exception occurred
Type: com.sun.star.uno.RuntimeException
Message:.
The (empty) returned message is quite cryptic, without any error number to
start searching.
- Same error when tried with a multiple cells named range, and with different
(plain and short) names for the range.
- It works well when the named cell range is replaced by its coordinates value
(e.g. "K12").
- Works also ok with getCellByPosition (but I want it to work correctly, as it
did before, with a named cell range).
Thanks in advance for a fast and complete solution, and/or explanation.
Cheers.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs