https://bugs.documentfoundation.org/show_bug.cgi?id=171914
Bug ID: 171914
Summary: Function TEXT is not working correctly for long number
Product: LibreOffice
Version: 26.2.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 206879
--> https://bugs.documentfoundation.org/attachment.cgi?id=206879&action=edit
Function Wizard for TEXT function
Function TEXT is not working correctly for long numbers. Long numbers are
formated as E-notation.
For example: number: 70109025900000000121883311 is formated by TEXT(a1;"@") to
7,01090259000000E+25
See attachment.
--
You are receiving this mail because:
You are the assignee for the bug.