Ask Your Question
0

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
0

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

karolus gravatar image

Hallo

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

edit flag offensive delete link more

Comments

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

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

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

pierre-yves samyn gravatar image

Hi

Select the cell then:

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

Regards

edit flag offensive delete link more

Comments

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

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

Hi @BOS

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.

Regards

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

Stats

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

Seen: 132 times

Last updated: Mar 24 '16