Bug 152313 - LibreOffice Calc calculates wrong results when using fraction notation
Summary: LibreOffice Calc calculates wrong results when using fraction notation
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.7.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-11-30 13:36 UTC by Georg Sandkühler
Modified: 2023-03-07 09:27 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Georg Sandkühler 2022-11-30 13:36:43 UTC 
Description:
converting 0,125 to a fraction results in 1/8, correct. Dividing this fraction 1/8 by 2 results in 1/9 which is obviously wrong. Converting 0,06125 to a fraction notation results in 1/16 which is correct again.

Steps to Reproduce:
1. enter 0,125 to cell A1
2. use "format/Cell" and fraction (Deutsch: Bruch)
3. use in cell A2 "=A1/2"
4. result is wrong

Actual Results:
wrong: 1/9

Expected Results:
correct: 1/16


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.3.7.2 / LibreOffice Community
Build ID: 30(Build:2)
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Ubuntu package version: 1:7.3.7-0ubuntu0.22.04.1
Calc: threaded
Comment 1 Robert Großkopf 2022-11-30 14:05:42 UTC 
Seems you are using format like
# ?/?
but it won't show more than one digit. It couldn't show values < 1/9
# ??/??
will show the right result here.
Comment 2 Buovjaga 2023-03-07 09:27:39 UTC 
No comment, so let's assume that was the issue