On Wed March 8 2006 19:07, + ivo welch wrote: > [ MODERATED ] *********************** > > 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. >
As you are not subscribed you may not have seen that: On Thu March 9 2006 16:39, Bernd Eilers wrote: > 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. > Please reply to [email protected] only. Normally [email protected] is the best list to ask questions about using OpenOffice.org -- CPH : OpenOffice.org contributor --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
