hi sir
The data with 0 ie(09588545) is not getting exported.The 0 is getting omitted.
How to resolve this ?
Waiting for your help
Thank you
In lib/inc/php-export-data.class.php we have a code:
if(preg_match("/^-?d+(?:[.,]d+)?$/",$item) && (strlen($item) < 10)) {
$type = 'Number';
}
If length is < 10 and is number, then we'll export number format in excel export.
You can change this logic for your case.
thank you sir,
but that is not a number field.that is the varchar field but it will contain only the numbers like account details such TIN NO,ACCOUNT NO like that
how to solve this?
You can comment out above code and all fields will export as text.
Second option is to use custom excel export and put conditions to writeLabel or writeNumber for formatting.
Refer xlsWriteLabel function in demos > export > custom export code.