Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 19 Feb 2017 19:04:49 +0100complex automatic fillhttps://ask.libreoffice.org/en/question/88096/complex-automatic-fill/I have a problem with the automatic fill function when I use complex formulas: I would like to have some of the parameters automatically filled but leave alone some fixed parameters.
For example:
In the column A I have the series 1,2,3,4 in the cells A1,A2,A3,A4
In the cell B1 I have the value of 10
I would like to sum the values of the series in the column A with the cell B1
However, if I use the formula =A1+B1 say in cell C1 and I attempt an automatic fill I have the series A1+B1, A2+B2, A3+B3, A4+B4 and not my desired result (that would be, of course, A1+B1, A2+B1, A3+B1, A4+B1).
Is there a way to have the formulas filled automatically but leaving alone some of the parameters?Sun, 19 Feb 2017 18:26:53 +0100https://ask.libreoffice.org/en/question/88096/complex-automatic-fill/Answer by Lupp for <p>I have a problem with the automatic fill function when I use complex formulas: I would like to have some of the parameters automatically filled but leave alone some fixed parameters.</p>
<p>For example:
In the column A I have the series 1,2,3,4 in the cells A1,A2,A3,A4
In the cell B1 I have the value of 10
I would like to sum the values of the series in the column A with the cell B1</p>
<p>However, if I use the formula =A1+B1 say in cell C1 and I attempt an automatic fill I have the series A1+B1, A2+B2, A3+B3, A4+B4 and not my desired result (that would be, of course, A1+B1, A2+B1, A3+B1, A4+B1).</p>
<p>Is there a way to have the formulas filled automatically but leaving alone some of the parameters?</p>
https://ask.libreoffice.org/en/question/88096/complex-automatic-fill/?answer=88098#post-id-88098 =A1+B$1 It's absolute vs. relative addressing.
Sun, 19 Feb 2017 18:30:26 +0100https://ask.libreoffice.org/en/question/88096/complex-automatic-fill/?answer=88098#post-id-88098Answer by fabio61 for <p>I have a problem with the automatic fill function when I use complex formulas: I would like to have some of the parameters automatically filled but leave alone some fixed parameters.</p>
<p>For example:
In the column A I have the series 1,2,3,4 in the cells A1,A2,A3,A4
In the cell B1 I have the value of 10
I would like to sum the values of the series in the column A with the cell B1</p>
<p>However, if I use the formula =A1+B1 say in cell C1 and I attempt an automatic fill I have the series A1+B1, A2+B2, A3+B3, A4+B4 and not my desired result (that would be, of course, A1+B1, A2+B1, A3+B1, A4+B1).</p>
<p>Is there a way to have the formulas filled automatically but leaving alone some of the parameters?</p>
https://ask.libreoffice.org/en/question/88096/complex-automatic-fill/?answer=88101#post-id-88101Great! Thanks a lotSun, 19 Feb 2017 18:47:58 +0100https://ask.libreoffice.org/en/question/88096/complex-automatic-fill/?answer=88101#post-id-88101Comment by m.a.riosv for <p>Great! Thanks a lot</p>
https://ask.libreoffice.org/en/question/88096/complex-automatic-fill/?comment=88103#post-id-88103If the answer solves your question please tick the ✔.Sun, 19 Feb 2017 19:04:49 +0100https://ask.libreoffice.org/en/question/88096/complex-automatic-fill/?comment=88103#post-id-88103