we are using grid version 1.52.
Nearly everything working fine except the excel export.
We have several fields with invoice amounts and taxes (in grid formatted with thousands separator and decimal separator). In the exported excel file these amounts have decimal places from none up to seven.
I've tried on DB side with double and decimal on grid side with number and currency.
Always the same result.
$grid["export"] = array("filename"=>"invoices","heading"=>"invoices", "range"=>"filtered", "paged"=>"1");
Missing Excel format options?
Bug in old version?
In current excel export library, this is not supported.
We're working to change export lib to new one 'phpexcel' that support many rich features.
It's currently in development phase. You ticket is still open and will update you after some progress.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?