Bug#617852: [openoffice.org-calc] numbers in fixed-width tables with nbsp are not imported correctly

[Maximilian Gaukler <development@maxgaukler.de>]

Package: openoffice.org-calc
Version: 1:3.2.1-11+squeeze2
Severity: normal

Pasting a fixed-width text table into OpenOffice Calc does not correctly handle non-break spaces as normal spaces.
Such non-break space characters 0xc2a0 are e.g. present in emails copied from a web browser.
I attached a test file, please paste the five lines into OOCalc as described:

- Open the file in KWrite.
- Copy the five lines appropriate for your locale from the file.
- Open a new OOCalc document. Control-Shift-V. Choose "unformatted text". Select "Fixed width", place a column separator at position 7 (exactly between --> and <--). Activate "Quoted field as text" and "Detect special numbers". Make sure that the column types are set to "Standard".

All numbers will be okay, except for the " 1.23" in line 3, which has a trailing space and cannot be used for formula calculations.

Openoffice should handle non-break spaces just like normal spaces.

Thanks

Max Gaukler


--- System information. ---
Architecture: amd64
Kernel: Linux 2.6.32-5-amd64

Debian Release: 6.0
500 stable security.debian.org
500 stable ftp.uni-erlangen.de
500 squeeze-updates ftp.uni-erlangen.de

--- Package information. ---
Depends (Version) | Installed
===========================================================-+-========================
openoffice.org-core (= 1:3.2.1-11+squeeze2) | 1:3.2.1-11+squeeze2
openoffice.org-base-core (= 1:3.2.1-11+squeeze2) | 1:3.2.1-11+squeeze2
libc6 (>= 2.2.5) | 2.11.2-10
libgcc1 (>= 1:4.1.1) | 1:4.4.5-8
libstdc++6 (>= 4.1.1) | 4.4.5-8
ure (>= 1.6.0) | 1.6.1+OOo3.2.1-11+squeeze2
lp-solve (>= 5.5.0.13-5+b1) | 5.5.0.13-7
openoffice.org-common (>> 1:3.2.1) | 1:3.2.1-11+squeeze2
ttf-opensymbol (>= 1:3.0) | 1:3.2.1-11+squeeze2
libc6 (>= 2.7) | 2.11.2-10
libcairo2 (>= 1.2.4) | 1.8.10-6
libcurl3-gnutls (>= 7.16.2-1) | 7.21.0-1
libdb4.8 | 4.8.30-2
libexpat1 (>= 1.95.8) | 2.0.1-7
libfreetype6 (>= 2.2.1) | 2.4.2-2.1
libgcc1 (>= 1:4.1.1) | 1:4.4.5-8
libglib2.0-0 (>= 2.12.0) | 2.24.2-1
libgraphite3 (>= 1:2.3) | 1:2.3.1-0.2
libgstreamer-plugins-base0.10-0 (>= 0.10.0) | 0.10.30-1
libgstreamer0.10-0 (>= 0.10.0) | 0.10.30-1
libgtk2.0-0 (>= 2.10) | 2.20.1-2
libhunspell-1.2-0 (>= 1.2.11) | 1.2.11-1
libhyphen0 (>= 2.4) | 2.5-1
libice6 (>= 1:1.0.0) | 2:1.0.6-2
libicu44 (>= 4.4.1-1) | 4.4.1-7
libjpeg62 (>= 6b1) | 6b1-1
libmythes-1.2-0 | 2:1.2.1-1
libneon27-gnutls (>= 0.29.3-3) | 0.29.3-3
libnspr4-0d (>= 1.8.0.10) | 4.8.6-1
libnss3-1d (>= 3.12.0~1.9b1) | 3.12.8-1
libsm6 | 2:1.1.1-1
libssl0.9.8 (>= 0.9.8m-1) | 0.9.8o-4squeeze1
libstdc++6 (>= 4.4.0) | 4.4.5-8
libx11-6 | 2:1.3.3-4
libxaw7 | 2:1.0.7-1
libxext6 | 2:1.1.2-1
libxinerama1 | 2:1.1-3
libxml2 (>= 2.7.4) | 2.7.8.dfsg-2
libxrandr2 | 2:1.3.0-3
libxrender1 | 1:0.9.6-1
libxslt1.1 (>= 1.1.25) | 1.1.26-6
libxt6 | 1:1.0.7-1
ure (>= 1.6.1) | 1.6.1+OOo3.2.1-11+squeeze2
zlib1g (>= 1:1.1.4) | 1:1.2.3.4.dfsg-3
librdf0 (>= 1.0.9) | 1.0.10-3
fontconfig | 2.8.0-2.1


Package's Recommends field is empty.

Package's Suggests field is empty.



Copy the five lines and insert them into oocalc as unformatted text, fixed width, two columns (exactly between the arrows), "detect special numbers" on
Lines 2 and 3 ("bug") with non-break space 0xc2a0, a.k.a. &nbsp;
Lines 4 and 5 ("okay") with normal space 0x20
Does your locale use "." as a decimal point, like in "15.99 $"? Then use a), otherwise use b).

a) for locales en-US and similar ("15.99 $")
------><----
bug    11.34
bug     1.23
okay   11.34
okay    1.23


b) for locales de-DE and similar ("15,99 $")
------><----
bug    11,34
bug     1,23
okay   11,34
okay    1,23