https://bugs.documentfoundation.org/show_bug.cgi?id=170299
Bug ID: 170299
Summary: Calc shows 0 instead of error when number overflows
Product: LibreOffice
Version: 25.8.4.2 release
Hardware: ARM
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When a call calculates a number that is too large, it shows and uses 0 instead
of reporting and error.
I have attached a screenshot comparing this with the correct behaviour in MS
Excel.
I have also attached the Calc ODS and Excel files.
The formula is x^((p-1)!) mod p ... where x^((p-1)!) grows too large when x=5
and p=5, that is 5^(24).
Steps to Reproduce:
See attached spreadsheets and screenshot.
Actual Results:
The apparent result of the calculation is 0, and the subsequent calculations
are false.
Expected Results:
Instead of 0, an error should be reported.
Reproducible: Always
User Profile Reset: No
Additional Info:
We accept that accuracy is limited by floating point representation and
calculations.
But this is different.
This is falsely assigning 0 to an error.
--
You are receiving this mail because:
You are the assignee for the bug.
