Formula fields do not show results

Discuss the spreadsheet application

Formula fields do not show results

Postby ocobri » Tue Oct 11, 2016 4:20 pm

How can I make formula results appear in the cell instead of the formula itself? I have tried googling, but the answers I have found do not correspond to the menu options I have in version 4.1.2.
OpenOffice 4.1.2 on MacOS
ocobri
 
Posts: 3
Joined: Tue Oct 11, 2016 4:18 pm

Re: Formula fields do not show results

Postby acknak » Tue Oct 11, 2016 4:38 pm

Greetings and welcome to the community forum!

Tools > Options ... does not exist on OO/Mac. Options are instead located on the desktop menu. OO/Mac Preferences
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Zero values, displaying

Postby ocobri » Tue Oct 11, 2016 4:53 pm

In Preferences > OpenOffice Calc > View, I checked and unchecked "Display Formula" but nothing changed in the highlighted cells, or anywhere.
OpenOffice 4.1.2 on MacOS
ocobri
 
Posts: 3
Joined: Tue Oct 11, 2016 4:18 pm

Re: Formula fields do not show results

Postby acknak » Tue Oct 11, 2016 5:12 pm

Did the formulas ever work?

Check the cell format: Format > Cells > Numbers ... Is the format category set to text?
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Formula fields do not show results

Postby ocobri » Tue Oct 11, 2016 5:13 pm

It is a Concatenate formula with text results, so I have tried Text but also Numbers. I have never seen the formula work.
OpenOffice 4.1.2 on MacOS
ocobri
 
Posts: 3
Joined: Tue Oct 11, 2016 4:18 pm

Re: Formula fields do not show results

Postby RoryOF » Tue Oct 11, 2016 5:16 pm

The quickest solution will come if you upload a small sample file.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31115
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Formula fields do not show results

Postby acknak » Tue Oct 11, 2016 5:18 pm

Changing the cell format does NOT change what's stored in the cell.

However, the format can change how Calc interprets what you enter. If the cell format was set to text when the formula was entered, the entry will be taken as text instead of a working formula. Once the formula is stored as text, Calc will not change it if you later change the cell format.

Set the cell format to Number > General (the default format) THEN edit the formula (add a space at the end and delete it). When you finish editing and press Enter, Calc will now re-interpret the entry and it should take it as a working formula.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3


Return to Calc

Who is online

Users browsing this forum: No registered users and 7 guests