Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 29 Jan 2018 19:24:27 +0100calc find & replace for formulashttps://ask.libreoffice.org/en/question/144401/calc-find-replace-for-formulas/ I have a spreadsheet with a lot of rows. After being created, I have found that I need to change the formulas in all the cells. For example, I have a formula as follows: =F37*$D$2
What I need to do is change this to the following: =round(F37*$D$2,2)
Is there a way I can do this with find & replace?????
Thanks,
Rich Ramik
Mon, 29 Jan 2018 19:08:53 +0100https://ask.libreoffice.org/en/question/144401/calc-find-replace-for-formulas/Answer by JohnSUN for <p>I have a spreadsheet with a lot of rows. After being created, I have found that I need to change the formulas in all the cells. For example, I have a formula as follows: =F37*$D$2</p>
<p>What I need to do is change this to the following: =round(F37*$D$2,2)</p>
<p>Is there a way I can do this with find & replace?????</p>
<p>Thanks,
Rich Ramik</p>
https://ask.libreoffice.org/en/question/144401/calc-find-replace-for-formulas/?answer=144404#post-id-144404It seems to me, Rich, that you're looking for something like this
![Change Formula](/upfiles/15172501236359271.png)
Here the first asterisk means "any digits" and the second (with a backslash) - the multiplication signMon, 29 Jan 2018 19:24:27 +0100https://ask.libreoffice.org/en/question/144401/calc-find-replace-for-formulas/?answer=144404#post-id-144404