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.