[Issue 126681] formula entry in text-formatted cell leads to unnecessary syntax warning pop-up

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=126681

--- Comment #1 from Joe Smith <je...@martnet.com> ---
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.