[Solved] Column formula update

Discuss the spreadsheet application
Post Reply
msaine
Posts: 2
Joined: Wed Jun 16, 2021 4:06 pm

[Solved] Column formula update

Post by msaine »

I have a file for tracking lottery numbers and in May it quit updating the column formula for summing the hits. For example the formula is =SUM(C2:FG2). Up until a late May entry every time I inserted a column before "C" column it updated the formula just fine. Now it no longer updates when I insert a column. Is there some setting That I may have inadvertently unset? I have two of these types of files and this is only happening on one.
Last edited by MrProgrammer on Thu Jun 17, 2021 7:12 pm, edited 2 times in total.
Reason: Tagged ✓ [Solved]
openoffice version 4.1.10 Windows 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Column formula update

Post by Villeroy »

Tools > Options> Calc > General > "Expand references ..." = ON

See also viewtopic.php?f=9&t=99846&p=480614#p480614
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
msaine
Posts: 2
Joined: Wed Jun 16, 2021 4:06 pm

Re: Column formula update

Post by msaine »

Thank you, that worked, Now the question is how did it get turned off????
openoffice version 4.1.10 Windows 10
Post Reply