At 22:18 23/07/2007 +0100, Brian Barker wrote:
At 05:40 23/07/2007 -0400, Roger Wray wrote:
Your Calc program is a failure. I spend hours working on a .csv
files only to have the sheet lost when I closed the program. There
were 2 sheets in the file and it deleted the second one I created
without any warning. Thank you for your inability to write a program.
Going back to Microsoft. Don't know what other thing might be
waiting to destroy my work.
Your bug or issue reporting does not save the user time. It is only
for self centered you.
Hell of a way to promote SUN. Will not be using another product by
SUN. I will also be letting the internet know that their job is in
limbo if they try to use any SUN products.
You evidently missed the warning in Calc's help text that says "When
you export a spreadsheet to CSV format, only the data on the current
sheet is saved. All other information, including formulae and
formatting, is also lost." So you cannot have two sheets in a file
saved as .csv.
If you create a new spreadsheet with more than one sheet and try to
save it as a .csv file, Calc will warn you that you are saving only
the active sheet. (I don't think this warning can be
suppressed.) But it is true that if you open an existing .csv file
in Calc and then add another sheet to it, Calc evidently assumes
that you are already aware of the issue and does not warn you when
you save the enlarged spreadsheet.
You are, of course, welcome to return to commercial software if you
prefer. But you may like to check whether Excel will do things any
differently. Microsoft's web site says of saving files in .csv
format "Only the active sheet is saved." Doesn't that mean that the
problem is with your perception of how spreadsheet applications
operate, not with a difference between OpenOffice and other software?
Anyone is probably ill advised to work for hours in a new way
without saving their work and reopening it, to check that what they
are doing is working as they wish and need. When you speak to the
internet, you may want to suggest that. And you may like to mention
the warning that you missed.
I trust this helps.
Brian Barker
At the risk of dragging this out, I think there are two further
points that can usefully be made here.
1. Despite Calc's offering it as a choice of format within Save
As..., CSV is not a spreadsheet document format. Since it does not
preserve formatting, formulae, and so on, it cannot be. Instead, it
is a data interchange format, suitable for transferring data between
different applications. So it should never be the only format in
which you save your work.
2. I would suggest that it is always best to keep your working copy
of any document in the application's default file format (though I
recognise that some will dispute this claim and that not everyone
works this way). In this case, then, I would recommend saving any
work as a Calc (.ods) spreadsheet file, and saving a CSV version in
parallel only when this was necessary.
I trust this helps (a little more?).
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
