Was using a 7.3 version that stopped calculating values in columns, but would only show functions.
I would type =sum(and drag over the cells I want to add up, as I’ve always done) and I only see the function I typed and not the result. Calc wanted to show cells formatted for Text but setting them back to Number did not revert them back to Number. This seemed to happen spontaneously after an update to a 7.3 something version. I have rolled back to a 7.0 something version and everything is working as before.
Love this program and have had many years of good service. I’m stumped and may have to use another program if this bug or whatever isn’t addressed. No, I have not tried the very latest version.
I use Windows 7 Pro 64bit. Would appreciated any feedback! I’ve walked thru all the remedies with this same problem that goes back several years… Thanks so much!