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

Reports/logs download in Excel format shows wrong time.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 1.8.2, 1.9.10, 2.0
    • 1.9.11, 2.0.1
    • Administration
    • CentOS Linux 4.6
    • MySQL
    • MOODLE_18_STABLE, MOODLE_19_STABLE, MOODLE_20_STABLE
    • MOODLE_19_STABLE, MOODLE_20_STABLE
    • Moderate

    Description

      I have identified a problem when I run a log report on student activity in in Moodle: the date/time in the "Display on Page" is different to what I "Download in Excel format".

      I discovered this when a lecturer asked to me find out when a student uploaded his assignment files. The "On page" showed he uploaded on Tuesday 13 May at 12:43am and 12:45am. The Downloaded excel file showed he submitted on 12 May at 14:43 and 14:45. (see attached excel file and screen shot). So I tried running another log for the same student on 19 May, and am getting the same pattern happening - the excel report I download shows minus 10 hours difference to what is displayed on the screen.

      I have opened the Excel download file in both Excel and OpenOffice, with the same result. The other display formats all do not have this problem (page, text and ODS).

      Does the fact that this behaviour can be reproduced in Excel and OO imply that the issue may be in the XLS file itself?

      Attachments

        1. patch.diff
          1 kB
        2. patch.txt
          1 kB

        Issue Links

          Activity

            People

              dongsheng Dongsheng Cai
              marleo Marcus Leonard
              David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              4 Vote for this issue
              Watchers:
              14 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                25/Dec/10