[Libreoffice-bugs] [Bug 140956] New: recording macros was not convenient and is now impossible
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Thu Mar 11 14:49:32 UTC 2021
https://bugs.documentfoundation.org/show_bug.cgi?id=140956
Bug ID: 140956
Summary: recording macros was not convenient and is now
impossible
Product: LibreOffice
Version: 6.1.3.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: BASIC
Assignee: libreoffice-bugs at lists.freedesktop.org
Reporter: Hal71229 at gmail.com
Description:
if i record a macro I get a mass of lines for a simple action
In excel I get one line vba per action
You already have a table to transform VBA to uno in order to run these macros
You should use same object and action names as VBA , if you combine them with
starbasic or python that doesn't matter
but you can handle it far better
Actual Results:
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(1) As new com.sun.star.beans.PropertyValue
args1(0).Name = "URL"
args1(0).Value = Name_of_Map
args1(1).Name = "FilterName"
args1(1).Value = "Calc MS Excel 2007 XML"
dispatcher.executeDispatch(document, ".uno:SaveAs", "", 0, args1())
Expected Results:
Workbooks(Name_of_Map).SaveAs filtername:="Calc MS Excel 2007 XML"
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
[Information automatically included from LibreOffice]
Locale: de
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes
--
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/20210311/dc714ea7/attachment-0001.htm>
More information about the Libreoffice-bugs
mailing list