Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 29 Oct 2017 18:35:19 +0100How do I copy than paste a formula to multiple cells without the formula changing.https://ask.libreoffice.org/en/question/136417/how-do-i-copy-than-paste-a-formula-to-multiple-cells-without-the-formula-changing/ If I try to copy and paste a formula, the formula changes to match the next row. How do I paste the same simple formula into many cells with out it changing.
example: =IFS(B109=0,Q2,B109=1,Q3,B109=2,Q4,B109=3,R2,B109=4,R3,B109=5,R4)
Each result (i.e. Q2, Q3 Q4 etc.) has a different text that gets placed into the cell depending on the number typed into B109 or B110 or B111 etc.
And, by the way, if I every make it through the tags and the reCaptcha, I will probable never use this site again. It is a waste of time trying to get verified that I am not something from outer space. The thing keeps coming up in a different langue. And the requirements for tags is ridiculous. it is never satisfied. Sun, 29 Oct 2017 17:10:06 +0100https://ask.libreoffice.org/en/question/136417/how-do-i-copy-than-paste-a-formula-to-multiple-cells-without-the-formula-changing/Answer by pierre-yves samyn for <p>If I try to copy and paste a formula, the formula changes to match the next row. How do I paste the same simple formula into many cells with out it changing. </p>
<p>example: =IFS(B109=0,Q2,B109=1,Q3,B109=2,Q4,B109=3,R2,B109=4,R3,B109=5,R4)</p>
<p>Each result (i.e. Q2, Q3 Q4 etc.) has a different text that gets placed into the cell depending on the number typed into B109 or B110 or B111 etc. </p>
<p>And, by the way, if I every make it through the tags and the reCaptcha, I will probable never use this site again. It is a waste of time trying to get verified that I am not something from outer space. The thing keeps coming up in a different langue. And the requirements for tags is ridiculous. it is never satisfied. </p>
https://ask.libreoffice.org/en/question/136417/how-do-i-copy-than-paste-a-formula-to-multiple-cells-without-the-formula-changing/?answer=136431#post-id-136431Hi
If the question is not about absolute addressing here is how I proceed in this case:
`Click` in the formula bar, `Ctrl+A`, `Ctrl+C`, `Esc`
That's it just paste, the formula is not changed...
RegardsSun, 29 Oct 2017 18:35:19 +0100https://ask.libreoffice.org/en/question/136417/how-do-i-copy-than-paste-a-formula-to-multiple-cells-without-the-formula-changing/?answer=136431#post-id-136431Answer by m.a.riosv for <p>If I try to copy and paste a formula, the formula changes to match the next row. How do I paste the same simple formula into many cells with out it changing. </p>
<p>example: =IFS(B109=0,Q2,B109=1,Q3,B109=2,Q4,B109=3,R2,B109=4,R3,B109=5,R4)</p>
<p>Each result (i.e. Q2, Q3 Q4 etc.) has a different text that gets placed into the cell depending on the number typed into B109 or B110 or B111 etc. </p>
<p>And, by the way, if I every make it through the tags and the reCaptcha, I will probable never use this site again. It is a waste of time trying to get verified that I am not something from outer space. The thing keeps coming up in a different langue. And the requirements for tags is ridiculous. it is never satisfied. </p>
https://ask.libreoffice.org/en/question/136417/how-do-i-copy-than-paste-a-formula-to-multiple-cells-without-the-formula-changing/?answer=136423#post-id-136423In the help it's explained how to do it.
[Addresses and References, Absolute and Relative](https://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative)Sun, 29 Oct 2017 17:48:26 +0100https://ask.libreoffice.org/en/question/136417/how-do-i-copy-than-paste-a-formula-to-multiple-cells-without-the-formula-changing/?answer=136423#post-id-136423