Bug#594120: openoffice.org-calc: Function Wizard omits sheet reference
Package: openoffice.org-calc
Version: 1:3.2.1-6
Severity: normal
Steps to reproduce:
1. Open Calc and enter "Debian" in cell Sheet1.A1, and "Squeeze" in cell
Sheet2.A1
2. In cell Sheet1.C1, open the Function Wizard and select CONCATENATE and
choose
text1: A1 (on Sheet1)
text2: "-"
text3: A1 (on Sheet2)
The resulting formula looks like this: =CONCATENATE(A1:A1;"-";A1:A1) Circular
Reference
expected to look like this: =CONCATENATE(A1;"-";Sheet2.A1)
Tested on Squeeze 3.2.1-5 and Sid 3.2.1-6
-- System Information:
Debian Release: squeeze/sid
APT prefers testing
APT policy: (500, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.32-5-686 (SMP w/1 CPU core)
Locale: LANG=en_US.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Versions of packages openoffice.org-calc depends on:
ii libc6 2.11.2-2 Embedded GNU C Library: Shared lib
ii libgcc1 1:4.4.4-8 GCC support library
ii libstdc++6 4.4.4-8 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-7 STLport C++ class library
ii lp-solve 5.5.0.13-7 Solve (mixed integer) linear progr
ii openoffice.org-base-cor 1:3.2.1-6 office productivity suite -- share
ii openoffice.org-core 1:3.2.1-6 office productivity suite -- arch-
ii ure 1.6.1+OOo3.2.1-5 OpenOffice.org UNO runtime environ
openoffice.org-calc recommends no packages.
openoffice.org-calc suggests no packages.
Versions of packages openoffice.org-core depends on:
ii fontconfig 2.8.0-2.1 generic font configuration library
ii libc6 2.11.2-2 Embedded GNU C Library: Shared lib
ii libcairo2 1.8.10-4 The Cairo 2D vector graphics libra
ii libcurl3-gnutls 7.21.0-1 Multi-protocol file transfer libra
ii libdb4.8 4.8.26-1 Berkeley v4.8 Database Libraries [
ii libexpat1 2.0.1-7 XML parsing C library - runtime li
ii libfreetype6 2.4.2-1 FreeType 2 font engine, shared lib
ii libgcc1 1:4.4.4-8 GCC support library
ii libglib2.0-0 2.24.1-1 The GLib library of C routines
ii libgraphite3 1:2.3.1-0.2 SILGraphite - a "smart font" rende
ii libgstreamer-plugins-ba 0.10.30-1 GStreamer libraries from the "base
ii libgstreamer0.10-0 0.10.30-1 Core GStreamer libraries and eleme
ii libgtk2.0-0 2.20.1-1 The GTK+ graphical user interface
ii libhunspell-1.2-0 1.2.11-1 spell checker and morphological an
ii libhyphen0 2.5-1 ALTLinux hyphenation library - sha
ii libice6 2:1.0.6-1 X11 Inter-Client Exchange library
ii libicu44 4.4.1-6 International Components for Unico
ii libjpeg62 6b1-1 The Independent JPEG Group's JPEG
ii libmythes-1.2-0 2:1.2.1-1 simple thesaurus library
ii libneon27-gnutls 0.29.3-2 An HTTP and WebDAV client library
ii libnspr4-0d 4.8.4-2 NetScape Portable Runtime Library
ii libnss3-1d 3.12.6-3 Network Security Service libraries
ii librdf0 1.0.10-2 Redland Resource Description Frame
ii libsm6 2:1.1.1-1 X11 Session Management library
ii libssl0.9.8 0.9.8o-1 SSL shared libraries
ii libstdc++6 4.4.4-8 The GNU Standard C++ Library v3
ii libstlport4.6ldbl 4.6.2-7 STLport C++ class library
ii libx11-6 2:1.3.3-3 X11 client-side library
ii libxaw7 2:1.0.7-1 X11 Athena Widget library
ii libxext6 2:1.1.2-1 X11 miscellaneous extension librar
ii libxinerama1 2:1.1-3 X11 Xinerama extension library
ii libxml2 2.7.7.dfsg-4 GNOME XML library
ii libxrandr2 2:1.3.0-3 X11 RandR extension library
ii libxrender1 1:0.9.6-1 X Rendering Extension client libra
ii libxslt1.1 1.1.26-5 XSLT 1.0 processing library - runt
ii libxt6 1:1.0.7-1 X11 toolkit intrinsics library
ii openoffice.org-common 1:3.2.1-5 office productivity suite -- arch-
ii ttf-opensymbol 1:3.2.1-5 OpenSymbol TrueType font
ii ure 1.6.1+OOo3.2.1-5 OpenOffice.org UNO runtime environ
ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime
-- no debconf information
Reply to: