Alright, I’ve had this problem in the past and I can never remember how I fix it.
I’ve been using the same spreadsheet for years (it’s a read only, I enter my numbers and then save it as another file so I can use the blank one again the next day). From time to time I have to make a small adjustment to a formula here or there or add a cell with a formula in it for one reason or another.
Today, I needed to add a few cells, so I go into my file, make the changes I want, add the cells I need, enter the formulas and one cell won’t work with the formula. The formula is “=VALUE(C28)” and that’s what’s displaying in the cell. I know Calc knows it’s a formula because when I click on it, it’ll highlight Cell C28 to show that it’s pointing to it, but it won’t put the value of C28 in the cell and it won’t not display the formula. I’ve tried everything, anyone else have any ideas?