Re: [libreoffice-users] How to get column total in last row in calc?

On 2026-03-31 11:51, Brian Barker wrote:
> At 15:20 31/03/2026 +0200, Philip Jackson wrote:
> > I thought I'd been doing that over the years so I must checked in Options, and I don't have that 
> > box checked. I just re-checked to confirm in LO 26.2.0.3 in Windows 11, and inserting both columns 
> > and rows works fine without having that checkbox ticked in Options.
>
> This works without the option ticked if the insertion is *within* the existing range, but requires 
> the option to be ticked if the extra row is added to the end of the range - as specified in the 
> original query.
>
> As the manual states:
> "Expand references when new columns/rows are inserted
> Specifies whether to expand references when inserting columns or rows *adjacent to* the reference range. 
> [...] If you insert rows or columns in the middle of a reference area, the reference is always 
> expanded." (my emphasis).
And your earlier formula [=SUM(INDIRECT("B1:B"&ROW()-1))], being independent of option states, is 
the most compact solution *needing no assumptions* (about options or insertion point) to sum the column from B1 
to the cell before the sum.

Nice summary of those issues.

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy