[Libreoffice-bugs] [Bug 133782] [EDITING] Add option to stop absolutely all autoconversion of non-numeric characters into numerics

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133782

--- Comment #2 from zzz <pox_ox2 at yahoo.com> ---
I forgot to mention that my Language Of | User interface setting is English
(USA), and Locale settings is "Japanese".

Re:>V Stuart Foote 2020-06-08 14:22:23 UTC
   >I'll take your word it is undesirable for ja-JA usage
Correct, if that means the data locale. If you mean Language Of | User
interface, then I don't want Calc to change any data handling behaviour by UI
settings.
Sorry that I wasn't clear enough, and thanks for confirming.

  >when I set the  language for the cell to Japanese
Do you mean the Format Cells | Asian Text Font | Language ?

One modification to my request:
I observe a lot of Japanese language users mistakenly enter the so-called
"wide" characters in cell formulae. Excel cells autoconverts these to ASCII, so
many users keep this habit.
(a) "wide" numbers, "０１２３４５６７８９" (U+FF1x) in places of numbers. Excel cells
autoconverts this to numbers (both from keyboard IME and from paste).
LibreOffice Calc already does this.
(b)Similary, many users enter "wide" symbols and letters such as "＝Ａ２" to mean
ASCII formula "=A2", "’Ａ" to mean ASCII literal "'Ａ" etc.
Excel response differs whether they are from keyboard into cell, or into edit
bar, or pasted into cell! LibreOffice Calc does no conversion.
I personally don't do and don't like these (especially the random conversions
in literals), but think some people may want LibreOffice Calc to behave
similarly to Excel.
This means we need two or more independent option entries to toggle
autoconvert:
(a)"０１２３４５６７８９": default=autoconvert
(b)"＝Ａ２": default=autoconvert
(c)"’Ａ": default=autoconvert Excel compatible
(d)"〇": default=no convert

For a tentative solution only for me, just turn off the "〇"->0 autoconversion.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200609/d45e78eb/attachment-0001.htm>