Description: I type =IF(1,"Hello","oh no") into a cell and click the green check. The formula displays as if it were text. Steps to Reproduce: 1. Type =IF(1,"Hello","oh no") into a cell and press enter. 2. 3. Actual Results: The cell displays, =IF(1,"Hello","oh no") Expected Results: The cell displays Hello Reproducible: Always User Profile Reset: No Additional Info: I want Calc to treat formulas as such. This is a new behavior.
I'm guessing that the cell was formatted as text before introducing the formula. In that case, if we are talking about just a few cells, one way to solve the case would be: 1. Focus on the relevant cell. 2. [CTRL]+[1] > Numbers > Format as "General" (or use a toolbar) 3. [F2] 4. [Backspace] (it will delete the last closing parenthesis of the formula) 5. [ENTER] There are other methods too. Please confirm that this solves the issue for you. If it doesn't, please paste the Help > About info in your next reply and attach a sample file.
(In reply to ady from comment #1) > I'm guessing that the cell was formatted as text before introducing the > formula. > > In that case, if we are talking about just a few cells, one way to solve the > case would be: > > 1. Focus on the relevant cell. > 2. [CTRL]+[1] > Numbers > Format as "General" (or use a toolbar) > 3. [F2] > 4. [Backspace] (it will delete the last closing parenthesis of the formula) > 5. [ENTER] > > There are other methods too. > > Please confirm that this solves the issue for you. If it doesn't, please > paste the Help > About info in your next reply and attach a sample file. Thank you for answering. I did check what you mentioned before creating a bug. When I went to get the Help/About info, I restarted Calc. Just for fun, I retested the formula, and it worked. I had opened a CSV file and noticed the odd behavior. I then created a new file because I couldn't believe it, and it still happened. Apparently, it was a one-time problem caused by who knows what. I'll close this ticket.
The behavior went away after restarting Calc.