Bug#600152: kspread: can't paste numbers
Package: kspread
Version: 1:2.2.1-3
Severity: important
A common use of spread sheets is to calculate numbers that come from
some other program. Select some text from another program like $2.34
and middle click to paste into a kspread cell. The cell is left
justified indicating that kspread is classifying it as a text string,
not a number. That is the same result as doing a copy and paste
operation with the same text (instead of the selection buffer). Type
$2.34 into another cell and it is right justified as kspread
interprits it as a number. As long as kspread classifies it as text
none of the formulas will operate on it, such as sum, and unless you
realize that it is left justified it isn't immediately obvious why all
your forumlas are broken. Editing the cell in kspread and it will
properly revert to a number.
-- System Information:
Debian Release: squeeze/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (x86_64)
Kernel: Linux 2.6.36-rc7+ (SMP w/4 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/dash
Versions of packages kspread depends on:
ii kdebase-runtime 4:4.4.5-1 runtime components from the offici
ii koffice-libs 1:2.2.1-3 common libraries and binaries for
ii libc6 2.11.2-6 Embedded GNU C Library: Shared lib
ii libgcc1 1:4.4.5-2 GCC support library
ii libgsl0ldbl 1.14+dfsg-1 GNU Scientific Library (GSL) -- li
ii libkde3support4 4:4.4.5-1 the KDE 3 Support Library for the
ii libkdecore5 4:4.4.5-1 the KDE Platform Core Library
ii libkdeui5 4:4.4.5-1 the KDE Platform User Interface Li
ii libkhtml5 4:4.4.5-1 the KHTML Web Content Rendering En
ii libkio5 4:4.4.5-1 the Network-enabled File Managemen
ii libknotifyconfig4 4:4.4.5-1 library for configuring KDE Notifi
ii libkparts4 4:4.4.5-1 the Framework for the KDE Platform
ii libkrosscore4 4:4.4.5-1 the Kross Core Library
ii libkutils4 4:4.4.5-1 various utility classes for the KD
ii libqt4-dbus 4:4.6.3-1+b1 Qt 4 D-Bus module
ii libqt4-qt3support 4:4.6.3-1+b1 Qt 3 compatibility library for Qt
ii libqt4-sql 4:4.6.3-1+b1 Qt 4 SQL module
ii libqt4-xml 4:4.6.3-1+b1 Qt 4 XML module
ii libqtcore4 4:4.6.3-1+b1 Qt 4 core module
ii libqtgui4 4:4.6.3-1+b1 Qt 4 GUI module
ii libstdc++6 4.4.5-2 The GNU Standard C++ Library v3
kspread recommends no packages.
Versions of packages kspread suggests:
ii khelpcenter4 4:4.4.5-1 help center
ii koffice-doc-html 1:2.2.1-3 KDE Office Suite documentation in
-- no debconf information
Reply to: