GNOME Bugzilla – Bug 638832
Can't enter text starting with "=" into text-formatted cells.
Last modified: 2011-01-16 21:14:04 UTC
1. Format A1 as "text". 2. Enter =IF into it. --> Observe error, expected simple text in cell. We also show formula tooltip for this, ie., we are currently consistent. That should also be prevented when we no longer intend to parse the expression. Note: Excel gets it wrong: it enters as text [good] but shows tooltips [bad].
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.