With "LibreOffice 18.104.22.168” German UI/ German Locale [Build-ID: f8fce0b] on German WIN7 Home Premium (64bit) I currently observe very often that when I copy a single cell with a simple formula contents like "=E15*$G$13" only the result of the calculation as plain text will be pasted, and 'Paste Special' is not available.
Unfortunately I currently do not know how to make that reproducible, sometimes it works, sometimes it does not work. I will do further research.
Anybody who can confirm that problem (and may be has a solution how to make that reproducible?
Rainer - trying to reproduce: can you expand ? Are you copy/pasting on the same sheet ? are you using keystrokes to do that ? does it depend if you paste the formula above and to the left of the original cell vs. below and right ? How would you trigger Paste Special ? ctrl-shift-v or somesuch ? [ and it just pastes, rather than showing the dialog ? ].
Thanks ! :-)
This single user problem seems not to be a MAB.
Unfortunately I can't narrow down the problem. I see that for copying from any source (Same sheet, other Spreadsheet document, Web page table, Web page formatted text with hyperlink, anything else), in any way (control+v, context menu, mouse button). The symptom I see afterwards is that only "Unformatted Text" is available at paste icon in standard toolbar, so the (LibO?-) clipboard contents only is plain text. I never saw such a problem in Writer, but I think I copy 100 times more to Calc than to Writer.
I even can't be sure that it really is a LibO problem, because I do not copy so much with other software, so may be the problem also exists for other programs, but only appears 1x in a year?
Sometimes it happens several times a day, or if I am lucky I have a week without that problem.
So I still am hoping for a "brainwave".
I wonder whether this problem might be related to running TightVNC Viewer
I have lots of documents damaged by this bug with lots of missing formulas in cells, but since several weeks I have not been able to reproduce this problem. so WFM for now.