Bug#228117: spreadsheet csv import type conversion error

[Florian Boor <florian.boor@kernelconcepts.de>]

Subject: openoffice.org: spreadsheet import type conversion error
Package: openoffice.org
Version: 1.1.0-3
Severity: normal

Doing a CSV import some vealues seem to be converted in a wrong way.
e.g. a file containing a line like this:

19331.640822,95.7035,0.0,0.0,0.0,0.0,1.8526,0.0,0.0,0.1926,0.0,0.0,0.0,0.0,0.0,0.0

Is displayes correctly in the import dialog, the value 1.8526 is shown
like in the original file. After importing it changes to: 01.01.8526
which seems to be a date value. 
Changing cell formating results in completely wrong values.

The language setting for the document was en_GB.


-- System Information:
Debian Release: testing/unstable
Architecture: i386
Kernel: Linux thunder 2.6.0-test2 #30 SMP Fr Sep 26 14:48:56 CEST 2003
i686
Locale: LANG=de_DE.ISO-8859-1, LC_CTYPE=de_DE.ISO-8859-1 (ignored:
LC_ALL set to de_DE)

Versions of packages openoffice.org depends on:
ii  dictionaries-common           0.16.2     Common utilities for
spelling dict
ii  openoffice.org-bin            1.1.0-3    OpenOffice.org office suite
binary
ii  openoffice.org-debian-files   1.1.0-3+2  Debian specific parts of
OpenOffic
ii  openoffice.org-l10n-de [openo 1.1.0-3    German language package for
openof
ii  openoffice.org-l10n-en [openo 1.1.0-3    English US language package
for op

-- no debconf information

-- 
The dream of yesterday                  Florian Boor
is the hope of today                    Tel: 0271-771091-14 
and the reality of tomorrow.            Fax: 0271-771091-19 
[Robert Hutchings Goddard, 1904]        florian.boor@kernelconcepts.de 

6C 44 30 4C 43 20 6B 61  16 07 0F AA E6 97 70 A8