spreadsheet sometimes shows formula =sum(k17:k34) instead of showing the result of adding the contents of that range of cells.
Other times, it displays all zeroes as a result of a similar formula.
For the first question, View → Show Formula. For the second, more details are needed. What values are summed, and what is the cell number format (Format → Cells)? For example, if A1 contains a and B1 contains ="1", then =SUM(A1:A2) results in 0 because strings have zero numeric value.
Both are options to do or not to do. Show formula is Alt-View-Show Formula. To show zero or not is Tools-Options-LibreOffice Cacl-View- then boxes under display. I believe it is to help one build by showing more so, than when it is built, and not needing to know once built. Helps in where formulas are at, what cells to lock.
thanks mark. we can also press ctrl + ` shortcut to toggle it.