https://bugs.documentfoundation.org/show_bug.cgi?id=153707
Bug ID: 153707 Summary: NPV function error with big number Product: LibreOffice Version: 7.4.5.1 release Hardware: x86-64 (AMD64) OS: macOS (All) Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: xacax66...@mustbeit.com Description: Given a list of these numbers: 862500 862500 862500 862500 862500 862500 862500 =NPV(0.1, 862500,862500,862500,862500,862500,862500,862500...) The cell value becomes "###" However, we I do the same with the small values 862.5, it works. =NPV(0.1, 862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5) return 5.299,69 Steps to Reproduce: Given a list of these numbers: 862500 862500 862500 862500 862500 862500 862500 =NPV(0.1, 862500,862500,862500,862500,862500,862500,862500...) The cell value becomes "###" However, we I do the same with the small values 862.5, it works. =NPV(0.1, 862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5,862.5) return 5.299,69 Actual Results: With the values such as 862500 as "Value"parameter in the NPV function, it returns "###" Expected Results: Should calculate NPV Reproducible: Always User Profile Reset: No Additional Info: n/a -- You are receiving this mail because: You are the assignee for the bug.