[Libreoffice-bugs] [Bug 129998] New: Calc wrongly tries to correct incorrectly written function

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 129998
           Summary: Calc wrongly tries to correct incorrectly written
                    function
           Product: LibreOffice
           Version: 6.3.2.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: wingsuit at hot.ee

Description:
if mistakenly , is used in ROUND function declaration, extra 0 is introduced
into the function declaration.
It is probably because in my locale settings (Estonian) "," is decimal
separator, so it thinks I am trying to write 0,2 but I feel this adding a
leading 0 to erroneous function declaration might not be correct.


Steps to Reproduce:
1. Open CALC (blank document)
2. write into A1: 476 
3. write into A2: 48
4. write into A3: =A1/A2 
5. write into A4: =round(a3 
6. press ENTER - A4 will get value 10
7. navigate back to A4, press F2 to edit and add ,2 in the function, so cell
becomes =round(A3,2) (a mistake, obviously, should be =round(A3;2) )
8. press Enter
Cell A4 displays Err:509
9. now go back to A4 and press F2 - value is =ROUND(A30,2) - so A3 has changed
to A30.

Actual Results:
A3 has changed to A30.

Expected Results:
A3 would stay as A3


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
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/20200114/1a48bd64/attachment.htm>