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

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" 
<b.m.barker@btinternet.com>To:users@global.libreoffice.orgCc:"Chris Green" <cl@isbd.net>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: 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