Bug 162943 - [LOCALHELP] Allow localized decimal separator for values ​​of "pi" and "e"
Summary: [LOCALHELP] Allow localized decimal separator for values ​​of "pi" and "e"
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
Version:
(earliest affected)
24.2.6.2 release
Hardware: All All
: medium trivial
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Help
  Show dependency treegraph
 
Reported: 2024-09-13 08:41 UTC by nutka
Modified: 2024-12-24 05:46 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Help for 3.3.0.4 vs 24.2.6.2 - decimal separator (199.32 KB, image/png)
2024-09-13 08:43 UTC, nutka
Details

Note You need to log in before you can comment on or make changes to this bug.
Description nutka 2024-09-13 08:41:26 UTC
Description:
Help for Writer, topic "Formula", section "More Defined Values" [1]:

-------------------------------------------

Description          Name   Value

PI                   PI     3.1415...

Euler's constant     E      2.71828...
	
-------------------------------------------

In case of local Help, the decimal separator in both mathematical constants should be adapted to the specific country (locale).
It seemed possible in LibreOffice 3.3.0.4 - cf. the attached file.


[1]
https://help.libreoffice.org/24.2/en-US/text/swriter/02/14020000.html?&DbPAR=WRITER

Steps to Reproduce:
⠀

Actual Results:
⠀

Expected Results:
⠀


Reproducible: Always


User Profile Reset: No

Additional Info:
⠀
Comment 1 nutka 2024-09-13 08:43:02 UTC
Created attachment 196423 [details]
Help for 3.3.0.4 vs 24.2.6.2 - decimal separator
Comment 2 Julien Nabet 2024-09-13 09:53:55 UTC
Olivier: I noticed it started from: db901dd0afc1029f3b9b801410de9ad75df05cb2
Mute l10n translations of writer function names
(in 2020).

I can submit a patch to revert partially this one and remove "localize="false"" for the concerned strings, what do you think?
Comment 3 Regina Henschel 2024-09-13 22:12:20 UTC
The decimal separator is only determined by the system default language, if the language in the number format of the table cell is set to "Default". Otherwise the decimal separator is determined by the language that is set in the number format. So you can have a dot as separator in one cell and a comma in another cell.

So instead of allowing translation, I would add a hint to "Number Format" (help/en-US/text/shared/01/05020300.html ?) to the page.
Comment 4 nutka 2024-09-14 20:20:35 UTC
Also consider adding an appropriate note in Calc Help for EXP, LN, and IMLN.
In the description of these functions one reads:

"The constant e has a value of approximately 2.71828182845904."