https://bugs.documentfoundation.org/show_bug.cgi?id=148375
Bug ID: 148375
Summary: CALC FORMATTING False information concerning setting
for decimal separator, calculating not possible
because numbers are treated as text.
Product: LibreOffice
Version: 7.3.1.3 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: albert.clae...@telenet.be
Description:
I am using Windows 10/11 and LibreOffice CALC 7.3.2.
The language setting of the userinterface is 'Standaard-Nederlands (NL)'
Because I live in Belgium the keyboard is AZERTY with a dot (.) on the numeric
keyboard. Therefore My local setting is 'Standaard-Nederlands (België)'
My keyboard setting is 'Belgisch punt'.
The language-settings in CALC let me choose the decimal separator (selected) as
'X Equal to locale setting (,)' for the Dutch (NL) QWERTY-keyboard OR
(unselected) as 'O Equal to locale setting (,)' for the Belgian (BE)
AZERTY-keyboard (.).
This setting works fine, my decimal-key on my numeric keyboard changes from (,)
into (.).
The big problem is that CALC not recognized the point (.) as decimal separator
but treats the numbers with a dot as normal text, so the calculation does not
work!
Steps to Reproduce:
1.Goto 'Options'-'Language settings'-'Languages'
2.Unselect 'Decimal separator sign' => 'O Equal to local setting (,)' => symbol
becomes a decimal point (.) when key is touched on numeric keyboard, this is
OK.
3.Try to make a calculation: see attached picture :numbers are treated as text
instead of number! This is NOT OK!
Actual Results:
Calculation not possible. Numbers with decimal separator (.) are seen as text.
Expected Results:
CALC has to recognize the dot (.) as a decimal separator!
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Decimal separator key - Same as country setting
Specifies how the decimal separator key, this is "." on the numeric keypad and
set in your country settings, should be applied when you press that key.
If this check box is selected, the character displayed after "Same as country
setting" is inserted when you press the key on the numeric keypad. If that
check box is not selected, then the character specified in your keyboard driver
is inserted.
Translated with www.DeepL.com/Translator (free version)
--
You are receiving this mail because:
You are the assignee for the bug.
