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

Welcome to our community support forums! We're here to help - but if you have an urgent request for a Pro Plugin, you will get a prioritised response through our Premium Support page.

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #38995
    Nathalie
    Participant

    Dear support,

    I am currently using the Store Exporter Deluxe, and managing some customer exports.
    I have 2 questions :
    – When I choose the format Excel as “Export format”, the character “0” dispappears if it is the first character of a string containing only figures. It occurs on postal codes (some postal codes in France starts with a “0”) and telephone numbers (all telephone numbers in France start with a “0”). This is annoying. Would it be possible, in your export, to format the Excel cells in a way that the “0” do not disappear ? (I do not want to use CVS or XML as export formats)
    – The field containing the second line of the postal address is not exported. Can you please add it to your core export?

    Many thanks !
    Nathalie

    #39034
    Nathalie
    Participant

    Dear support,
    I have an additional information. Actually, your export includes the initial “0” in the Excel spreadsheet. But the initial “0” disappears if the Excel file is saved.
    To avoid this, all cells have to be formated as “text”. Is it please possible to add this in your export script, in order to avoid any issue?
    Thanks in advance !
    Nathalie

    #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 🙂

Viewing 3 posts - 1 through 3 (of 3 total)
  • The topic ‘[Resolved] 2 issues (numbers starting with "0", and 2nd line of address)’ is closed to new replies.