GNOME Bugzilla – Bug 127734
bad import of this .slk file: change of cell position
Last modified: 2004-12-22 21:47:04 UTC
When importing the .slk file I will attach, the line number 101 is strange: -C101 has gone to A101 -A101 does not exist anymore (with respect to an import of the same file in XL2k)
Created attachment 21720 [details] The .slk file showing the problem
Content appears in the expected places for me. What locale are you doing this in ? Can you try 'C' to see if that changes anything ?
I am using french env variables(LC_NUMERIC,LANG,LANGUAGE, ...) Does that answer your question ? How do you set the locale to 'C' ? Are you sure content is in the expected places for you ? What is the content of cell A101 ? If it is -81.16, the import is wrong (-81.16 should be the content of cell C101). I will attach a screenshot showing how it looks like for me.
Created attachment 22479 [details] How the .slk file looks like for me in gnumeric (after scrolling down the window)
I can't replicate that. Althouggh autosizing of columns does seem to have some problems which I'll look at. what is the exact setting for LC_ALL that you use ? I tried LC_ALL fr_FR and things looked fine.
Very strange. The output of 'env' command line has no LC_ALL setting for me by default. There are: LC_PAPER, LC_ADDRESS, LC_MONETARY, LC_NUMERIC, LC_TELEPHONE, LC_MESSAGES, LC_IDENTIFICATION, LC_COLLATE, LC_MEASUREMENT, LC_CTYPE, LC_TIME, LC_NAME, all are =fr_FR, but there is no LC_ALL. I have tried with LC_ALL=en_US, but it does not change the problem. I suspect this problem to come from a character coding issue. Mandrake has a strange way to code "." I had a similar bug with OpenOffice. Perhaps I could ask gnumeric packager (Frederic Crozat) to look at this issue. BTW, the column sizing issue was reported to bug 127736.
Another information on this bug: A) It seems it happens only if the number of the line is greater or equal to 100. If I open the file in excel, suppress several lines until the non-empty lines are <100, and save the file, it opens without problem in gnumeric. If I do the same but in adding new lines instead of suppressing them, the problem still shows. B) It is related to the decimal separator of the number "-81.16" If I manually edit the file, supress ".16", and save the file, the problem disappears. If I re-edit the file, re-add ".16" and save the file, the problem re-shows.
Grief. This was a much larger issue than expected. It was actually a memory overrun problem that happended to require a different decimal seperator. I've ended up basicly rewriting the sylk importer to use some of the more modern features in gnumeric.
Re-opening bug to mark it as fixed.
Marking this bug as fixed.