Apache OpenOffice (AOO) Bugzilla – Issue 18261
macro recorder : Filter settings of CSV export aren't recorded in macro
Last modified: 2023-04-21 13:08:24 UTC
I had a problem with macros recording in OpenOffice.org 1.1RC2 version. I opened spreadsheet and started to record macro (Tools->Macros->Record Macro). When saving spreadsheet document in .csv format, I check “Edit filter settings” and change the encoding to Eastern Europe (ISO-8859-13), Text delimiter to nothing and the Field delimiter to “;”. But when I saved that macro and opened it, there were no code for changing encoding and delimiters. So I can't create program which set needed encoding and delimiters when exporting to CVS. Please fix this bug ASAP or at least tell me how to change encoding, field and text delimiters with StarBasic - I searched OOo API documentation, but it's too complicate for me :(. Macro, recorded with OOo RC2 is bellow: sub FR0453 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 = "file:///home/mantas/Projects/VMI/FR0453.csv" args1(1).Name = "FilterName" args1(1).Value = "Text - txt - csv (StarCalc)" dispatcher.executeDispatch(document, ".uno:SaveAs", "", 0, args1()) end sub
*** This issue has been confirmed by popular vote. ***
Hi Joerg, could you have a look please ? Frank
Confirmed, reassigned to NN
Retargeted to 2.0
note: later?
SaveAs is handled by the framework. The spreadsheet filter options dialog is called as service FilterOptionsDialog and doesn't know about the SfxRequest.
There's an interface missing to transport such parameters
All recording bugs are currently collected until we have enough feedback to decide how to proceed with recording in OOo2.0. Until then the target is set to "Later", but this may be reconsidered when we have enough data.
According to the OpenOffice.org roadmap (http://tools.openoffice.org/releases) this issue was retargeted to OOo Later.
If you decided not to fix this bug soon maybe anybody can tell me how to change encoding, field and text delimiters with StarBasic - I searched OOo API documentation, but it's too complicate for me :(. Please.
It's not that we decided *not* to fix this bug in OOo2.0, but currently all recording bugs are set to "OOo later" until we have collected enough user feedback that helps us to decide which issues we want to work on. But providing the information about filter data is a good idea anyway and fortunately it's already planned. :-) I will add the link to the documentation to this report as soon as it's available.
You mean a description of the filter options string for CSV files? It's in the Developer's Guide, under "Saving Spreadsheet Documents".
Reset assigne to the default "issues@openoffice.apache.org".
It looks like the bug was fixed in 2.0.x Note: the macro recorder in 2.0.1 produces a faulty code. In any later version, the recorded macro contains the correct code (filter options for the CSV Filter). The problem was solved a long time ago, so it can be closed.
Closing this issue due to comment #14