https://bugs.documentfoundation.org/show_bug.cgi?id=170418
Bug ID: 170418
Summary: Document Color Themes breaks macro recording
Product: LibreOffice
Version: 25.8.4.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
It appears that the document (color) themes breaks macro recording when
assigning color to a spreadsheet cell.
(I watched the Tea Time Training with Tomasz Jan 16, 2026)
The macro recorded below does not work, message is
"BASIC syntax error.
Unexpected symbol: CRLF."
sub zz
rem ----------------------------------------------------------------------
rem define variables
dim document as object
dim dispatcher as object
rem ----------------------------------------------------------------------
rem get access to the document
document = ThisComponent.CurrentController.Frame
dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")
rem ----------------------------------------------------------------------
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = "ToPoint"
args1(0).Value = "$E$9"
dispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1())
rem ----------------------------------------------------------------------
dim args2(1) as new com.sun.star.beans.PropertyValue
args2(0).Name = "BackgroundColor.Color"
args2(0).Value = 6472704
args2(1).Name = "BackgroundColor.ComplexColorJSON"
args2(1).Value = "{ "+CHR$(34)+"ThemeIndex"+CHR$(34)+": -1,
"+CHR$(34)+"Transformations"+CHR$(34)+": [ ]}"
dispatcher.executeDispatch(document, ".uno:BackgroundColor", "", 0, args2())
end sub
--
You are receiving this mail because:
You are the assignee for the bug.
