https://bz.apache.org/ooo/show_bug.cgi?id=126681
--- Comment #1 from Joe Smith <[email protected]> --- Oops, hit Enter too soon.Here's the description: Formatting a cell as text should accept any subsequent entry as literal text. This fails if the user makes an entry starting with = or + but which is not a valid formula. In this case, Calc pops up a formula syntax/correction dialog window. The syntax warning/correction prompt is unnecessary and confusing and should not be triggered in this situation. Steps to reproduce: 1) File > New > Spreadsheet ... 2) Select column A 3) Format > Cells > Numbers > Category: Text, OK 4) Enter in A1: =/2015 A warning dialog window appears, offering to correct the input to =2015 Confirming leads to entry =2015 (as text, not formula) Dismissing leads to entry =/2015 (as text, not formula) This dialog is not correct and should not appear at all for such text entries. The entry is not a formula, and should not be changed or corrected. The dialog is confusing and disrupts data entry. One workaround: avoid using = as the first character, then use Edit > Find & Replace to fix the entries all at once. Forum discussion: https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=80484 -- You are receiving this mail because: You are the assignee for the issue.
