GNOME Bugzilla – Bug 337968
Importing to Gnumeric with non-English chars from Lotus 1-2-3 files
Last modified: 2006-05-21 08:30:44 UTC
I'm trying to open Lotus 1-2-3 files with Chinese characters in Gnumeric. They failed to be imported using the right encoding. Sometimes "?" appears, and sometimes the sheet is empty. OpenOffice.org 2.0 allows me to import those files. When I open the file, it asks me which character set. I answered Big5, and then the file is opened correctly, though they do not import any formatting.
Created attachment 63152 [details] Sample file with Chinese chars The cells A1, A2, ... A11 contains Chinese text for numbers 1, 2, ..., 11 respectively.
Created attachment 63153 [details] Screenshot by OOo 2.0 This is how the Chinese text looks like
Fixed in cvs HEAD. There were two problems: 1. The default character set was assumed to be LMBCS' group 1. The above file has it as group 0x12. 2. Group 0x12 was not implemented. I am currently assuming that it is identical to "code page 950". My docs only really say that it is based on that code page, but I am hoping this is good enough.
One more fix was needed: the format for the cells was incorrectly set to "" causing the cells to appear blank. Now fixed.
It works. Thanks!