Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Desktop
User Name
Linux - Desktop This forum is for the discussion of all Linux Software used in a desktop context.


  Search this Thread
Old 10-09-2006, 02:11 PM   #1
Registered: Jun 2004
Location: Sierra Vista, AZ
Distribution: SUSE 10.0 OSS
Posts: 143

Rep: Reputation: 15
OpenOffice Calc function displays instead of result

I've been doing some searching on this, as I figured it was probably a common thing, but I have been unable to find an answer. Granted, when it comes to trying to figure out good search terms for even the simplest of problems, my brain turns into raw sewage. So there might be an obvious way to search for this problem, only I'm too busy trying to process cow pooh.

So anyway, here's the problem. I'm using Calc to help come up with a fairly advanced series of worksheets to help me calculate student grades. Details of what the spreadsheet actually does are not important. What's happening is that, whenever I enter even the simplest of formulas, instead of getting the result of the formula or function, the actual formula or function is displayed. For example:

Say I want to run an IF to determine if the phrase "Current Score" or "Final Score" should be displayed. I type the following into the cell:

=IF(NOW()>=D8;"Final Score";"Current Score")

This normally should immediately display either phrase, depending on the current date as compared to the end date for the class. However, instead of the result of the function being displayed, the actual text of the function - to include the "=" - is displayed verbatim. No amount of backspacing over the function and retyping it changes the result. I've had to resort to completely deleting the row or column in which the function appears, then retyping the function order for the results to display properly. This, as you can imagine, has a serious impact on productivity.

This happens for every single function I type. It gets old really fast. There is no visible cause for this. I feel like there is a setting that accidentally got turned on (you can do this in Excel), but I haven't a clue what to look for.

I've posted this question on the OpenOffice forum, as well, but I wanted to maximize my chances for getting some help, soon. I need to solve this problem very quickly. Any help would be greatly appreciated.
Old 10-09-2006, 03:15 PM   #2
LQ Addict
Registered: Jul 2002
Location: East Centra Illinois, USA
Distribution: Debian stable
Posts: 5,898

Rep: Reputation: 353Reputation: 353Reputation: 353Reputation: 353
OO Calc - Tools - Options - OO Calc - View. On the right side of the screen, uncheck View Formulas.
Old 10-09-2006, 03:31 PM   #3
Registered: Jun 2004
Location: Sierra Vista, AZ
Distribution: SUSE 10.0 OSS
Posts: 143

Original Poster
Rep: Reputation: 15
Thanks, Bigrigdriver, I'll check that out. Though I'm not 100% certain that is the problem. I suppose I should have stated that some of the functions will display the results properly. But as soon as I go in and manually edit them, I get this problem.

So I have a hodgepodge of functions that display the proper results and others that don't all on the same worksheet.

Sorry that I left this bit of critical information out. Like I said, my brain is farm sewage.

Update: Well, that's not the problem. I looked up the area of the options section you spedified, and View Formulas is unchecked as it should be. There's something else going weird, here.

Last edited by SchadeBoy; 10-09-2006 at 08:19 PM.
Old 11-01-2006, 07:05 PM   #4
Registered: Aug 2004
Location: Belgium
Distribution: debian 5.02
Posts: 73

Rep: Reputation: 15
formula display


Got the same problem. If u set source and destination cells as numbers your problem should be solved. Use "cell properties" for this




Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
"substraction" and "division" function in OpenOffice Calc mac1234mac Linux - Software 7 12-03-2009 07:36 AM
logic in openoffice calc edgjerp Linux - Software 2 05-14-2006 09:13 AM
Openoffice calc dajomu Linux - Software 1 10-27-2005 06:56 PM
openoffice calc question buffed317 Linux - General 1 09-11-2004 04:27 PM
openoffice calc question... marsques Linux - Software 2 07-10-2004 05:30 PM > Forums > Linux Forums > Linux - Desktop

All times are GMT -5. The time now is 05:58 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration