Excel is cutting off part of the information in a cell

  • Profile Image
    bssrc
    Asked 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.

  • Profile Image
    Mike_T
    Answered 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
    abajan
    Answered 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.