GNOME Bugzilla – Bug 158825
duplicating a sheet leaves the duplicate objects pointing to the original
Last modified: 2006-12-29 03:46:35 UTC
In graph guru, all entries that are cell references allways explicitely link to a sheet, even if the sheet is graph parent. It's a problem when you duplicate a sheet, since graph in the new sheet has it's references linked to the original sheet, and that's probaly not what user expects (at least not me :) ).
I agree that it would be nice if by default we would not refer to the current Sheet by name. (See 158691 for details in the differnece between A1 and Sheet!A1 if Sheet1 is current.) There is just one difficulty: When a user is completing the graph guru we don't know yet what the current sheet is: after completing the guru the user could switch to another sheet before inserting the graph.
Beyond the elements andreas mentioned there is the additional significant problem that MS Excel requires the sheet be specified. Attempting to remove it in gnumeric creates alot of work. We'd need to add it when exporting (not impossible, but uncomfortable), but more importantly on import we'd need to remove the sheet, which is problematic. I think the real question here is how to get sheet duplicate to do the right thing, rather than how to remove the explicit sheet qualification. Phrased that way, I suspect we'd have more luck extending sheet_object_clone_sheet to somehow tweak all references from @src -> @dst
*** Bug 346267 has been marked as a duplicate of this bug. ***
Fixed in the development version. The fix will be available in the next major release. Thank you for your bug report.