Bug Hunting Session
Bug 50172 - Request for "Convert to values..." function
Summary: Request for "Convert to values..." function
Status: NEW
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: 2017-06-16 09:43 UTC (History)
2 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!