[Bug 70146] Incorrect currency formatting

[email protected] Thu, 16 Jul 2026 09:23:34 +0000
Newsgroups gmane.comp.jakarta.poi.devel
Message-ID <[email protected]/bugzilla/>
https://bz.apache.org/bugzilla/show_bug.cgi?id=3D70146

--- Comment #1 from aditsu <[email protected]> ---
Kotlin test code:

import org.apache.poi.ss.usermodel.DataFormatter
import org.apache.poi.ss.usermodel.WorkbookFactory
import java.io.File

fun main() {
        val path =3D "/home/aditsu/Documents/ccy test.xlsx"
        val wb =3D WorkbookFactory.create(File(path))
        val sheet =3D wb.getSheetAt(0)
        val row =3D sheet.getRow(0)
        val df =3D DataFormatter()
        for (i in 0..1) {
                val cell =3D row.getCell(i)
                println(df.formatCellValue(cell))
        }
}

Expected results:
12,345.00 USD
HKD $12,345

Actual results:
12,345.00 [$USD]
[$HKD $]12,345

--=20
You are receiving this mail because:
You are the assignee for the bug.=