At 12:32 26/06/2007 +0200, Alessandro Ronchi wrote:
I import a CSV file with about 10 columns, make some changes in calc
and then export the files as csv again.
In the second file I have a lot of empty columns at the end of the
real columns. it seems calc exports also the empty columns of my table.
How can I solve this problem?
Thanks in advance
--
Alessandro Ronchi
I cannot reproduce this behaviour in my version of Calc (2.0.2 on
Windows XP). As far as I can see, Calc saves as many rows and
columns as is necessary to include all the values on the current
sheet. This does mean, of course, that there may be a trailing
string of separators (usually commas) in some rows, to space out the
empty cells in columns which are not occupied in those rows but *do*
have data in some other row or rows.
The obvious possibility is that you do have some data in what appear
to be empty cells. Remember that even just an explicit blank in one
such cell could trigger this behaviour. You should, of course, be
able to see where the non-empty cell is by carefully examining the
resulting CSV file: such a blank would appear in the file, surrounded
by quotation marks.
To solve this problem:
o Select the first of the supposedly empty columns by clicking the
column header.
o Shift-click the column header of the last of the suspect
columns. This will select all the rogue columns.
o Press Backspace to delete everything in these columns.
Now try to save as CSV again.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
