Change standard settings - .csv import

[woercel]

Hi,
every time i open a csv file in oocalc i have to select the delimiter ";" manually.
is it possible to change the standard delimiter to semikolon?
cheers
woercel

[Villeroy]

Is read-only access to a whole directory of semicolon-csv OK for you or do you need to edit the csv?

[Villeroy]

Anyhow, http://www.oooforum.org/forum/viewtopic ... 991#258991 offers two solutions:
1. Macro to read a csv with prepared import settings into a prepared template (may include calculation models, formatting an stuff)
2. A pseudo-database (read-only) made from a directory of csv-files
Another solution, similar to 1: [Tutorial] External Links In Calc Chapter 2. "Linked Sheet From File"

[woercel]

The option with the macro sounds nice,
but how to do that???

[Villeroy]

The option with the macro sounds nice,
but how to do that???

Shure, everybody loves macros. I don't. Anyway, here we go:
Tools>Macros>Orgainize>OOo Basic...
Button [Organizer...]
Tab: Libraries, location: "My Macros&Dialogs"
[New...], name: let's say "Calc"
tab:Modules, browse the new library in container "MyMacros" and select the contained module "Module1".
[Edit...]
I would remane "Module1" to something like "csv"
Clear the default content (empty Sub Main) and paste the code from the other forum.
Save the new library [Ctrl+S]

[Hagar Delest]

See also: [Tutorial] How to install a code snippet.

Thanks to add '[Solved]' at beginning of your first post title (edit button) if your issue has been fixed.