Ask Your Question
0

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
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

Question Tools

1 follower

Stats

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

Seen: 692 times

Last updated: Mar 24 '16