- topsgtusmcAsked 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
- JotForm SupportNeilVicenteAnswered 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.
- JotForm SupportNeilVicenteAnswered on November 11, 2013 at 11:47 AM
- topsgtusmcAnswered on November 11, 2013 at 03:22 PMHello 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
- JotForm SupportMike_TAnswered 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.
- JotForm SupportNeilVicenteAnswered 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.
- topsgtusmcAnswered on November 12, 2013 at 06:18 PMThanks 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
- khrisellAnswered on November 12, 2013 at 06:24 PM
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.