I can’t find a feature similar to Microsoft Excel “Paste Special > Value” in LibreOffice. Excel has “Paste Special > Value”, which copies the current value of the cell to the target cell.
Hi
In case you want to convert formula cells into static values : menu Tools ▸ Cell Contents ▸ Formula to Value.
Previously, you would need to cut the cells and paste them back into place to have the same outcome.
Regards
Right Clicking on your target cell will give several options. PASTE ONLY allows you to select TEXT, NUMBER, or FORMULA. PASTE SPECIAL gives you those and more options (keep source formatting, or not; transpose, etc)
The options Paste only (right-click menu) and Paste special are greyed out when there is nothing in the clipboard. Note that this is the case after you paste the clipboard content to another location, so you may need to copy the original content again.