https://bugs.documentfoundation.org/show_bug.cgi?id=163683
Bug ID: 163683
Summary: After upgrade from LO 24.2.5 to 24.8.2 problems with
macros occurred
Product: LibreOffice
Version: 24.8.2.1 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have upgrade LO from 24.2.5 to 24.8.2 (and also Java to actual build
1.8.0_431-b10) I face problems with macros stored in sCalc file, which were
working in 24.2 without any problems:
1. macro:
sub QRweb
createUnoService("com.sun.star.system.SystemShellExecute").execute( _
ConvertToURL(ThisComponent.getSheets().getByName("QR").getCellRangeByName("A14").getString()),,0)
end sub
Running this macro gives an error on first line “BASIC runtime error. Argument
is not optional.” although macro runs and opens the web page.
2. macro:
sub ResizeQR
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 ----------------------------------------------------------------------
rem dispatcher.executeDispatch(document, ".uno:TransformDialog", "", 0,
Array())
rem ----------------------------------------------------------------------
dim args2(3) as new com.sun.star.beans.PropertyValue
args2(0).Name = "TransformPosX"
args2(0).Value = 50
args2(1).Name = "TransformPosY"
args2(1).Value = 10500
args2(2).Name = "TransformWidth"
args2(2).Value = 4300
args2(3).Name = "TransformHeight"
args2(3).Value = 4940
dispatcher.executeDispatch(document, ".uno:TransformDialog", "", 0, args2())
end sub
Running this macro makes LO crash.
Steps to Reproduce:
What I have tried:
1. Installed through Separate Install GUI back the version 24.2.5.2 and tried
to run macros - works still fine.
2. Copied the user profile from actual LO to the separate 24.2.5.2 and tried to
run macros - works fine. Java is enabled
3. Installed a separate 24.8.2. version with a clear user profile and tried to
run macros on the file - error (macro 1) / crashed (macro 2)
Actual Results:
some problems with macros
Expected Results:
no problems should occur
Reproducible: Always
User Profile Reset: Yes
Additional Info:
It makes no difference, if Java experimental features are enabled or not, I
tried in 24.8 both possibilities.
--
You are receiving this mail because:
You are the assignee for the bug.
