Ask Your Question

In calc, converting reference to data [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-02 12:14:29.039078

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

Question Tools

1 follower


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

Seen: 692 times

Last updated: Mar 24 '16