Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-31366

Feedback analysis Excel export: Ampersand wrongly handled

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.1.4, 2.6.4, 2.7.1, 2.8
    • Fix Version/s: 2.6.5, 2.7.2
    • Component/s: Feedback
    • Environment:
      RHEL 6.2, PHP 5.3.9, PostgreSQL 8.4
    • Database:
      PostgreSQL
    • Testing Instructions:
      Hide
      1. Create a feedback and add a Text field
      2. Respond to the feedback (can do this as admin/teacher) and include the characters & # in the response.
      3. click on the Analysis tab and hit the Export to Excel button
      4. Check to make sure the response listed in the excel file are not encoded. Should show & # as expected instead of 

        &

      Show
      Create a feedback and add a Text field Respond to the feedback (can do this as admin/teacher) and include the characters & # in the response. click on the Analysis tab and hit the Export to Excel button Check to make sure the response listed in the excel file are not encoded. Should show & # as expected instead of &
    • Affected Branches:
      MOODLE_21_STABLE, MOODLE_26_STABLE, MOODLE_27_STABLE, MOODLE_28_STABLE
    • Fixed Branches:
      MOODLE_26_STABLE, MOODLE_27_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      master_MDL-31366
    • Pull Master Diff URL:

      Description

      Entering an Ampersand (&) in a text field of in a Feedback (at least seen there), the symbol is correctly stored and seen in the analysis of the Feedback. But when you export to Excel, all ampersands get replaced by "&".

      Replication steps:

      1. Create a feedback with a Text field
      2. add an ampersand when replying the feedback
      3. See the analysis: Ampersand is there
      4. Export to Excel: Ampersand is replaced by &

        Attachments

          Issue Links

          Testing discovered

          Bug - A problem which impairs or prevents Moodle from functioning correctly. MDL-46454 Feedback textarea export converts newlines to html br

          • Minor - Minor loss of function where workaround is possible
          • Open

            Activity

              People

              Assignee:
              danmarsden Dan Marsden
              Reporter:
              matsimon Mat Simon
              Peer reviewer:
              Andrew Davis
              Integrator:
              Eloy Lafuente (stronk7)
              Tester:
              Jetha Chan
              Participants:
              Component watchers:
              Amaia Anabitarte, Carlos Escobedo, Ferran Recio, Sara Arjona (@sarjona), Víctor Déniz Falcón
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                8/Sep/14