Ask Your Question
0

Calc will not show SUM values in cell, only formulas.

asked 2016-05-12 15:56:03 +0200

CW gravatar image

LO Calc 5.0.6.3, on a Windows 8.0 ASUS laptop. When using the SUM function and selecting the cells to add, the formula stays in the cell and will not display the value [shows =SUM(C5-C4) instead of 1.2]. Tools/Options/Libre Calc/ View/Display the Formulas check-box is unchecked. This was happening before I just updated to the 5.0.6.3 version of LibreOffice.

edit retag flag offensive close merge delete

Comments

Do all the other cells containing formulae display the results?
What is the 'Numbers' format code of a cell showing the issue?
(For what reason do you use the SUM function instead of simply =C5-C4 to just calculate the difference? )

Lupp gravatar imageLupp ( 2016-05-12 16:20:49 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2016-05-18 14:44:12 +0200

Edward gravatar image

Sounds like the cell containing the formula is formatted as text. Changing it to number after the formula is entered seemingly will not work as the data (the formula) is already text. Try changing the format to number and re-entering the formula

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-05-12 15:56:03 +0200

Seen: 742 times

Last updated: May 18 '16