What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Excel is cutting off part of the information in a cell

    Asked by bssrc on June 01, 2012 at 10:42 AM

    I have a form embeded in an iWeb site for users to submit an abstract.  One user notified me that the report she received from the automated notification email showed that part of the abstract was missing.  When I looked at the submission in "My Forms", the entire submission abstract was there.  However, when I downloaded either the Excel or the CSV files the abstract cell was incomplete.  I also noticed that the abstract was cut off right before a "<" symbol was used (to indicate aprobability value).  Excel does not seem to have a problem with the greater than or less than symbol in a cell (I put a few in and was able to save the file).  Is there a way to solve this issue?  Over the next few weeks I will be receiving many more submissions that are lekely to use "<", ">", "=" symbols and possibly others as well.  I've looked through the forum, but could not find this issue.  Thanks.

    Page URL:
    http://www.bssrc.org/17thbssrc/Submit_Oral.html

    Screenshot
  • Profile Image
    JotForm Support

    Answered by Mike_T on June 01, 2012 at 07:01 PM

    Thank you for contacting us.

    I have forwarded information about that bug to our Developers.

    The problem is related to < symbol and characters after that symbol. As a workaround you can Edit your submission(s) in order to add a space after that symbol, so that you will get all the data in your Excel spreadsheet.

    Example:

    use p< 0.01 or p < 0.01

    instead of p<0.01

    We will update this thread if we get any additional information for you.

  • Profile Image
    JotForm Support

    Answered by abajan on June 02, 2012 at 06:32 AM

    I suspect it's a security feature to prevent the injection of harmful scripts because HTML tags must begin with that element. That would explain why trailing content isn't stripped if a space is included. (To my knowledge, no valid HTML tags contain a space after that symbol.)

    If my assumption is correct, perhaps our developers can re-write that part of the form builder's code to be less restrictive by defining specific tags that are not allowed like script, for instance.