thousandseparator on Excel Export

ES commented on Aug 16, 2018

I have some problems with the thousandseparator. I set the ColumnMeta like this:

$node->pipe(new ColumnMeta(array(

  "max"=>array(
    "type" => "number",
"thousandSeparator" => ".",
"decimalPoint" => ",",
"decimals" => 0,
  ),
)))

to get a German ThousandSeparator (.) and DecimalSeparator (,). It works fine for viewing the report on the screen and also on CSV- and PDF-export. But on a Excel-Export I will get the English settings. There is no special column setting on the Excel-export.

How can I get the German settings also for the Excel export?

David Winterburn commented on Aug 17, 2018

Hi there,

I think the latest version of the Excel package supports exporting columns with meta format. Please download the latest version of Excel to try it.

Also let us know if you were exporting excel table or excel pivot (which has not supported column formatting yet)? Thanks!

ES commented on Aug 21, 2018

Hi, I'm using version 3.0.0 of the Excel package, which seems to be the latest version.

I'm not using excel pivot, it's a standard spreedsheet.

Best regards.

KoolReport's Forum

Thousandseparator on Excel Export #417

Build Your Excellent Data Report