Issue 60296 - Calc: can't import fixed-width CSV with Thai text
Summary: Calc: can't import fixed-width CSV with Thai text
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks: 41707
  Show dependency tree
 
Reported: 2006-01-10 06:47 UTC by pocha
Modified: 2013-08-07 15:14 UTC (History)
7 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Import to calc file (36 bytes, text/plain)
2006-01-10 06:52 UTC, pocha 		no flags Details
Wrong display screenshot. (12.61 KB, image/png)
2006-01-10 06:54 UTC, pocha 		no flags Details
The first csv with 1st row's English word changed to Thai (35 bytes, text/plain)
2006-02-17 02:53 UTC, samphan 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description pocha 2006-01-10 06:47:32 UTC 
I have a fixed width CSV file and I want to import to Calc but I have problem
with Fixed width setting. I can't set column to fit because Thai text is wrongly
displayed.

1. Go to menu File ->Open.
2. Click "Files of type:" list box and choose "Text CSV(*csv, *.txt)".
3. Open the file from attachment.
4. Click "Character set" list box and choose "Thai(ISO-8859-11/TIS-620)".
5. Click "Fix width" and set column.
6. Set the separator of "column 1" behind the number "1".
7. Try to set the separator of "column 2" before "England", It will be
impossible because Thai text display is wrong.(See the screenshot)

If I did not set Character set to "Thai(ISO-8859-11/TIS-620), the result is OK.
I can set the columns to fit.
Comment 1 pocha 2006-01-10 06:52:37 UTC 
Created attachment 33074 [details]
Import to calc file
Comment 2 pocha 2006-01-10 06:54:16 UTC 
Created attachment 33075 [details]
Wrong display screenshot.
Comment 3 lars 2006-01-10 18:04:49 UTC 
confirmed on Windows XP Pro SP2 with OOo 2.0.1. there is too few space before 
Thai text.
Comment 4 samphan 2006-01-10 18:23:43 UTC 
When you're moving the vertical separator-line before the column with Thai text,
you'll see another copy of the Thai text sliding, overlapping the existing one.
This does not happen if Calc doesn't know it is Thai (e.g. tell Calc that it is
ISO-8859-1). So Calc might treat the widths of non-western characters strangely.

This doesn't happen in Excel. Excel imports such Thai fixed-width CSV easily.
Comment 5 frank 2006-02-03 12:10:16 UTC 
could not reproduce using internal m154 build (upcoming OOo2.0.2). Therefore
closed wfm.

Frank
Comment 6 frank 2006-02-03 12:10:53 UTC 
closed wfm
Comment 7 samphan 2006-02-17 02:49:52 UTC 
I've tested the first example csv in 2.0.2rc1. Though it's possible to set the
separator of the two data columns, it's hard because the display of the second
row is still wrong. The same as in the screenshot.
If we try to import more complex Thai fixed-with csv, it will be impossible
because of this. Actually, I have real-life example that is impossible to set
the separators.

To illustrate this, I'll attach another simple example. The same as the first
but change the 1st row English text to Thai. Just two row of Thai text will make
it much harder.
Comment 8 samphan 2006-02-17 02:53:32 UTC 
Created attachment 34235 [details]
The first csv with 1st row's English word changed to Thai
Comment 9 daniel.rentz 2006-03-09 15:01:27 UTC 
taking this
Comment 10 frank 2006-03-09 15:07:43 UTC 
set the target
Comment 11 daniel.rentz 2006-04-05 13:06:52 UTC 
started
Comment 12 daniel.rentz 2006-07-11 12:47:32 UTC 
fixed in SRC680/calc37 (OOo 2.0.4)
Comment 13 daniel.rentz 2006-07-19 12:40:04 UTC 
back to QA
Comment 14 oc 2006-07-21 14:09:16 UTC 
verified in internal build cws_calc37
Comment 15 oc 2006-08-08 09:51:49 UTC 
closed because fix available in OOom180