Home Forums Plugins Store Exporter Support [Resolved] 2 issues (numbers starting with "0", and 2nd line of address) Reply To: [Resolved] 2 issues (numbers starting with "0", and 2nd line of address)

#39596
Michael Visser
Keymaster

Hi Nathalie, just cleaning up old tickets made over the summer vacation. For the export of XLS and XLSX file types we detect the ‘0’ leading character and set the cell type to “Text” so we’re following all the rules. Different versions of Excel re-format those cells back to Default or Numeric which strips the ‘0’ leading character. I’m updating our ExcelPHP library with each release so fingers crossed a fix gets included for compatibility with your release of Excel.

Re: the second line of the postal address I’ll reproduce this and include it in the next Plugin release 🙂