Ask Your Question
1

How to use an absolute reference when extending a formula sequence? [closed]

asked 2014-01-11 23:51:39 +0200

Alexander Wilms gravatar image

updated 2014-02-19 06:10:00 +0200

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...

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 11:14:44.997317

1 Answer

Sort by » oldest newest most voted
2

answered 2014-01-12 00:14:10 +0200

m.a.riosv gravatar image

You 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.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-01-11 23:51:39 +0200

Seen: 105 times

Last updated: Feb 19 '14