Zilli Samuel wrote:
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" !!!
It's intended behavior, the same as when typing "73.383831" into a cell.
I've tryied with different language setting and different font of importation, but without solution.
If the file has '.' as decimal separator and your locale has a different one (like Italian does), select "US English" instead of "Standard" as the column type in the Text Import dialog.
Niklas --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
