Ask Your Question

I cannot get a formula to work in LibreOffice Calc

asked 2016-07-30 21:28:54 +0200

snurd1 gravatar image

It is simply the sum of a column, but it just displays the formula and does not calculate. I am using Ubuntu 16.04 on a Dell Inspiron 1545. This is a spreadsheet that I derived from a downloaded CSV that was comma delimited. I removed those fields that were the title and description of the spreadsheet, leaving only columns. The column I'm trying to add is "currency" data type.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2016-07-30 21:45:49 +0200

Lupp gravatar image

updated 2016-07-30 21:49:12 +0200

If a formula is displayed in a cell there can be two reasons:
1. The formula is actually text and did not run through formula recognition.
2. The option to display thze formulas instead of their results is chose. Look for the setting
under > 'Tools' > 'Options' > 'LibreOffice Calc' > 'View' > 'Formulae'. This option must not be selected if you want to see results.

Concerning 1. : Make sure that the respective cells are not set to the fake 'Numbers' format 'Text' (code @).

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2016-07-30 21:28:54 +0200

Seen: 275 times

Last updated: Jul 30 '16