More testing, first on (Ubuntu 10.04/OpenOffice 3.2), then again on (Ubuntu 9.10/OpenOffice 3.1.1), shows more about the problem.
(a) things work better on 10.04/OO 3.2; in particular, if you pre- select the non-contiguous areas _before_ doing the Insert -> Chart function, then OO remembers the selection, and charts it properly without having to select it again in the Data Range selection step in the wizard; (b) in the more-automatic mode as in (a), I noticed that OO3.2 uses a "," not a ";" to separate the non-contiguous ranges of data; (c) going back to 9.10/OO 3.1.1, but now using a comma rather than the semicolon, OO now allows the Data Range non-contiguous selection to proceed, and the chart is displayed properly; (d) in 9.10/OO 3.1.1, if you pre-select the non-contiguous range, then do the Insert -> Chart wizard, OO will forget the selection, and ask for the data range from scratch, in the Data Range selection step of the wizard; this is a possible new bug in 3.1.1, if the pre-selection method is supposed to work like this in 3.1.1; (e) the help package in both OO3.1.1 and OO3.2 incorrectly states that one should use the semicolon to separate the parts of the non-contiguous data selection; see the built-in help package under charts:inserting in the Data Range selection portion, where the semicolon is specified explicitly and in the example; this is the cause of the originally- reported bug (Data Range spec text box will turn red as soon as a ";" is typed, but will be OK if a "," is typed to separate the non-contiguous range spec) I hope the above notes clarify what is happening. I think the resolution should be to: 1. fix the help package, and any other docs, that specify the use of the semicolon as the data range separator, instead of the correct comma; 2. open another bug against OO3.1.1, if the pre-selected data range is supposed to be noticed and used by OO in the Insert -> Chart wizard Data Range step -- 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
