oleibman

No update in 9 months, closing.

I suspect this has to do with your use of comma as the decimal separator in cell A2. Because of your different locale, I would need to see your spreadsheet...

As suspected, cell L2 (and the rest of the cells with percentages) is stored as a string rather than a number. Out of curiosity, how were the cells entered into...

However, I don't think that's the best solution. Try this after your Settings::setLocale: ```php StringHelper::setThousandsSeparator('.'); StringHelper::setDecimalSeparator(','); ``` I am a bit surprised that doesn't happen automatically with Settings::setLocale. I will...

Closing. No update in 8 months, and suggested solution seems easy and adequate, especially with the changes from PR 3815.

Can you share the code that you are using to create the table and add it to the worksheet? (Roughly this as you've modified it from the sample you started...

PR #3659, which was merged last week, should address that problem. Can you confirm by testing against master?

I add the following lines near the end of 02_Table_Totals.php, on which you have based your program: ```php $newSheet = $spreadsheet->createSheet(); $newSheet->getCell('A1')->setValue('=SalesData[[#Totals],Sales]'); ``` I think this is close to what...

Again, 02_Tables_Total adds the totals row on the same sheet and does not have a problem. I need to see your spreadsheet in order to attempt to figure out what...

@Buyur Apologies - I did not notice your message till now. The binary zeroes are because Xls stores its strings as UTF16, which requires 2 bytes per character. If your...