Phpspreadsheet: Currency Brazilian Format
This is:
- [x] a bug report
What is the expected behavior?
Format values with parameter
What is the current behavior?
I create a parameter mask in excel 2016
What are the steps to reproduce?
Sorry for my bad english, for better explanation, i'm using images for example.
I'm need format a some cells with the Brazilian Real format. The library does not include this format by default.
I took the format used by Excel, using the program interface. When using within the library, the generated file does not apply the format.
Format gerated:
With used:
Final Result:
Which versions of PhpSpreadsheet and PHP are affected?
PHP: 7.1.9
Php Spreadsheet: 1.0 by composer.json
skay1994
All 2 comments
Use . for the decimal separator, , for the thousands separator in your format mask for PHPSpreadsheet.... the code is not locale-aware, and won't change it for you internally where the mask is always stored as . for decimals and , for thousands ; in MS Excel, localisation for thousands and decimal separators are handled within the Excel GUI.
ie.
->setFormatCode('R$ #,##0.00_-');
MarkBaker
on 10 Jan 2018
are working, thanks!
skay1994
on 10 Jan 2018
Related issues
alexbog8
路
4Comments
leandrogm
路
5Comments
PowerKiKi
路
5Comments
smartlara
路
5Comments
isopen
路
3Comments
Most helpful comment
Use
.for the decimal separator,,for the thousands separator in your format mask for PHPSpreadsheet.... the code is not locale-aware, and won't change it for you internally where the mask is always stored as.for decimals and,for thousands ; in MS Excel, localisation for thousands and decimal separators are handled within the Excel GUI.ie.