Formula cnot calculating in cells

English
#1

I’m making a very basic spreadsheet for a budget. I started entering some numbers to test out the formulas. I’m getting the formula showing up in green in the cells with ###, not the outcome of the formula.

At the bottom right corner of the sheet I’m seeing the correct formula calculation showing up though??

I found if I go to the menu of DATA>CALCULATE I have AUTO CALCULATE checked but it is not working. If I click on Formula to Value it then works. I have to do this for each individual cell with a formula. Example is =SUM(B4:M4)

How do I fix this??

I’m using version 7.6.4.1 on linux

Screenshot_20240101_172510
Screenshot_20240101_1725101920×1200 267 KB

#2

The ### means the cell is not wide enough to display the contents of the cell. You could change the formatting of the cells to remove the currency symbol, that will save one digit space. Then you could: widen the columns, reduce the font size or change back to Liberation serif which is somewhat narrower, not display the cents.

#3

Good; check also if it’s showing formulas (instead of values) in View menu.

#4

I did everything suggested and it’s working. Thanks

#5

Thanks that helped.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.