[Solved] Column formula update
[Solved] Column formula update
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]
Reason: Tagged ✓ [Solved]
openoffice version 4.1.10 Windows 10
Re: Column formula update
Tools > Options> Calc > General > "Expand references ..." = ON
See also viewtopic.php?f=9&t=99846&p=480614#p480614
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Column formula update
Thank you, that worked, Now the question is how did it get turned off????
openoffice version 4.1.10 Windows 10