mlutfy / ca.bidon.civiexportexcel

ARCHIVE - Export CiviCRM reports directly to MS Excel
https://lab.civicrm.org/extensions/civiexportexcel/
GNU Affero General Public License v3.0
5 stars 6 forks source link

Postal code field issue #7

Open davesbot opened 7 years ago

davesbot commented 7 years ago

Hi Mathieu, I'm not sure if this has been reported. We have a client exporting address data where the postal code begins with "0",

In the xlsx display the leading "0"is removed. Its not clear if this is bug or a display issue. I've attached the output file.

Thanks

vlct_postal_Export_20170206-1726.zip

mlutfy commented 7 years ago

hi @davesbot. Thanks for reporting the issue. I haven't run into that bug, but Canadian postcodes start with a letter. It should be possible to fix this by using the column headers and setting the proper format option in phpexcel. Maybe test here: https://github.com/mlutfy/ca.bidon.civiexportexcel/blob/master/CRM/CiviExportExcel/Utils/SearchExport.php#L113 ?