At 11:07 27/06/2007 +0200, Alessandro Ronchi wrote:
2007/6/26, Brian Barker <[EMAIL PROTECTED]>:
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.
It's not true on my 2.2 version with linux or windows.
I import a csv file and open it with openoffice.org.
Also if I made no changes on the file, when I export the file to csv
again it has a great number of empty column.
Would my csv file be useful? It's big but I can upload on a server and
link in a email.
--
Alessandro Ronchi
At 11:25 27/06/2007 +0200, Alessandro Ronchi wrote:
I've filed a issue on oo.org with attachments:
http://www.openoffice.org/issues/show_bug.cgi?id=78926
--
Alessandro Ronchi
If you follow my original recommendation, you will see what is
happening here. Most of your data extends between columns A and AJ
only. If you delete the contents of columns you believe to be empty
(AK onwards), you will find that any saved CSV file is no longer
bloated. So there must, indeed, be something in the later
columns. (Incidentally, you can see this at a glance anyway, since
the width of the supposedly empty columns has been automatically
adjusted to accommodate the data which is actually
there.) Alternatively, you could delete all the columns you believe
to be used (A to AJ) and then search for anything in the remaining
columns. (This is how I diagnosed your problem.)
You have a rogue row labelled 1811 between rows 692 and 693, but that
is not the source of your problem.
There is a problem with the data in the row labelled 773 (Calc row
774). You have a number of double quotation marks in your data,
which are escaped as \" - this appears to be no problem. But they
are generally paired within any data item. In row 773, there is a
single escaped double quotation mark. For some reason, this confuses
Calc. As a result, the data labelled 773 to 780 appear in one row of
the spreadsheet (presumably as far as one row can extend) and
following rows are lost until everything starts again at data row
1040. Because of the errors, Calc row 774 extends the column range
as far as column IQ. When you save this sheet as CSV, all rows are
padded with null entries as far as column IQ. This is as it should be.
If you change the data item at data row 773 from
"BIGODINI RISCALDANTI \"BA"
to
"BIGODINI RISCALDANTI \"BA\""
in your original CSV file, so that the escaped quotations are
balanced again, everything works OK.
Now the important questions:
o Why does this happen? I'm not sure I know. Does it have
something to do with language settings?
o Is this a bug or a feature? Don't know.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
