Is there any " Evaluate Formula " in LibreOffice Calc like Excel have the Option in Formula Auditing?

[sv.thiyagarajan]

Is there any " Evaluate Formula " in LibreOffice Calc like Excel have the Option in Formula Auditing ?

[JohnSUN]

Are you asking about this? - Libreoffice Calc show values instead of reference(eg. D12) - #2 by JohnSUN

@JohnSUN

Select part of formula and press F9

After that press Esc to exit or Enter to replace the selected fragment with its value

Yes, it does not seem obvious, but Calc will recalculate any meaningful selection, any part of the formula and show the result of the calculation in a tooltip (or show the #NAME? error if the highlighted part of the formula cannot be calculated)

It seems to me that this is a little more convenient than clicking “Step In/Out” many times to get the result of some of the intermediate calculations.

[Villeroy]

menu:Insert>Formula… [Ctrl+F2] starts the formula wizard where you can select some function call and get its result in the upper right corner.

[sv.thiyagarajan]

Thanks, Villeroy and JohnSUN … both reply gives me as Solution. But,it is possible only one select as Solution…