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:
(In reply to wingsuit from comment #0) > 9. now go back to A4 and press F2 - value is =ROUND(A30,2) - so A3 has > changed to A30. reproducible with Version 3.6.7.2 (Build ID: e183d5b) Version: 6.5.0.0.alpha0+ (x64) Build ID: 33ac8ea863ddba903834fe9d0e7165a087bb9c5f CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; Locale: de-DE (de_DE); UI-Language: en-US Calc: threaded
i think this issue is a duplicate of: Bug 69479 - Formula is getting corrupted after input Bug 86999 - Calc add a "0" in the cell reference when the argument are separated by a colon "," rather than a semi-colon ";" *** This bug has been marked as a duplicate of bug 69479 ***