Bug 166231 - Cannot divide two cells when one cell contain decimal value between 0 and 1
Summary: Cannot divide two cells when one cell contain decimal value between 0 and 1
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.8.6.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-04-17 15:32 UTC by Cameron
Modified: 2025-04-18 05:40 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
gif showing step-by-step division bug (478.58 KB, image/gif)
2025-04-17 15:34 UTC, Cameron 		Details
View All 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 Cameron 2025-04-17 15:32:46 UTC 
Description:
I am encountering an issue when trying dividing the values of two cells : if one of them has a decimal value between 0 and 1 (e.g.: 0.05), Calc does not accept the operation.

I did not have this issue before: it came up recently and I used to have the correct results appear automatically in each cell.

Steps to Reproduce:
1.Insert random value (>1) in one cell and decimal value (0>value>1) in another
2.In a third cell, perform division operation between cells 1 & 2
3.Confirm or press ENTER to get result

Actual Results:
Highlighted text in green of the mathematical operation without any result.

Expected Results:
Correct mathematical result.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.8.6.2 (X86_64) / LibreOffice Community
Build ID: 6d98ba145e9a8a39fc57bcc76981d1fb1316c60c
CPU threads: 8; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: CL threaded
Comment 1 Cameron 2025-04-17 15:34:05 UTC 
Created attachment 200376 [details]
gif showing step-by-step division bug
Comment 2 Eike Rathke 2025-04-17 16:20:59 UTC 
Looks like you have Show Formulas enabled, menu View -> Show Formulas.
Comment 3 Cameron 2025-04-17 16:23:32 UTC 
(In reply to Eike Rathke from comment #2)
> Looks like you have Show Formulas enabled, menu View -> Show Formulas.

Well done sir, thanks. Bug solved.