GNOME Bugzilla – Bug 346630
Paste special is unavailable
Last modified: 2018-04-23 08:18:03 UTC
When a sequence of numbers is in the clipboard, you can not paste as text to later convert from Text to Numbers because Paste Special is not available.
You shouldn't need "paste special" since simply "paste" should paste the sequence as text or (if you have more than one line of numbers) the configurable text importer will be opened and you can choose options for the same effect. So I don't think that this is a bug. By the way, this is not Windows specific.
Hi Andreas Please see discussion on bug 346631. If it is not a bug then I should submit a Feature request so that Paste special is available at all times so that the user and not the software may decide how he prefers to have the data pasted. When I select Windows I mean I have found this bug in the Windows version (I don't use another OS so I can't test it). I think it would be more incorrect if I said All...
Hi, I had read 346631. Note that even if "Paste Special" were available, there is no Paste Special->as text. Paste Special is intended for copy pasting within Gnumeric: you can choose to paste just specific aspects from copied gnumeric cells (or to perform some additional operations on those cells.) I think without Bug 346631 you would likely not even be looking for Paste Special to be enabled.
Similar bug report: 1) Start gnumeric, open two spreadsheets, and you can either "Paste" or "Paste Special". 2) Start gnumeric twice from the command line (with &). Now you can only "Paste" cells between the spreadsheets. This makes it impossible to strip out cell formatting at the time you paste. I often copy brightly colored cells over, and want the functionality of "paste as text" available at all times.
When copying cells from Excel (yes, I know I shouldn't do that :) ) if in Excel they were formulas, I can't simply paste the values because Paste Special is not available...
Pedro, re comment #5: Excel provides the formulas. There is no way for us to paste the values since we don't have them.
Andreas, sorry for the late reply. I think this proves that Gnumeric does not use the Windows clipboard properly and therefore it is isolating itself... This is not a good approach if you ever want more users to get to know Gnumeric...
Pedro, what do you mean with "Gnumeric does not use the Windows clipboard properly"? Are you telling me that Excel is providing the values? Can you point us to any documentation with that regard?
I can't help you with documentation... I'm just a marine biologist... But Excel is providing the value. If I copy a formula which is displaying a value in Excel and paste it in any other Windows application, including plain notepad, it will paste the value. If I paste it on another Excel cell, it will paste the formula.
*** Bug 388522 has been marked as a duplicate of this bug. ***
*** Bug 604983 has been marked as a duplicate of this bug. ***
This is not a mere enhancement request as described above: with 'Paste sepcial" one can remove the formatting if within Gnumeric. I think it is a shortcoming within Gnumeric if this can be done with paste from within and not when pasting form outside.
*** Bug 346631 has been marked as a duplicate of this bug. ***
*** Bug 691928 has been marked as a duplicate of this bug. ***
Well, that took a while, :-/ This problem has been fixed in our software repository. The fix will go into the next software release. Once that release is available, you may want to check for a software upgrade provided by your Linux distribution.
(In reply to Morten Welinder from comment #15) > Well, that took a while, :-/ > > This problem has been fixed in our software repository. The fix will go into > the next software release. Once that release is available, you may want to > check for a software upgrade provided by your Linux distribution. Actually this was reported under the Windows OS but since Gnumeric no longer produces Windows binaries, there is no way to test if it is fixed :) Thank you anyway. Hopefully someday Gnumeric can be ported again to Windows...
@Pedro: you can install gnumeric on Windows 10 using WSL and vcXsvr. I tested it a few days and seem to work well, except a problem with rounding which has been fixed recently (bug 794515).
(In reply to Frédéric Parrenin from comment #17) > @Pedro: you can install gnumeric on Windows 10 using WSL and vcXsvr. I > tested it a few days and seem to work well, except a problem with rounding > which has been fixed recently (bug 794515). @Frédéric: That is good to know (might be useful sometime). But luckily I'm still running Windows 7 x64 :) Thank you anyway!