https://bugs.documentfoundation.org/show_bug.cgi?id=156420
Bug ID: 156420
Summary: The results of complex number functions in Calc are
always using a point as decimal separator
Product: LibreOffice
Version: 7.5.5.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: trivial
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: arbau...@gmail.com
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
--
You are receiving this mail because:
You are the assignee for the bug.
