Bug 156420 - The results of complex number functions in Calc are always using a point as decimal separator
Summary: The results of complex number functions in Calc are always using a point as d...
Status: RESOLVED DUPLICATE of bug 66319
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium trivial
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-07-22 09:49 UTC by Jean-Claude Arbaut
Modified: 2023-07-22 11:20 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jean-Claude Arbaut 2023-07-22 09:49:26 UTC
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
Comment 1 ady 2023-07-22 11:20:50 UTC
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 ***