Problem downloading data

  • Profile Image
    Asked on November 11, 2013 at 09:59 AM

    I have been using my forms for several months with no problems.  When I want to report, I go to MY FORMS and select the form.  The I click SUBMISSIONS and SAVE the submissions as an EXCEL spreadsheet.  I use a matrix in my MONTHLY form and this has always been pulled into the spreadsheet as NUMERIC data.  All of my Crystal Reports were designed to use this data as numeric.  This has worked for months.

    Suddenly, the excel spreadsheet is saving the data as TEXT and I can't force it to NUMERIC !!  This messes up my entire system.


    Is there any way I can force the data to be numeric in the EXCEL ???  I tried saving as CSV and it looks numeric but then I can't use that as a basis for my reports and when I save that CSV as an XLS file, it goes back to TEXT


    HELP ??


    Bill Dozier



  • Profile Image
    Answered on November 11, 2013 at 11:39 AM


    I have changed our Excel generator to use string data type for all cells to prevent leading zeroes from getting stripped on some numbers, as described on this ticket.

    I will have this improved in a bit. Your patience is greatly appreciated.

  • Profile Image
    Answered on November 11, 2013 at 11:47 AM


  • Profile Image
    Answered on November 11, 2013 at 03:22 PM
    Hello Neil
    I noticed that now the YEAR in one of my forms is now NUMBER format as I
    need, but the data in the matrix is still TEXT
    See my form NDI MONTHLY REPORT ... if possible, I need the data in this
    matrix to download to EXCEL as NUMBER format
  • Profile Image
    Answered on November 11, 2013 at 03:52 PM

    Thank you for your update.

    We will check this out and get back to you once we have any solution to the issue.

  • Profile Image
    Answered on November 11, 2013 at 10:47 PM

    Again, fixed. Sorry about that.

    By the way, I noticed that there are values like '00' on your spreadsheet. In cases like that, you must manually convert them to numbers -- I have updated our Excel generator to treat such values as TEXT because there are a lot of people who use leading zeroes in their fields.


  • Profile Image
    Answered on November 12, 2013 at 06:18 PM
    Thanks SO much …. The users that are inputting the data are not all ‘real tech savvy’ so occasionally they put in 00 or O when they have been instructed to enter a single 0
    However my crystal report ignores that in the tally so it’s all good

    Really appreciate the quick resolution

    Bill Dozier

  • Profile Image
    Answered on November 12, 2013 at 06:24 PM

    Hello Bill,

    In behalf of my Colleagues, you are most welcome! :)

    We are glad to be any help with your Jotform needs.

    Feel free to contact us anytime if you need further help.

    Thank you for using JotForm.