https://bugs.documentfoundation.org/show_bug.cgi?id=168683
Bug ID: 168683
Summary: FORMATTING : the TEXT() function doesn't work as one
would expect
Product: LibreOffice
Version: 25.8.1.1 release
Hardware: All
OS: NetBSD
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Specifying a formula with TEXT() function fails. The formula
=TEXT(123.4,"#,###.##") results in a value of ``123.4'' - it drops the
fractional digits. The expected result should be ``123.40''
Steps to Reproduce:
1.enter formula in a cell =TEXT(123.4,"#,###.##")
2.
3.
Actual Results:
123.4
Expected Results:
123.40 (should have exactly two fractional digits)
Reproducible: Always
User Profile Reset: No
Additional Info:
version libreoffice-25.8.1.1nb1 (from NetBSD pkgsrc)
NetBSD version 11.99.3
Version: 25.8.1.1 (X86_64) / LibreOffice Community
Build ID: 580(Build:1)
CPU threads: 32; OS: unknown; UI render: default
Locale: en-US (C); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
