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 -- To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org