Excel Export data format

QuestionsExcel Export data format
Mario asked 4 years ago

Hello,

when exporting .xls a column with an EAN-Nr is cut to

7,64015E+12

instead of:
7640152770876

Of course, I could rightclick in MS Excel "change format" > special format to show the number in full. But is it possible to tell phpgrid to transfer the correct data format immediately?

Best regards,
Mario

1 Answers
Abu Ghufran answered 4 years ago

Edit lib/inc/php-export-data.class.php:

Replace:
if(preg_match("/^-?d+(?:[.,]d+)?$/",$item) && (strlen($item) < 15)) {

To:
if(preg_match("/^-?d+(?:[.,]d+)?$/",$item) && (strlen($item) < 10)) {

Your Answer

13 + 13 =

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 / 5. Vote count:

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

Let us improve this post!