Ask Your Question

In calc, converting reference to data

asked 2016-03-24 13:58:01 +0100

BOS gravatar image

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?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-03-24 17:08:57 +0100

karolus gravatar image


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

edit flag offensive delete link more


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

BOS gravatar imageBOS ( 2016-03-24 23:19:13 +0100 )edit

answered 2016-03-24 19:37:47 +0100

pierre-yves samyn gravatar image


Select the cell then:

  • Before 5.1 ToolsCell ContentsFormula to Value
  • Since 5.1 DataCalculateFormula to Value


edit flag offensive delete link more


I am running Tools▸Cell Contents▸Formula to Value is not present.

BOS gravatar imageBOS ( 2016-03-24 23:18:33 +0100 )edit


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.


pierre-yves samyn gravatar imagepierre-yves samyn ( 2016-03-25 14:28:31 +0100 )edit

Great! Thanks pierre-yves samyn !

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

Phoinx gravatar imagePhoinx ( 2019-11-01 21:12:10 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-03-24 13:58:01 +0100

Seen: 136 times

Last updated: Mar 24 '16