Apache OpenOffice (AOO) Bugzilla – Issue 57739
macro recorder issue
Last modified: 2013-02-24 21:09:46 UTC
I have created a macro (using the recorder) that save automatically a spreadsheet in html format, once it is opened. That is the code that has been generated sub record_html 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(2) as new com.sun.star.beans.PropertyValue args1(0).Name = "URL" args1(0).Value = "file://tmp/test_graph1.html" args1(1).Name = "FilterName" args1(1).Value = "HTML (StarCalc)" args1(4).Name = "SelectionOnly" args1(4).Value = true dispatcher.executeDispatch(document, ".uno:SaveAs", "", 0, args1()) max index for objects is defined args1 to 2, whereas after index 4 is used. When I then run the macro I got the following error Inadmissible Value or DataType - Index out of defined range This seems to be a recorder issue. manual correction of the macro solved the pb.
sw->mba: this is your playground as far as I know :-)
duplicate *** This issue has been marked as a duplicate of 54702 ***
closing