https://bugs.documentfoundation.org/show_bug.cgi?id=170976
Bug ID: 170976
Summary: Function INDEX returns a wrong result
Product: LibreOffice
Version: 25.8.4.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
The function INDEX returns a wrong result in one special case (at least)
Steps to Reproduce:
1.Fill the column C with the spellings of the 20 numbers, from one to twenty
2.Cell A2 : write 2,01 or 2.01 depending on the country
3.Cell A3 : write the formula =INDEX($C$1:$C$99;MOD($A$2*100;100))
Actual Results:
three (because the formula is at line 3)
If the formula was at line 18 the result would be eighteen
Expected Results:
un (one)
Reproducible: Always
User Profile Reset: No
Additional Info:
I want to get the spelling of the decimals of a number I write in cell A2.
If the value written at cell A2 is for example 0,01 or 1,01 or 12,01, the
result is correct, ie "un" (one).
If the value written in cell A2 is for example 0,02 or 1,02, 12,02 even 2,02,
the result is correct, ie "deux" (two).
The integer values (ie 2 - 10) return the same bad value as 2.01
I've tested several values in cell A2 (not all!) and only the value 2.01 and
the integer values, return a bad result.
I'm in France and the values I enter is with a comma (,) instead of a dot.
I tested in safe mode and the problem is the same.
The error occurs also with Libreoffice version 24.2.7.2 (X86_64) on the same
material.
Version: 24.2.7.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu package version: 4:24.2.7-0ubuntu0.24.04.4
Calc: threaded
Version: 25.8.4.2 (X86_64) / LibreOffice Community
Build ID: 580(Build:2)
CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu package version: 4:25.8.4~rc2-0ubuntu0.24.04.1~lo1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
