Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-36728

Export of student responses results in empty file if character count goes over Excel's limit

    Details

    • Type: Bug
    • Status: RESOLVED
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.0
    • Fix Version/s: 10.0
    • Labels:
      None
    • 2.9 Status:
      Merge
    • Previous Issue Keys:
      SAM-1719

      Description

      This is reported by Stanford (CW-2995):

      Lauren Cipriano, TA for F11-MS&E-193-01, reported that she tried to export the responses/scores from Homework Assignment #4 and ended up with an empty file. Karen let me know that Excel has a character limit of 32,767 for a cell. Our Short Answer/Essay question type has a 60,000 character limit. If just one student exceeds the character limit in Excel, which can be done with all the formatting tags that count towards the character count, the export will fail.

      I think we need to adjust the Short Answer/Essay character limit to 32,000 so there will be no more conflicts with Excel.

        Gliffy Diagrams

          Zeplin

            Attachments

            1. Assessment-SAM-1719-06112013.xls
              24 kB
            2. ExcelSheet.png
              ExcelSheet.png
              27 kB
            3. Instructor.png
              Instructor.png
              20 kB
            4. SAM-1719.patch
              5 kB
            5. Student1.png
              Student1.png
              40 kB

              Issue Links

                Activity

                  People

                  Assignee:
                  samigoteam SAMIGO TEAM (Inactive)
                  Reporter:
                  ktsao Karen Tsao
                  Votes:
                  1 Vote for this issue
                  Watchers:
                  4 Start watching this issue

                    Dates

                    Created:
                    Updated:
                    Resolved:

                      Git Integration