Issue 18261 - macro recorder : Filter settings of CSV export aren't recorded in macro
Summary: macro recorder : Filter settings of CSV export aren't recorded in macro
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC2
Hardware: All All
: P3 Trivial with 7 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Blocks: 81535
  Show dependency tree
Reported: 2003-08-15 21:44 UTC by egle
Modified: 2023-04-21 13:08 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description egle 2003-08-15 21:44:26 UTC
I had a problem with macros recording in 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("")

rem ----------------------------------------------------------------------
dim args1(1) as new
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
Comment 1 Unknown 2003-08-19 10:37:23 UTC
*** This issue has been confirmed by popular vote. ***
Comment 2 frank 2003-08-19 10:49:56 UTC
Hi Joerg,

could you have a look please ?

Comment 3 joerg.skottke 2003-09-16 14:33:36 UTC
Confirmed, reassigned to NN
Comment 4 joerg.skottke 2003-09-16 14:37:52 UTC
Retargeted to 2.0
Comment 5 niklas.nebel 2003-09-18 12:34:15 UTC
note: later?
Comment 6 niklas.nebel 2003-09-19 15:10:43 UTC
SaveAs is handled by the framework. The spreadsheet filter options
dialog is called as service FilterOptionsDialog and doesn't know about
the SfxRequest.
Comment 7 Mathias_Bauer 2003-09-22 12:35:38 UTC
There's an interface missing to transport such parameters
Comment 8 Mathias_Bauer 2003-09-30 11:35:02 UTC
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.
Comment 9 oc 2003-10-02 11:12:21 UTC
According to the roadmap
( this issue was retargeted to
OOo Later.
Comment 10 egle 2003-10-31 11:32:57 UTC
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 :(.

Comment 11 Mathias_Bauer 2003-10-31 13:06:10 UTC
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.
Comment 12 niklas.nebel 2003-10-31 13:19:07 UTC
You mean a description of the filter options string for CSV files?
It's in the Developer's Guide, under "Saving Spreadsheet Documents".
Comment 13 Marcus 2017-05-20 11:13:41 UTC
Reset assigne to the default "".
Comment 14 Czesław Wolański 2023-04-20 17:57:11 UTC
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.
Comment 15 Marcus 2023-04-21 13:08:09 UTC
Closing this issue due to comment #14