[OT] OpenOffice calc question

Jerry Feldman gaf-mNDKBlG2WHs at public.gmane.org
Mon Jul 23 16:24:46 EDT 2007


My company's product uses dates in yyyymmdd format, but can import csv
files directly from any spreadsheet. If I import a csv containing
yyyymmdd, OO calc correctly displays the date, but if I want to modify
the spreadsheet (mainly financial curves), it outputs the date in the
mmddyyyy or mmddyy in the resultant csv. Does anyone know how I can
tell OO to output dates in the desired format preferably without
changing the entire locale. Of course, the csv can be edited with emacs
(or lesser capable editors like vi :-).=20

--=20
Jerry Feldman <gaf-mNDKBlG2WHs at public.gmane.org>
Boston Linux and Unix user group
http://www.blu.org PGP key id:C5061EA9
PGP Key fingerprint:053C 73EC 3AC1 5C44 3E14 9245 FB00 3ED5 C506 1EA9





More information about the Discuss mailing list