Bug 50172

Summary:	Request for "Convert to values..." function
Product:	LibreOffice	Reporter:	wvvelzen
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WORKSFORME
Severity:	enhancement	CC:	jmadero.dev, s5t1e3v4e3m11, wvvelzen, xiscofauli
Priority:	medium
Version:	unspecified
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108253

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 6.3.4.2 (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 6.2.8.2 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 5.2.5.1. 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 5.2.5.1. 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
identified.