I cannot paste as value in spreadsheet

[WebstonesNL]

I have a cell with a formula. I want to copy it and paste it as value. So far as I can see there is no such option in de context menu or lint menu. Version is up-to-date: Community-version 9.0.4.50 (x64 exe).

A fix?

[Dmitry-Kov]

Hi @WebstonesNL, thanks for the report!

In ONLYOFFICE Spreadsheets you can paste a formula as values via the Paste options that appear after a normal paste. This works inside the editor (same workbook or another workbook window).

Steps

1. Copy the cell with the formula (Ctrl/Cmd + C).
2. In the destination cell, do a normal paste (Ctrl/Cmd + V).
3. A small Paste button appears (or press Ctrl to open it).
4. Choose “Paste only value (V)” (or use the keyboard hint shown in the menu).

Note: this command is not in the right-click context menu; it’s available from the Paste options popover and from the Paste dropdown on the toolbar.

If the menu still doesn’t show up, please tell us your OS and share a short screencast so we can check.