Calc: Converting Formula to Value

users
#21

Or, you can open it (an .ods) in Microsoft Office 2007/2010, and save it back.
That will leave the values and strip the formulas from the cells [;<). It
might work to save as .xslx and then reopen it in LO too, but I haven't tried
that case.

#22

That was actually more of a restatement of your problem then an attempt at a
solution. But the previous supplied answer of "Paste Special" with only
"Numbers" checked did work. If you do that you can delete B5 and C5 and keep
the 80.

if you're still having trouble perhaps a screenshot would help assuming this
isn't confidential work?

#23

Hi :slight_smile:
Ooops. Yep i made a few mistakes there. Using x as multiplication confuses some people and * confuses others so i went back to make it a simple addition but really was not concentrating at all lol. Hopefully it gets the point across tho.
Many apols for the blunders and regards from
Tom :slight_smile:

#24

Hi :slight_smile:
I wish i had used Nabble to look at this thread. All my answers were a
complete load of nonsense because i was responding to emails in my inbox
that were each of a different time-line (err plus making the !"new maths"
blunder). In Nabble i was able to put a star beside Stefan's answer

http://nabble.documentfoundation.org/Calc-Converting-Formula-to-Value-td3462339.html#a3463099

and Uwe's and a couple of other people to try to steer people to the good
answers in this thread if they are hunting through the archives.
Regards from
Tom :slight_smile:

#25

Rich Shepard wrote:

I have a column where the cells display the sum of two other columns. I
want to change the contents from formula to value but cannot find the
relevant information in the help pages. Please point me to instructions on
how to do this.

Select the relevant cell and click in the formula bar. Press F9 (the
default short-cut for recalculate) followed by ENTER. This should
replace the formula with the result.

Regards
Stephan

#26

Hi,

Rich Shepard wrote:

I have a column where the cells display the sum of two other columns. I
want to change the contents from formula to value but cannot find the
relevant information in the help pages. Please point me to instructions on
how to do this.

Select the relevant cell and click in the formula bar. Press F9 (the
default short-cut for recalculate) followed by ENTER. This should
replace the formula with the result.

This will work for a single cell, but will take you very long for a
whole column. :wink:

Stefan

#27

Stefan Weigel wrote:

Select the relevant cell and click in the formula bar.  Press F9 (the
default short-cut for recalculate) followed by ENTER.  This should
replace the formula with the result.

This will work for a single cell, but will take you very long for a
whole column. :wink:

Good point. Using Paste Special method would work better in that
case. As a side note, I think the Paste Special method is more
intuitive (in general); I just wanted to mention an alternative.

Regards
Stephan

#28

which I find generally interesting, because I didn´t think of the
way you mentioned, at all. And for a single cell your alternative is
faster, I think.

Stefan
:slight_smile:

#29

Stephan Zietsman <sziets <at> gmail.com> writes:

Stefan Weigel wrote:
>> Select the relevant cell and click in the formula bar.  Press F9 (the
>> default short-cut for recalculate) followed by ENTER.  This should
>> replace the formula with the result.
>
> This will work for a single cell, but will take you very long for a
> whole column.

Good point. Using Paste Special method would work better in that
case. As a side note, I think the Paste Special method is more
intuitive (in general); I just wanted to mention an alternative.

Regards
Stephan

Doing the following sure makes me miss Lotus 1-2-3. I wanted to change a
simple addition formula that summed the quantities in two cells into their
summed value. I right-clicked the cell and hit Ctrl C. Then again I right
clicked the (same) cell and rolled down to "Paste special" and left-clicked
it. The formula was changed into its value. In the 1-2-3 days one picked the
cell or cells, hit the slash key and then the keys r and v in that sequence
and one had the values instead of the formulas. Trackballing and mousing are
slower than the second coming.

#30

Don Braun wrote:

Doing the following sure makes me miss Lotus 1-2-3. I wanted to change a
simple addition formula that summed the quantities in two cells into their
summed value. I right-clicked the cell and hit Ctrl C. Then again I right
clicked the (same) cell and rolled down to "Paste special" and left-clicked
it. The formula was changed into its value. In the 1-2-3 days one picked the
cell or cells, hit the slash key and then the keys r and v in that sequence
and one had the values instead of the formulas. Trackballing and mousing are
slower than the second coming.

Everything on the menus can be accessed by the keyboard, either by navigating the menus using Alt + the underlined characters (e.g. Alt+E for the Edit menu, then S for Paste Special) or more direct shortcuts (e.g. Ctrl+Shift+V, as shown on the menu next to Paste Special).

Once in the Paste Special dialog, you can use Alt + the underlined characters to select / deselect options. So Alt+P deselects "Paste all", then Alt+N select "Numbers" and Alt+F deselects "Formulae".

From what I recall, this is similar to navigating the menus in the text-based versions of 1-2-3 - Alt is equivalent to "/" to access the menu, then single-letter options to select menus and items. Having done that, in LibreOffice you get a dialog with a more options so granted it's not quite as quick, but that's the downside of having more flexibility.

The shortcut keys can be configured to suit your preferences at Tools > Customise > Keyboard.

Mark.