Pedro wrote > > 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
Works like a charm. Pedro wrote > > 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... I can live > very well with that. Pedro wrote > > Hope this helps ;) It certainly does. Thank you very much. Oh, and by the way, can you confirm that data validation does not work with CSV files? -- View this message in context: http://nabble.documentfoundation.org/Cell-formatting-with-CSV-files-in-Calc-tp3557689p3558288.html Sent from the Users mailing list archive at Nabble.com. -- 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
