How to use an absolute reference when extending a formula sequence? [closed]
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...