Public bug reported:

Binary package hint: openoffice.org

In Calc, select 'Insert" => 'Chart', then in the wizard box that
appears, select  chart type 'Line' then 'Points and Lines". then 'Next'.

The Data Rage selection step is then presented in the wizard box.

Attempts to set a non-contiguous data range, as shown in the help package, Calc 
will not accept a seemingly valid range. 
After the first column selection is show correctly in the text box, and then a 
semicolon is manually typed, the wizard turns the color of the text box for the 
datarange red, and refuses to accept the following input text:

$Sheet1.$A$4:$A$63;$Sheet1.$O$4:$O$63

On windows (Vista in my case) a similar selection procedure works as
expected.

When in this mode (text box is red), Calc also won't allow the selecting
or de-selecting of the choices that are presented below the text box.

A simple test spreadsheet with 3 columns, each having a few rows of
numbers, should show this problem.    Try selecting the first, then the
third columns for charting.     In this simple case, the text box would
contain e.g.:

$Sheet2.$A$1:$A$4;$Sheet2.$C$1:$C$4

ProblemType: Bug
Architecture: amd64
Date: Wed Apr 28 19:53:05 2010
DistroRelease: Ubuntu 9.10
InstallationMedia: Kubuntu 9.10 "Karmic Koala" - Release amd64 (20091027)
NonfreeKernelModules: nvidia
Package: openoffice.org-core 1:3.1.1-5ubuntu1.1
ProcEnviron:
 LANGUAGE=
 PATH=(custom, no user)
 LANG=en_US.UTF-8
 SHELL=/bin/bash
ProcVersionSignature: Ubuntu 2.6.31-20.58-generic
SourcePackage: openoffice.org
Uname: Linux 2.6.31-20-generic x86_64
XsessionErrors:
 (firefox:5349): GLib-WARNING **: g_set_prgname() called multiple times
 (polkit-gnome-authentication-agent-1:5363): GLib-CRITICAL **: 
g_once_init_leave: assertion `initialization_value != 0' failed

** Affects: openoffice.org (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug

-- 
spreadsheet: inserting a chart won't allow setting non-contigous datarange
https://bugs.launchpad.net/bugs/571529
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.

-- 
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs

Reply via email to