Ask Your Question

why display formula instead of result?

asked 2018-01-18 23:53:10 +0200

brianforeverflowers gravatar image

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.

edit retag flag offensive close merge delete


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.

Jim K gravatar imageJim K ( 2018-01-19 00:07:18 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-02-01 22:29:50 +0200

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-01-18 23:53:10 +0200

Seen: 2,413 times

Last updated: Feb 01 '18