Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenSun, 12 Jan 2014 00:14:10 +0100How to use an absolute reference when extending a formula sequence?https://ask.libreoffice.org/en/question/28264/how-to-use-an-absolute-reference-when-extending-a-formula-sequence/Say I want to have a sequence of formulae H6-A1, H7-A1, H8-A1...
How can I keep LibreOffice from increasing the row part of the second variable?
Because what I end up now when I drag the small square of the selection is H6-A1, H7-A2, H8-A3...Sat, 11 Jan 2014 23:51:39 +0100https://ask.libreoffice.org/en/question/28264/how-to-use-an-absolute-reference-when-extending-a-formula-sequence/Answer by m.a.riosv for <p>Say I want to have a sequence of formulae H6-A1, H7-A1, H8-A1...</p>
<p>How can I keep LibreOffice from increasing the row part of the second variable?</p>
<p>Because what I end up now when I drag the small square of the selection is H6-A1, H7-A2, H8-A3...</p>
https://ask.libreoffice.org/en/question/28264/how-to-use-an-absolute-reference-when-extending-a-formula-sequence/?answer=28265#post-id-28265You only need to put a $ to convert this part of the address in absolute, keeping their value when copying or drag.
=H6-A$1
Please take a look in the help or in documentation to learn more about absolute/relative addresses.
https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide
Chapter 7 Formulas and Functions.Sun, 12 Jan 2014 00:14:10 +0100https://ask.libreoffice.org/en/question/28264/how-to-use-an-absolute-reference-when-extending-a-formula-sequence/?answer=28265#post-id-28265