Package: gnumeric
Version: 1.10.17-1
Severity: normal
Thank you for maintaining gnumeric.
It seems to me to be an excellent piece of code.
I happened to notice a problem.
When I tried to have a pie chart's values
indirectly use an array, it failed.
Here's how I elicited the bug:
1.) Run gnumeric
2.) Enter 1, 2 and 3 in cells A1:C1
3.) Enter A1:C1 in cell A2
4.) Enter =sum(indirect(A2)) in cell A3
This should indirectly report a sum of 6,
which is OK.
However, it seems to me that a similar
technique fails with a pie chart.
5.) Click on its icon to "Insert a Chart", and
then follow these menu options...
->Pie->Forward->Series1->Values
6.) This should show you a window where you can
tell gnumeric which values to chart
7.) At least for me, specifying the chart's value
range as either A2 or indirect(A2) renders a
blank pie chart, and =A2 and =indirect(A2)
report "invalid expression".
It seems to me that being able to chart values
indirectly would ultimately allow charts to be
automatically updated when new rows or columns of
values are added to spread sheets.
Thanks,
Kingsley
-- System Information:
Debian Release: wheezy/sid
APT prefers unstable
APT policy: (990, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 3.0.0-1-686-pae (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages gnumeric depends on:
ii debconf [de 1.5.41 Debian configuration management sy
ii gconf2 2.32.4-1 GNOME configuration database syste
ii gnumeric-co 1.10.17-1 spreadsheet application for GNOME
ii gsfonts 1:8.11+urwcyr1.0.7~pre44-4.2 Fonts for the Ghostscript interpre
ii libatk1.0-0 2.0.1-2 ATK accessibility toolkit
ii libc6 2.13-16 Embedded GNU C Library: Shared lib
ii libcairo2 1.10.2-6.1 The Cairo 2D vector graphics libra
ii libgdk-pixb 2.23.5-3 GDK Pixbuf library
ii libglib2.0- 2.28.6-1 The GLib library of C routines
ii libgoffice- 0.8.17-1 Document centric objects library -
ii libgsf-1-11 1.14.21-1 Structured File Library - runtime
ii libgtk2.0-0 2.24.5-4 GTK+ graphical user interface libr
ii libpango1.0 1.28.4-2 Layout and rendering of internatio
ii libxml2 2.7.8.dfsg-4 GNOME XML library
ii procps 1:3.2.8-11 /proc file system utilities
ii zlib1g 1:1.2.3.4.dfsg-3 compression library - runtime
Versions of packages gnumeric recommends:
ii evince 2.32.0-1 Document (PostScript, PDF) viewer
ii lp-solve 5.5.0.13-7 Solve (mixed integer) linear progr
Versions of packages gnumeric suggests:
pn epiphany-browser <none> (no description available)
ii gnumeric-doc 1.10.17-1 spreadsheet application for GNOME
pn gnumeric-plugins-extra <none> (no description available)
ii ttf-liberation 1.07.0-1 Fonts with the same metrics as Tim
-- debconf information:
* gnumeric/existing-process: true
gnumeric/existing-process-title:
--
To UNSUBSCRIBE, email to [email protected]
with a subject of "unsubscribe". Trouble? Contact [email protected]
