KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Price format #2352

Open Oya Kaynar opened this topic on on Sep 22, 2021 - 1 comments

Oya Kaynar commented on Sep 22, 2021

Example: Converted to number format for summing in Excel. Because our values are kept as varchar 100000.33
But view.php and excel.view.php page It should be able to be collected in excel as in the example within the pages ex: 100.000,33

Can you help with this?

Sebastian Morales commented on Sep 23, 2021

Pls try to change the column meta's type to "number" like this:

//MyReport.php
->pipe(new ColumnMeta(array(
    "column1" => array(
        "type" => "number",
    )
)))
->pipe($this->dataStore("myDs"));

or directly with the excel Table widget in your excel view

//MyReportExce.view.php
exce\Table::create(array(
    ...
    "columns" => array(
        "column1" => array(
            "type" => "number",
        )
    )        

Let us know if there's any problem. Tks,

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet

None