Details
Minor Description
If some response of results contains hundredths then we have wrong numbers in the exported excel file. See pictures.
Because we have the wrong symbol in /mod/feedback/analysis_to_excel.php:
$xlsformats->procent = $workbook->add_format(['align' => 'left', 'bold' => 1, 'v_align' => 'top', 'num_format' => '#,##0.00%']); |
Should be:
$xlsformats->procent = $workbook->add_format(['align' => 'left', 'bold' => 1, 'v_align' => 'top', 'num_format' => '#,##0.00']); |
Because in /lib/excellib.class.php we don't have any percents ('#,##0.00%'):
public function set_num_format($num_format) { |
$numbers = array();
|
|
|
$numbers[1] = '0'; |
$numbers[2] = '0.00'; |
$numbers[3] = '#,##0'; |
$numbers[4] = '#,##0.00'; |
$numbers[11] = '0.00E+00'; |
$numbers[12] = '# ?/?'; |
$numbers[13] = '# ??/??'; |
$numbers[14] = 'mm-dd-yy'; |
$numbers[15] = 'd-mmm-yy'; |
$numbers[16] = 'd-mmm'; |
$numbers[17] = 'mmm-yy'; |
$numbers[22] = 'm/d/yy h:mm'; |
$numbers[49] = '@'; |
