Bug#529430: openoffice.org: Fails to order date formulas
Package: openoffice.org
Version: 1:3.1.0-1
Severity: normal
In OOo 3.1 cells with date formulas using cell references are not ordered correctly: ie
cell references are not updated to reflect the new ordering.
For example: I have 2 rows with 2 columns:
01/04/09 | =A1+10
01/03/09 | =A2+15
If i order the two columns on the first one i got
01/03/09 | =A2+15
01/04/09 | =A1+10
Instead of
01/03/09 | =A1+15
01/04/09 | =A2+10
OOo 3.0 works ok
Apparently OOo 3.1 on other platform is ok as well.
-- System Information:
Debian Release: squeeze/sid
APT prefers unstable
APT policy: (990, 'unstable'), (1, 'experimental')
Architecture: i386 (x86_64)
Kernel: Linux 2.6.29-2-amd64 (SMP w/2 CPU cores)
Locale: LANG=it_IT.UTF-8, LC_CTYPE=it_IT.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages openoffice.org depends on:
ii liblucene2-java 2.4.0+ds1-5 Full-text search engine library fo
ii openoffice.org-base 1:3.1.0-1 full-featured office productivity
ii openoffice.org-calc 1:3.1.0-1 full-featured office productivity
ii openoffice.org-core 1:3.1.0-1 full-featured office productivity
ii openoffice.org-draw 1:3.1.0-1 full-featured office productivity
ii openoffice.org-filter-mobile 1:3.1.0-2 full-featured office productivity
ii openoffice.org-impress 1:3.1.0-1 full-featured office productivity
ii openoffice.org-java-common 1:3.1.0-2 full-featured office productivity
ii openoffice.org-math 1:3.1.0-1 full-featured office productivity
ii openoffice.org-officebean 1:3.1.0-1 full-featured office productivity
ii openoffice.org-report-builde 1:3.1.0-1 OpenOffice.org extension for build
ii openoffice.org-writer 1:3.1.0-1 full-featured office productivity
ii ttf-dejavu 2.29-2 Metapackage to pull in ttf-dejavu-
Versions of packages openoffice.org recommends:
ii openoffice.org-filter-binfilt 1:3.1.0-1 full-featured office productivity
ii ttf-liberation 1.04.93-1 Free fonts with the same metrics a
Versions of packages openoffice.org suggests:
ii cups-bsd 1.3.10-1 Common UNIX Printing System(tm) -
pn gstreamer0.10-ffmpeg <none> (no description available)
pn gstreamer0.10-plugins-ba <none> (no description available)
pn gstreamer0.10-plugins-ba <none> (no description available)
pn gstreamer0.10-plugins-go <none> (no description available)
pn gstreamer0.10-plugins-ug <none> (no description available)
pn hunspell-dictionary <none> (no description available)
ii iceweasel 3.0.9-1 lightweight web browser based on M
ii imagemagick 7:6.5.1.0-1 image manipulation programs
ii libgl1-mesa-glx [libgl1] 7.4.1-1 A free implementation of the OpenG
ii libpaper-utils 1.1.23+nmu1 library for handling paper charact
ii libsane 1.0.20-4 API library for scanners
ii libxrender1 1:0.9.4-2 X Rendering Extension client libra
ii menu 2.1.41 generates programs menu for all me
ii myspell-en-us [myspell-d 1:3.1.0-1 English_american dictionary for my
ii myspell-it [myspell-dict 1:3.1.0-1 Italian dictionary for myspell
ii openclipart-openoffice.o 0.18+dfsg-8 clip art for OpenOffice.org galler
pn openoffice.org-gnome <none> (no description available)
ii openoffice.org-help-it [ 1:3.1.0-2 full-featured office productivity
ii openoffice.org-hyphenati 1:3.1.0-1 Italian hyphenation patterns for O
ii openoffice.org-l10n-it [ 1:3.1.0-2 full-featured office productivity
ii openoffice.org-thesaurus 2.0.7.gh.deb1-1 Italian Thesaurus for OpenOffice.o
ii pstoedit 3.45-7 PostScript and PDF files to editab
ii sun-java6-jre 6-13-1 Sun Java(TM) Runtime Environment (
ii unixodbc 2.2.11-16+b1 ODBC tools libraries
Versions of packages openoffice.org-core depends on:
ii fontconfig 2.6.0-3 generic font configuration library
ii libc6 2.9-12 GNU C Library: Shared libraries
ii libcairo2 1.8.6-2+b1 The Cairo 2D vector graphics libra
ii libcurl3-gnutls 7.19.4-1 Multi-protocol file transfer libra
ii libdb4.7 4.7.25-6 Berkeley v4.7 Database Libraries [
ii libexpat1 2.0.1-4 XML parsing C library - runtime li
ii libfreetype6 2.3.9-4.1 FreeType 2 font engine, shared lib
ii libgcc1 1:4.4.0-5 GCC support library
ii libglib2.0-0 2.20.1-2 The GLib library of C routines
ii libgstreamer-plugins-b 0.10.23-2 GStreamer libraries from the "base
ii libgstreamer0.10-0 0.10.23-1 Core GStreamer libraries and eleme
ii libgtk2.0-0 2.16.1-2 The GTK+ graphical user interface
ii libhunspell-1.2-0 1.2.8-3 spell checker and morphological an
ii libhyphen0 2.4-4 ALTLinux hyphenation library - sha
ii libice6 2:1.0.5-1 X11 Inter-Client Exchange library
ii libicu40 4.0.1-2 International Components for Unico
ii libjpeg62 6b-14 The Independent JPEG Group's JPEG
ii libldap-2.4-2 2.4.15-1.1 OpenLDAP libraries
ii libneon27 0.28.2-6.1+b1 An HTTP and WebDAV client library
ii libnspr4-0d 4.7.4-2 NetScape Portable Runtime Library
ii libnss3-1d 3.12.3-1 Network Security Service libraries
ii librdf0 1.0.9-1 Redland Resource Description Frame
ii libsm6 2:1.1.0-2 X11 Session Management library
ii libstdc++6 4.4.0-5 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-5 STLport C++ class library
ii libx11-6 2:1.2.1-1 X11 client-side library
ii libxaw7 2:1.0.5-2 X11 Athena Widget library
ii libxext6 2:1.0.4-1 X11 miscellaneous extension librar
ii libxinerama1 2:1.0.3-2 X11 Xinerama extension library
ii libxml2 2.7.3.dfsg-1 GNOME XML library
ii libxrandr2 2:1.3.0-2 X11 RandR extension library
ii libxrender1 1:0.9.4-2 X Rendering Extension client libra
ii libxslt1.1 1.1.24-2 XSLT processing library - runtime
ii libxt6 1:1.0.5-3 X11 toolkit intrinsics library
ii libxtst6 2:1.0.3-1 X11 Testing -- Resource extension
ii openoffice.org-common 1:3.1.0-2 full-featured office productivity
ii ttf-opensymbol 1:3.1.0-2 OpenSymbol TrueType font
ii ure 1.5.0+OOo3.1.0-1 OpenOffice.org UNO runtime environ
ii zlib1g 1:1.2.3.3.dfsg-13 compression library - runtime
Versions of packages openoffice.org-writer depends on:
ii libc6 2.9-12 GNU C Library: Shared libraries
ii libgcc1 1:4.4.0-5 GCC support library
ii libicu40 4.0.1-2 International Components for Unico
ii libstdc++6 4.4.0-5 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-5 STLport C++ class library
ii libwpd8c2a 0.8.14-1 Library for handling WordPerfect d
ii libwps-0.1-1 0.1.2-1 Works text file format import filt
ii openoffice.org-base-co 1:3.1.0-1 full-featured office productivity
ii openoffice.org-core 1:3.1.0-1 full-featured office productivity
ii ure 1.5.0+OOo3.1.0-1 OpenOffice.org UNO runtime environ
ii zlib1g 1:1.2.3.3.dfsg-13 compression library - runtime
Versions of packages openoffice.org-calc depends on:
ii libc6 2.9-12 GNU C Library: Shared libraries
ii libgcc1 1:4.4.0-5 GCC support library
ii libstdc++6 4.4.0-5 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-5 STLport C++ class library
ii lp-solve 5.5.0.13-5 Solve (mixed integer) linear progr
ii openoffice.org-base-cor 1:3.1.0-1 full-featured office productivity
ii openoffice.org-core 1:3.1.0-1 full-featured office productivity
ii ure 1.5.0+OOo3.1.0-1 OpenOffice.org UNO runtime environ
Versions of packages openoffice.org-base depends on:
ii libc6 2.9-12 GNU C Library: Shared libraries
ii libgcc1 1:4.4.0-5 GCC support library
ii libhsqldb-java 1.8.0.10-2 Java SQL database engine
ii libstdc++6 4.4.0-5 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-5 STLport C++ class library
ii openoffice.org-base-cor 1:3.1.0-1 full-featured office productivity
ii openoffice.org-core 1:3.1.0-1 full-featured office productivity
ii openoffice.org-java-com 1:3.1.0-2 full-featured office productivity
ii sun-java6-jre 6-13-1 Sun Java(TM) Runtime Environment (
ii ure 1.5.0+OOo3.1.0-1 OpenOffice.org UNO runtime environ
Versions of packages openoffice.org-impress depends on:
ii libc6 2.9-12 GNU C Library: Shared libraries
ii libgcc1 1:4.4.0-5 GCC support library
ii libstdc++6 4.4.0-5 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-5 STLport C++ class library
ii openoffice.org-core 1:3.1.0-1 full-featured office productivity
ii openoffice.org-draw 1:3.1.0-1 full-featured office productivity
ii ure 1.5.0+OOo3.1.0-1 OpenOffice.org UNO runtime environ
Versions of packages openoffice.org-math depends on:
ii libc6 2.9-12 GNU C Library: Shared libraries
ii libgcc1 1:4.4.0-5 GCC support library
ii libstdc++6 4.4.0-5 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-5 STLport C++ class library
ii openoffice.org-core 1:3.1.0-1 full-featured office productivity
ii ure 1.5.0+OOo3.1.0-1 OpenOffice.org UNO runtime environ
-- no debconf information
Reply to: