|
I'm using OpenOffice.org 2.0 in Italian official
version, with Win XP SP2.
I've found a bug when importing a CVS (txt)
file in Calc, with Open File menu command.
The file I've used is the txt result of Intel
IOMeter 2004.07.30 benchmark (I post it at the end of message).
Calc can reconstruct correctly the structure of the
tables, and the data fields. But it can't represent correctly the values in some
cells. In the importation preview (when choosing font type and separators)
it is displayed correctly, with result values correctly set in cells (i.e.
73.383831), but when I click OK and it is imported in Calc, those cells are set
in hour format (instead of number format), i.e. "1008.51.00". If I try to re-convert cell format to number, it give
"42,0354166666667"insetad of "73.383831"
!!!
I've tryied with different language setting
and different font of importation, but without solution.
Sorry for my bad english,
Samuel
The CVS file is this : result.csv
|
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
