Dne 28.12.2011 18:28, berntie napsal(a):
Jay Lozier wrote
What are you actually trying to do? It sounds like your trying do
something that a database may be better at doing.
I'm just trying to keep some kind of record of my daily expenses. While
there's some hassle involved, LibreOffice provides all the features I need
for that purpose (pivot-tables are most important), so a real RDBMS would be
far too complex for my requirements.
Concerning the file format, CSV files have the huge advantage of being
* a single file,
* small,
* and plain text files.
...
If you prefer to edit plain text file and process its data in Calc, you
have two
other ways:
1) do not import the file. Simply copy the text in which the Tabs are
the delimiters
and then "Paste as unformatted text" into the pre-formatted sheet -
there is an icon in the toolbar for it.
2) Create an extra sheet (name it e.g. CSV) which is linked to your
external regular csv file.
In your main sheet (name it e.g. DATA) and put everywhere formulas (e.g.
in DATA.A1 enter =CSV.A1)
Then format cells in DATA as you need.
Define your pivot tables source area big enaugh to cover future
hundereds of rows :)
Regards,
Jiri
--
Ing. Jiří Hladůvka - REVIDA
http://www.revida.sk
mailto:m...@revida.sk
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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
