Description: With regional settings set to have a comma as decimal separator (Windows 11 in french), numbers (real numbers) are correctly shown with a comma in Calc. However, complex number functions, such as COMPLEX.RACINE (french for IMSQRT), have results using a point as decimal separator. Those functions correctly take complex numbers with comma separator as /input/, but the output doesn't follow regional settings. As I understand it, since complex numbers in Calc are actually strings and are therefore not automatically translated when opened on a machine with different regional settings, it's necessary for those functions to accept strings with comma or point separator, and it seems to work (though I don't think thousand separators are handled correctly, but it's a minor inconvenience, and it could be ambiguous anyway). However, it would be nice to have output follow the regional settings for the decimal separator, and use a comma when needed. This behavior seems to happen with all complex number functions. I mark the severity as trivial as it does not affect numerical results. It's more a "visual bug", and it depends on regional settings. Steps to Reproduce: Set system decimal separator as comma. In any empty cell: =COMPLEXE.RACINE(-2) (french function) or =IMSQRT(-2). Actual Results: 1.4142135623731i Expected Results: 1,4142135623731i Reproducible: Always User Profile Reset: No Additional Info: Version: 7.5.5.2 (X86_64) / LibreOffice Community Build ID: ca8fe7424262805f223b9a2334bc7181abbcbf5e CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win Locale: fr-FR (fr_FR); UI: fr-FR Calc: CL threaded
I'll mark this as a duplicate of bug 66319. If there is something particularly different in this bug 156420, or that deserves to be considered as a separate report, please change it back to UNCONFIRMED. *** This bug has been marked as a duplicate of bug 66319 ***
I mark the severity as trivial as it does not affect numerical results. It's more a "visual bug", and it depends on regional settings. Steps to Reproduce: Set system decimal separator as comma. In any empty cell: =COMPLEXE.RACINE(-2) (https://geometryarrow.io) or =IMSQRT(-2). Actual Results: 1.4142135623731i Expected Results: 1,4142135623731i