GNOME Bugzilla – Bug 166770
move/copy sheets between documents
Last modified: 2018-05-22 13:09:24 UTC
Version details: 1.4.2-2 Debian/Sarge Distribution/Version: Debian/Sarge Gnumeric should provide a menue supported method to move or copy sheets between documents. See the attached screenshot of OO (which is a clone of the similar XL-feature). Unfortunately the workaround (create new sheet in other document, mark source-sheet, paste) does not work reliable. In 3 trials 2 did not work, but the bugs seem not easy to reproduce.
Created attachment 37233 [details] OO move/copy sheet screenshot
The copy-paste method really ought to work and is probably the only that is going to work between workbooks held in different instances of gnumeric. Do you recall in what way the copy wasn't right?
I really don't remember very exactly. It was under win. The source was a workbook with more than a dozen sheets, many references between the sheets, and references to an other workbook as well. I copied two sheets, "bil" and "data", where "bil" has many references to "data". The first try ended in defected formulas, something like this: "\"string...." instead of "string ... This was on copying "bil". AFAIR(?) all cells with references to "data" where defected, "data" not present in the target. The second try it copied "data" first which has no references to other sheets. Dont't know, if it was on pasting "data" or "bil", where I got "XML error(?)" popups. The XML file looked like missing important parts at the begin. The next try after restart, copy "data" first, then "bil" worked. Hope to have time to reproduce this today evening.
Aha, putting an expression between DOUBLE QUOTES, if the referenced worksheet does not exist in the target workbook seems intended behaviour. It's not a coding bug, but IMHO inconsistant design. I opened http://bugzilla.gnome.org/show_bug.cgi?id=167308 for this problem.
*** Bug 628888 has been marked as a duplicate of this bug. ***
mentioned in mailing list https://mail.gnome.org/archives/gnumeric-list/2013-May/msg00013.html this feature tentatively was able to be implemented with extending existing code from sheet_dup (Sheet const *src) to sheet_dup_with_workbook (Sheet const *src, Workbook *dstwb) but I didn't commit because I don't know well about good coding manners
-- GitLab Migration Automatic Message -- This bug has been migrated to GNOME's GitLab instance and has been closed from further activity. You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/35.