Your message dated Thu, 16 May 2013 09:53:16 +0000
with message-id <[email protected]>
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 [email protected]
immediately.)


-- 
617852: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=617852
Debian Bug Tracking System
Contact [email protected] 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
[email protected].

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

--- End Message ---

Reply via email to