On Tue, 29 Nov 2005 16:18:48 +0100, Zilli Samuel wrote: > 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
The following is *NOT* a CVS file it is HTML regardless of what you named it. > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> > <META content="MSHTML 6.00.2900.2769" name=GENERATOR> <STYLE></STYLE> > </HEAD> > <BODY> [rest snipped] Are you aware that you can define the type of column by using the table presented in the import dialogue? Try it rather than accepting the default. -- Documentation Co-lead "Dinna meddle wi' things ye ken nuthin' aboot!" J.H. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
