Major Steps to Reproduce
Open attached xlsx in Keikai 5.12.0 / keikai 6.0.0
Current Result
$123.00
123.00 [$€-47E]
123.00 [$CFA-340C]
[$GRD] 123.00
123.00 [$ج.م.-C01]
S/ 123.00
Expected Result
$123.00
123.00 €
123.00 CFA
GRD 123.00
123.00 ج.م.
S/ 123.00
Debug Information
- cells are in accounting format, not currency format
- Format output by excel appears to contain the bracket notation:
from "test-standard.xlsx!xl\styles.xml"
<numFmts count="6"><numFmt numFmtId="164" formatCode=""$"#,##0.00"/><numFmt numFmtId="165" formatCode="#,##0.00\ [$€-47E]"/><numFmt numFmtId="166" formatCode="_-* #,##0.00\ [$CFA-340C]_-;\-* #,##0.00\ [$CFA-340C]_-;_-* "-"??\ [$CFA-340C]_-;_-@_-"/><numFmt numFmtId="168" formatCode="_([$GRD]\ * #,##0.00_);_([$GRD]\ * \(#,##0.00\);_([$GRD]\ * "-"??_);_(@_)"/><numFmt numFmtId="169" formatCode="_-* #,##0.00\ [$ج.م.-C01]_-;\-* #,##0.00\ [$ج.م.-C01]_-;_-* "-"??\ [$ج.م.-C01]_-;_-@_-"/><numFmt numFmtId="171" formatCode="_-[$S/-280A]\ * #,##0.00_-;\-[$S/-280A]\ * #,##0.00_-;_-[$S/-280A]\ * "-"??_-;_-@_-"/></numFmts>
Workaround
use "Currency" format
- relates to
-
KEIKAI-821 display date format incorrectly with unexpected country code
-
- Closed
-