formatting error on excel export

Questionsformatting error on excel export
Hello Abu asked 5 years ago


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?


2 Answers
Abu Ghufran answered 5 years ago

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.

Abu Ghufran answered 5 years ago


We've integrated new excel library.
Please email me your active ordernumber and payment email address to get latest build.

Your Answer

11 + 20 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.

How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?