Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV file give different result when open in excel 2003 SP2 & Sp3
Hi,
I have a CSV file which data extracted from a backend database. I noticed this CSV file when open in excel 2003 on different machine give different result. The raw data of the CSV file, the text for one particular cell consists of a charactor ASCII (10). The way i open the excel file is by doing a double click on file explorer. The different result is as below: (1) When i open in 1 machine ( with excel 2003 SP2 installed ), the contents of the cell displayed nicely with format in 'wrap text' . (2) When I try on another machine (with excel 2003 Sp3 ), the text is not wrap but it become a line break instead, making the contents after that move to the next row. I had been trying to trouble shoot by doing a data import wizard using File-Open. I leave the code page as Windows(ANSI) unchange, and delimiter as 'TAB', the result is just like (2) , the char(10) had been treated as a line break. Is it something to do with the different in service pack ? Can anyone let me know how could i make the result just like in (1) in machine 2 ? Please help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV file give different result when open in excel 2003 SP2 & Sp3
Hi,
We had found out the root cause. I goto setting-Control Panel-Add Remove programs check the "Show Updates" and uninstall a security Patch for Excel (KB943985) dated somewhere in March, and reboot your machine. Once rebooted, i double clieck on the file no more issues. The result show correctly as in past. Hope this post help those who face the similiar problem. Kind regards, Alchemist. "Alchemist" wrote: Hi, I have a CSV file which data extracted from a backend database. I noticed this CSV file when open in excel 2003 on different machine give different result. The raw data of the CSV file, the text for one particular cell consists of a charactor ASCII (10). The way i open the excel file is by doing a double click on file explorer. The different result is as below: (1) When i open in 1 machine ( with excel 2003 SP2 installed ), the contents of the cell displayed nicely with format in 'wrap text' . (2) When I try on another machine (with excel 2003 Sp3 ), the text is not wrap but it become a line break instead, making the contents after that move to the next row. I had been trying to trouble shoot by doing a data import wizard using File-Open. I leave the code page as Windows(ANSI) unchange, and delimiter as 'TAB', the result is just like (2) , the char(10) had been treated as a line break. Is it something to do with the different in service pack ? Can anyone let me know how could i make the result just like in (1) in machine 2 ? Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
excel 2003 saved file will not open without a blank workbook open | Excel Discussion (Misc queries) | |||
I have Excel 2003 and want to open an old WB2 file How do i do it | Excel Discussion (Misc queries) | |||
how do i give password to open for Excel File? | Excel Discussion (Misc queries) | |||
File won't open in Excel 2003 | Excel Discussion (Misc queries) |