[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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

Your message dated Thu, 16 May 2013 09:53:16 +0000
with message-id <E1Ucus8-0005SM-00@franck.debian.org>
and subject line Bug#706870: Removed package(s) from unstable
has caused the Debian Bug report #617852,
regarding [openoffice.org-calc]  numbers in fixed-width tables with nbsp are not imported correctly
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact owner@bugs.debian.org
immediately.)


-- 
617852: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=617852
Debian Bug Tracking System
Contact owner@bugs.debian.org with problems
--- Begin Message --- 
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

--- End Message ---
--- Begin Message --- 
Version: 1:3.4.0~ooo340m1-7+rm

Dear submitter,

as the package openoffice.org has just been removed from the Debian archive
unstable we hereby close the associated bug reports.  We are sorry
that we couldn't deal with your issue properly.

For details on the removal, please see http://bugs.debian.org/706870

The version of this package that was in Debian prior to this removal
can still be found using http://snapshot.debian.org/.

This message was generated automatically; if you believe that there is
a problem with it please contact the archive administrators by mailing
ftpmaster@debian.org.

Debian distribution maintenance software
pp.
Ansgar Burchardt (the ftpmaster behind the curtain)

--- End Message ---
Reply to: