You may all know this well-kept secret but I just found this out, and I think it's worth sharing: I've been using gnumeric for years, but sometimes I complain that I can't 'paste as value' from one workbook to another. I've been working around this by pasting as value into a blank sheet in the same document, then doing a normal paste into the other document.
It turns out that that's because I tend to open documents by double clicking on the file icon. If on the other hand you open the second document from File -> Open, you can indeed paste special as expected. I discovered this while reading a bug report below. https://bugs.launchpad.net/ubuntu/+source/gnumeric/+bug/307879. Looking forward to some serious time-saving now... -- View this message in context: http://old.nabble.com/Solution-to-Paste-Special-from-one-gnumeric-document-to-another-tp35223398p35223398.html Sent from the GnuMeric mailing list archive at Nabble.com. _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org https://mail.gnome.org/mailman/listinfo/gnumeric-list