2012/3/7 fork <email@example.com>:
Johnny Rosenberg <gurus.knugum <at> gmail.com> writes:
2012/3/7 Andreas Säger <villeroy <at> t-online.de>:
Again, it is technically and logically impossible to write a program without
knowing anything about the input.
A Tab delimited text file – what more could we want to know?
Some text ↹ More text ↹ More text again ↹ Text again, perhaps ↵
Another row with text, ↹ and ↵ and so on.
yeah, exactly. Oh, let me add "with a newline after Another row with text".
Well, ↵ is a newline… :) Well, it's the Enter key, but it produces a new line.
(Or perhaps: a tab delimited file with text in columns. Or maybe: a text file,
with columns separated by tabs and records separated by newlines. Or: A CSV
file, except with tabs instead of commas... I am a little bit surprised at the
level of drama my original specification elicited ...)
The macros could automatically detect how many rows and columns there
are, shouldn't be too difficult. I'd give it a try if I had some time
left. Sorry that I don't at the moment.
If you have time at some point, could you point me at the functions you would
think of first to do this? I tried to record a macro but all I got was an empty
The macro recorder sucks, I never use it. There is a slightly better
one somewhere, but I never use that either.
Well, I am not sure at the moment, I am sure there will be a lot of
searching on the Internet for some suitable methods to use, and I
would probably be using ”xray” very frequently in order to create
something that works. I am not an expert in any way with macro
I think a macro can do everything that can be done manually and quite
a lot more, so I would probably try to find how to execute the CSV
import thing and let the macro set the values, but right now I don't
know how to do such a thing, but I'm convinced that it's possible (but
not 100% sure, of course).
Likewise! (so refreshing...)
For unsubscribe instructions e-mail to: firstname.lastname@example.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] Calc macro to open tab delimited data file? · Andrew Douglas Pitonyak
- [libreoffice-users] Re: Calc macro to open tab delimited data file? (continued)
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