get cell currency format other than $ and EUR

Topics: User Forum
Oct 7, 2013 at 12:28 AM
Edited Oct 7, 2013 at 12:29 AM
PHPExcel uses $ / EUR only:
const FORMAT_CURRENCY_USD_SIMPLE        = '"$"#,##0.00_-';
const FORMAT_CURRENCY_USD            = '$#,##0_-';
const FORMAT_CURRENCY_EUR_SIMPLE        = '[$EUR ]#,##0.00_-';
What I need is to get other currencies (I use "zł" for polish zloty). All currencies excep $ and EUR are marked as 'General'.

How do I use custom format. I put new constants in NumberFormat.php:
const FORMAT_CURRENCY_PLN_1 = '_-* #,##0.00\ [$zł-415]_-';
const FORMAT_CURRENCY_PLN_2 = '\-* #,##0.00\ [$zł-415]_-';
const FORMAT_CURRENCY_PLN_3 = '_-* "-&quot';
const FORMAT_CURRENCY_PLN_4 = '??\ [$zł-415]_-;_-@_-';
is it ok? What else I have to do to read formats using
$objPHPExcel->getCellXfByIndex($cell->getXfIndex())->getNumberFormat()->getFormatCode();
Oct 7, 2013 at 1:06 AM
I realised that "zł" is recognised in XLS format. In XLSX not. I think this is a bug?