search

mk-j / PHP_XLSXWriter

Lightweight XLSX Excel Spreadsheet Writer in PHP
MIT License
1.84k stars 665 forks source link

Brazilian REAL changing format #285

Closed scorninpc closed 4 years ago

scorninpc commented 4 years ago

First of all, this project save my live running 600k rows hahaha

But when I config brazil real price, the format are changed to generical format, because it is removing the R from format

This is my mistake or can be a problem?

The configuration

https://i.imgur.com/vht8Un4.png

What work on libreoffice

https://i.imgur.com/Fj28YF8.png

scorninpc commented 4 years ago

Ok, after look code, I escape the R like

[$\R$-416] #,##0.00

And it's work

All code for BRL

[$\R$-416] #,##0.00;-[$\R$-416] #,##0.00

Thank you all for this project