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 -- To UNSUBSCRIBE, email to debian-qt-kde-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org Archive: http://lists.debian.org/20101014020642.11034.33839.report...@spacedout.fries.net
