Hi there!
First the OpenDocument Format is already a compressed/zipped File thus
the .gz in your suggestion is superflous.
Secondly *hmm* I think there is a much simpler solution to the problem
for which you suggested the feature.
What you achieve which the feature you suggested is that you have saved
the data into two formats one for export to other apps and one for
viewing. But you can do that more easily:
Just write a simple macro that saves first as .csv and than in Calcs own
OpenDocument Format, bind that macro to some menu item or icon in
OpenOffice.org. Now instead of always using save_as_csv just use that
icon or menu-entry and there you have the two formats of the file that
you need the first for exchange with other applications and the second
to contain also the formatting. And than well you just don´t need any
magic with filename handling which would open the native format file
when you select the .csv file for opening just simply remember to open
the native format file which contains the formatting when you want to
edit the document.
I believe that even the handling as you´ve described it originally in
your feature request can be easily implemented by using macros and
binding them to the save/open entry in the menu and the save/open icons
in the toolbar.
I think the use case is relative rare tough or at least it´s not one
that should be made the standard default for everyone so using for this
is a good alternative.
Kind regards,
Bernd Eilers
ivo welch wrote:
I usually save my spreadsheets as .csv files, because this makes it easy
for me to pull the data into other programs. in effect, I use the
spreadsheet as the interactive app to manipulate the input data, and
many other programs to analyze the data. .csv is the lingua franca
here. I probably am not the only one using a spreadsheet this way.
the problem is that .csv cannot even keep basic formatting, and most
other programs do not know how to parse anything except .csv files.
Suggestion: Add a "save as csv with format" option to the menu. now,
if I save abc.csv, abc.csv should be written as before. however, a
second file, .abc.sxc.gz should also be written, in the native
openoffice format. it would also have to contain one comment [field]
that contains the time, date, and size of abc.csv.
if I now open abc.csv in oocalc2, oocalc2 would first check if
.abc.sxz.gz exists, and was written no more than x seconds after abc.csv
was written. if this is the case, .abc.sxz.gz is opened, and it is
checked whether the time,date, and size are still the same as the
abc.csv that the user requested. if so, then the .abc.sxz.gz file is
opened.
it would be just like magic that made the .csv file appear to retain its
formatting, wouldn't it?
plus, a user who does not like it could delete the .abc.sxz.gz file, or
simply do another "save as plain csv file"---the date/time would no
longer correspond, so the format information would disappear.
hope this helps.
sincerely,
/ivo welch
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
