[Libreoffice-bugs] [Bug 139978] New: Forced autocorrections of formulas to fractions as text, on paste into Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 139978
           Summary: Forced autocorrections of formulas to fractions as
                    text, on paste into Calc
           Product: LibreOffice
           Version: 7.0.4.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: openforum at davidpbrown.co.uk

Description:
With autocorrect options disabled, as much as is possible, pasting of formulas
still seems to force fractions and breaks the formulas - and in a way that
cannot be easily worked around.

Steps to Reproduce:
Paste from a plain text file "​=1/2" to any cell on a new file, with the format
already then number:general

Actual Results:
see then "​=1⁄2" is made with a Unicode fraction slash U+2044 and not the usual
solidus U+002F
and some zero width space U+200B has been introduced as a prefix, which stops
it as a formula.



Expected Results:
expected formula to action as 0.5 or worst case default as text but not badly
translated.


Reproducible: Always


User Profile Reset: No



Additional Info:
Repeat this with 
"
​=0+1⁄2
=9+1/2
"
to see the oddity also that =9+1/2 works - so "=0+" is not a workaround.

-------------------
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes

-- 
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/20210128/c170c25b/attachment.htm>