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. Philip Sent:Tuesday, March 31, 2026 at 2:18 PMFrom:"Brian Barker" <[email protected]>To:[email protected]:"Chris Green" <[email protected]>Subject:Re: [libreoffice-users] How to get column total in last row in calc? At 12:34 31/03/2026 +0200, Luis Iglesias wrote:>Assuming the initial case, where you have 10 rows of data, whether>you insert a whole row or insert a cell by selecting the option to>shift cells down, the formula will automatically change to>SUM(B1:B11) or whatever.Note that for this to be true there needs to be a tick at Tools |Options | LibreOffice Calc | General | Expand references when newcolumns/rows are inserted. -- To unsubscribe e-mail to: [email protected] 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
