Excel export format cell to USD $ currency

Bharani commented on Aug 29, 2019

Hi,

I want to show column data with $ sign prefix to number(order amount). By using the below code, able to show it but not able to calculate by selecting multiple rows in the excel sheet. I think because of missing currency format.

    ->pipe(new ColumnMeta(array(
        "order_amount" => array(
            "label" => "Sale Amount",
            "type" => "number",
            "prefix" => '$',
            "decimals" => 2
        )                            
    )))

David Winterburn commented on Aug 29, 2019

Hi Bharani,

When I test export this column to excel with this meta I could see the prefix, decimal correctly. I can also use sum formula for the column in excel as the column is of number format.

Would you please describe more specifically with an example of your problem so we could check it? Thanks!

Bharani commented on Aug 29, 2019

Please look into below screenshot that sum of 2 rows showing as 0.

David Winterburn commented on Aug 30, 2019

Which version of LibreOffice are you using? Testing my excel exporting file, this sum works fine with LibreOffice 6.0.5. Thanks!

Bharani commented on Aug 30, 2019

I using LibreOffice 5.1.6.2.

David Winterburn commented on Aug 30, 2019

Are you able to test this with LibreOffice 6?

Bharani commented on Sep 2, 2019

Hi David,

I hope you are doing well,

Please look into it, this time using the latest version of ms excel but it's not working.

David Winterburn commented on Sep 3, 2019

Hi Bharani,

Please post your php code and send us your exported excel file (via link here or to our email support@koolphp.net) for us to check it for you. Thanks!

KoolReport's Forum

Excel export format cell to USD $ currency #1066

Build Your Excellent Data Report