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

berntie wrote
> First of, I've unintentionally replied to your address only. Sorry for
> that.

No problem ;)


berntie wrote
> I just want to export as CSV, I don't want to export the formats.
> Basically:
>
> I want to edit a CSV. And by "editing" I mean "adding and/or modifying
> lines".  Just for convenience, It would be nice to have the amount column
> formatted as a currency.
>
> I do not require the formatted values to be written to the CSV file upon
> saving, but _if_ they are written to the file then I'd need a possibility
> to format those values as a currency when I open the file the next time.
> That's what I cannot accomplish as for now.

Ok. That is what I thought you were trying to do. What you need to do is

1) You CAN'T use the Save button
2) You must always Save As (although you can overwrite your csv file)
3) In the Save As dialog, always check the bottom box "Edit filter settings"
4) On the next dialog choose "Keep current format" (meaning save as CSV)
5) On the Export Text File dialog, make sure you UNCHECK the "Save cell
content as shown" option (this tells Calc not to save long date as the text
you see on screen but save the value) and CHECK the "Quote all text cells" 
option (just to make sure all text is properly saved

That's it. Since you want to save as CSV you will have to repeat this
procedure at save time and the format procedure at opening... 
Or you could have two copies, one in ODS properly formatted and a copy in
CSV which you exported following the 5 previous steps after adding new data.

Hope this helps ;)

--
View this message in context: 
http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3558201.html
Sent from the Users mailing list archive at Nabble.com.

-- 
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