Guriddo » Topic: setExcelOption numeric

setExcelOption numeric

Guriddo
setExcelOption numeric

This topic has 3 replies, 2 voices, and was last updated 1 year, 8 months ago by ariadrianto.

Creator

Topic

March 28, 2022 at 1:48 pm #127922

ariadrianto

Participant

Hi All,

is there any setExcelOptions that will format into numeric ( decimal separator, thousand separator ) … ?

$grid->setColProperty("PPN", array("label"=>"PPN", "width"=>155,"editable"=>false,"formatter"=>"number", "formatoptions"=>array("thousandsSeparator"=> ",", "decimalSeparator"=> ".", "decimalPlaces"=>0),
"align"=>"right","search"=>false, "width"=>85, "summaryType"=>"sum"));
.....
$grid->setExcelOptions(array(
"file_type" => "Excel2007",
"file" => "test.xlsx",
"start_cell" => "A1",
"font" => "Arial",
"font_size" => 11,
"protect" => false,
));

$grid->setColProperty("PPN", array("label"=>"PPN", "width"=>155,"editable"=>false,"formatter"=>"number", "formatoptions"=>array("thousandsSeparator"=> ",", "decimalSeparator"=> ".", "decimalPlaces"=>0),

"align"=>"right","search"=>false, "width"=>85, "summaryType"=>"sum"));

.....

$grid->setExcelOptions(array(

"file_type" => "Excel2007",

"file" => "test.xlsx",

"start_cell" => "A1",

"font" => "Arial",

"font_size" => 11,

"protect" => false,

));

Thank you

This topic was modified 1 year, 8 months ago by admin. Reason: code formating

Creator

Topic

Viewing 3 replies - 1 through 3 (of 3 total)

Author

Replies

March 28, 2022 at 5:01 pm #127925

guriddo.support

Participant

Hello,

This can be done per column using the excel_options property in format options.

When set it should contain a formatting string as it is in excel cell. In your case this can look like this.

$grid->setColProperty("PPN", array(
"label"=>"PPN", 
"width"=>155,
"editable"=>false,
"formatter"=>"number", 
"formatoptions"=>array(
    "excel_format"=>"#,##0.00"
    ...
),
"align"=>"right",
"search"=>false, 
"width"=>85, 
"summaryType"=>"sum"
));

$grid->setColProperty("PPN", array(

"label"=>"PPN",

"width"=>155,

"editable"=>false,

"formatter"=>"number",

"formatoptions"=>array(

"excel_format"=>"#,##0.00"

...

"align"=>"right",

"search"=>false,

"width"=>85,

"summaryType"=>"sum"

));

Kind Regards,

Will

Guriddo Support Team

March 30, 2022 at 4:49 am #127927

ariadrianto

Participant

Hi,

Thanks… it works…

any excel_format for date… it become ‘1970-01-01’ when null value.

Date

01-January-1970

28-February-2022

01-January-1970

thanks…

March 30, 2022 at 4:52 am #127928

ariadrianto

Participant

My mistake…

you’ve already answer this before… with


&lt;div&gt;
&lt;div&gt;$grid-&gt;setExcelOptions(array(&lt;/div&gt;
&lt;div&gt;&quot;file_type&quot; =&gt; &quot;Excel2007&quot;,&lt;/div&gt;
&lt;div&gt;&quot;empty_date&quot; =&gt; true,&lt;/div&gt;
&lt;div&gt;...&lt;/div&gt;
&lt;div&gt;));&lt;/div&gt;
&lt;div&gt;