First of all, thanks to all for such a great product!
Second, I would like to write, record, or copy a macro for calc that opens a
tab delimited file and sets all the imported columns to be text format. I want
it to give me a file selection dialogue, but otherwise do everything else
I know how to do this manually, and it isn't tricky, it is just that we have
LOTS of tab delimited text data files here at work, and it would awesome to be
able to push a button, choose a file, and voila.
Since I have already chosen not to have LO prompt if saving in non-ODT, this
would work seamlessly, saving me endless hours of fury at Excel for their stupid
"you will lose formatting" blather.
I can provide any more info if anyone would like.
P.S. -- I don't really want to get good at macro writing, so I am hoping for the
very quickest quick hack, rather than the 500 page introduction to LO Basic. No
judgements implied, just expediency.
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy