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

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 sates:
"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).

Brian Barker 


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