In calc, converting reference to data

how do I convert a cell reference so that the (current) value remains as normal cell data that does not depend on the previously referenced cell?


Copy ctrl+c the cell in question, and paste special ctrl+shift+v without Options []all and []formula

Cool - works for me - does do multiple cells as well!


Select the cell then:

  • Before 5.1 Toolsâ–¸Cell Contentsâ–¸Formula to Value
  • Since 5.1 Dataâ–¸Calculateâ–¸Formula to Value


1 Like

I am running
Toolsâ–¸Cell Contentsâ–¸Formula to Value is not present.


Sorry this was introduced with version 4.4.

New versions do not bring that new features and bug fixes. They also include security patches… but you’re maybe not the choice of the version.


Great! Thanks pierre-yves samyn !

This can also be achieved with: F2 (enter Edit Mode) > F9 (Calculate) > Enter (confirms the calculation).