Hi,
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");
Rounding errors?
Missing Excel format options?
Bug in old version?
Any idea?
regards
Michael
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.