Originally Posted by
Vaphell
you could also use =formula(cell) to produce cells with text representations of formulas (formula() returns a text string). Copy pasting these values would give you what you want at the expense of additional temporary cells.
Thank you, I was not aware of the "formula()" function. I was able to get the desired result by incorporating it into a more complicated expression (although I suspect there may be overlooked exceptions):
Code:
=IF(A1="","",IF(ISERROR(FORMULA(A1)),A1,FORMULA(A1)))
As it turns out, I found out how formulae can be copied within calc, and I suspect the current behaviour is actually a bug. Setting "Tools" > "Options" > "LibreOffice Calc" > "View" and checking the "Formulas" checkbox causes Calc to display formulae by default, and copying copies formulae (which is what I want).
As is the case when the checkbox is unselected, it is possible to toggle the view mode (values vs. formulae) using the "View" > "Show Formula" menu, but again this has no effect on what is copied, in this case copying the formula regardless of what is showing and now it becomes impossible to paste values into external programmes (equally annoying).
My suspicion is that the expected behaviour is that toggling the menu should also toggle what is copied to the clipboard, the same way that Excel does it.
Anyway, thanks to you both for your input.
Bookmarks