Excel Export Problem: Unique ID is incorrect

  • Profile Image
    sdhxcs
    Asked on April 22, 2014 at 12:40 AM

    Just from late this afternoon, I found an issue with Excel export. There's an Unqiue ID field in my form with a format of 2014_xxxx (such as 2014_2987), and in the Excel it only keeps first four numbers 2014, and the rest is gone. However, in csv the field seems to be correct. Would you help me resolve this issue? 

    Also, I realized before some fields with numbers were treated as text, now in Excel they all have been converted to number. (My Excel options settings do not allow auto conversion). 

    BTW, the Excel file size is also smaller than before even with more submissions.

  • Profile Image
    aytekin
    Answered on April 22, 2014 at 03:22 AM

    Opened the bug ticket. We will fix this problem and get back to you.

  • Profile Image
    sdhxcs
    Answered on April 22, 2014 at 10:34 AM

    I just exported a new Excel spreadsheet this morning, and the problem seems to be gone now. All numbers exported as text and Unique ID is correct. Thanks!

  • Profile Image
    sdhxcs
    Answered on April 22, 2014 at 11:21 AM
    Yes, it's fixed. Thank you so much!
    ...