We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

What is wrong with the =SUM() function in Calc? [closed]

asked 2016-02-15 00:00:24 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

To whom this may concern:

I am an Ubuntu Linux user, and my default office suite is LibreOffice. I ran into a strange issue with 4.2.8 of LibreOffice, where the =SUM() function would not work. I would either receive the ### error or I would see something like =SUM(A1:B1) in the cell I was attempting to calculate in. I found that LibreOffice had recently updated, so I removed 4.2.8 from my computer, and installed 5.0.X. I am still experiencing the same problem with the newer version. Can someone please help me resolve this issue? I like to use Calc when I am calculating the cost of projects, and the =SUM() function not working is an issue because it will not add up my totals. Thank you.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-29 23:47:48.596124

1 Answer

Sort by » oldest newest most voted

answered 2016-02-15 14:03:58 +0200

Edward gravatar image

The ### may simply be the column is not wide enough to display the result. Seeing the underlying formula in the formula bar is normal (the cell should show the ANSWER to the formula displayed in the formula bar). If the cell is displaying the formula instead of the result you may have your options (in Windows OPTIONS/LIBREOFFICE_CALC/VIEW, probably the same or very similar in Ubuntu) set to display formulas.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-02-15 00:00:24 +0200

Seen: 2,987 times

Last updated: Feb 15 '16