GNOME Bugzilla – Bug 97216
Graph guru should support chart data from a different sheet.
Last modified: 2008-06-19 13:02:30 UTC
I'm writing up a few points which ought to be supported once graphs work again. The formula guru should support building graphs from data on a different sheet. All of the following seem to me like useful ways to do it: 1. a: Mark a range in some sheet. b: Switch to another sheet and bring up graph guru. Guru should now use the range from a. c: Continue as normal 2. a: Work with graph guru as normal from the sheet with the data b: After "Finish", switch to another sheet and place the chart there. 3. a: Make chart on same sheet as data b: Cut chart and paste it onto a different sheet. In 1.0.x, you have to enter a range from a different sheet manually.
I don't think you mean the formula guru but the graph guru. The formula guru has little to do with graphs.
Absolutely right, Andreas!
1) is next to impossible. The current sheet is going to have its own selection. At best we could notice that the current selection is empty and try to use the selection from the last sheet we looked at ? Sounds like we might be trying to be too smart. 2) Good point. This might be tricky given the current architecture that puts the responsibility for object creation in the scg. Lets keep it in mind. 3) The is definitely a requirement at some point. As things stand there is no clipboard support for objects at all.
We can actually cause a fair amount of trouble with this. - create chart on sheet1 - edit series - move to another sheet and select data - hit ok we remain on the last visible sheet and do not jump back to the sheet with the object placement.
I'll patch that last bug now, it's fairly serious.
*** Bug 152611 has been marked as a duplicate of this bug. ***
Now, it's possible to cut'n paste a chart object from one sheet to another.
Implemented (2).