Bug 50172 - Request for "Convert to values..." function
Summary: Request for "Convert to values..." function
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
Reported: 2012-05-21 06:55 UTC by wvvelzen
Modified: 2020-01-20 12:19 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description wvvelzen 2012-05-21 06:55:31 UTC
WordPerfect's QuatroPro has a "Convert to values..." function, which I often use, and am missing in LibreOffice's Calc.

It is described in QP's help as follows:

To convert a formula to a value

1.   Select a cell containing a formula.
2.   Click Edit  Convert to values.
3.   Type the destination cells in the To box.

   To replace a formula in a cell with its value, specify the same cells in the To box as are in the From box.
   To copy the value of a formula to another part of the notebook, specify the top-left cell to which you want to copy the value.
Comment 1 Joel Madero 2012-06-17 21:06:42 UTC
Can't you just use paste -> Special and do Values? Please expand a bit if this isn't the case, marking as NEEDINFO
Comment 2 wvvelzen 2012-06-17 23:56:44 UTC
Yes, that would work, I didn't know about that (and believe me I did search for such a function), so thanks! ;)

Although there are some inconveniences with this alternative:

- You have to click a bit more then the single "convert to values" function to get what you want.
- Paste special doesn't have a single "values" check mark. So you have to specifically select the right combination of "text", "numbers", "date & time", and "formats", to get what you want.
Comment 3 wvvelzen 2013-09-11 10:02:59 UTC
LibreOffice 4(.1) doesn't seem to have a "Values" option in the "Paste Special" function. So I do think this enhancement request is now even more valid!
Comment 4 s5t1e3v4e3m11@hotmail.com 2020-01-01 16:18:55 UTC
Calc (on Linux) does have a "Values" option, it is the "$0" button on the top left of the paste special dialog.
So this request can be closed as resolved?
Comment 5 wvvelzen 2020-01-07 13:11:34 UTC
In the windows version of Calc I see the function:

Data / Calculate / Formula to value

Which does exactly what I want/suggested. I'm still on an older linux version (5.2.5), which I can't check right now.

But I suppose the linux version has the same functionality as the windows version, so if that is the case this "bug" can be closed.
Comment 6 wvvelzen 2020-01-09 08:04:24 UTC
I verified the "Data / Calculate / Formula to value" option is also in my linux version So I set the status to "RESOLVED/FIXED".
Comment 7 Xisco Faulí 2020-01-20 12:19:06 UTC
(In reply to wvvelzen from comment #6)
> I verified the "Data / Calculate / Formula to value" option is also in my
> linux version So I set the status to "RESOLVED/FIXED".

Thanks for retesting the issue with the latest version.
Setting to RESOLVED WORKSFORME since the commit fixing this issue hasn't been