At 08:20 20/10/2007 -0700, Bart Claasen wrote:
Because I wanted to announce a bug which I encountered in OpenOffice.
The trouble is that I had to import a CSV file, which later appeared
to be unfunctional because the calculation function could not be
enabled, or is not working.
CSV, or comma-separated values, is not a proper spreadsheet document
file format, of course: it just allows tabulated values to be saved
in a file, not any formulae or other relationships or
formatting. It's ideal for exchanging values between different
application software, but you cannot save a proper spreadsheet in
this format, and must choose another.
When you open a CSV file in OpenOffice Calc, you are still working
with that file, so if you add formulae, formatting, and so on - or
even further sheets - to the spreadsheet and then use Save, you will
be saving back to your CSV file and will keep only the tabulated
values of the current sheet.
The solution is easy. Import the CSV file, and then immediately use
File | Save As... to save a copy of the file as a new spreadsheet
document. In the Save As dialogue box, change "Save as type" to
"OpenDocument Spreadsheet (.ods)". From now on you will be working
with a new actual spreadsheet file and all should be hunky-dory.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
