Re: [libreoffice-users] Re: Cell formatting with CSV files in Calc

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:mail@revida.sk


--
For unsubscribe instructions e-mail to: users+help@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