Ask Your Question

sum will not show value result [closed]

asked 2013-08-08 23:17:54 +0200

CraigM gravatar image

I am trying to add a column of figures. I use the Sum function and the function appears in the cell box at the top but nothing appears in the cell on the spreadsheet. Tools|Options|LibreOffice Calc|View has formulas unchecked. If I check it I get the formula but if I uncheck it I get nothing, makes no sense. Any help appreciated.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by manj_k
close date 2013-09-18 21:58:24.389821


Please check that the content of the cells are not as text (right-click and "format cells")

carnendil gravatar imagecarnendil ( 2013-08-08 23:32:57 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-08-08 23:41:17 +0200

CraigM gravatar image

Problem resolved. I found after I closed the spreadsheet and reopened it the values appeared. May have been that the tools options settings did not apply themselves to the spreadsheet until after it had been shut down.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-08-08 23:17:54 +0200

Seen: 3,329 times

Last updated: Aug 08 '13