Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.3.x will end 7 October 2024 (12 months).
  • Bug fixes for security issues in 4.3.x will end 21 April 2025 (18 months).
  • PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.2.x is supported too.

Differences Between: [Versions 310 and 403] [Versions 311 and 403] [Versions 39 and 403] [Versions 400 and 403] [Versions 401 and 403]

   1  <?php
   2  // This file is part of Moodle - http://moodle.org/
   3  //
   4  // Moodle is free software: you can redistribute it and/or modify
   5  // it under the terms of the GNU General Public License as published by
   6  // the Free Software Foundation, either version 3 of the License, or
   7  // (at your option) any later version.
   8  //
   9  // Moodle is distributed in the hope that it will be useful,
  10  // but WITHOUT ANY WARRANTY; without even the implied warranty of
  11  // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  12  // GNU General Public License for more details.
  13  //
  14  // You should have received a copy of the GNU General Public License
  15  // along with Moodle.  If not, see <http://www.gnu.org/licenses/>.
  16  
  17  /**
  18   * ODS file writer.
  19   * The xml used here is derived from output of LibreOffice 3.6.4
  20   *
  21   * The design is based on Excel writer abstraction by Eloy Lafuente and others.
  22   *
  23   * @package   core
  24   * @copyright 2006 Petr Skoda {@link http://skodak.org}
  25   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  26   */
  27  
  28  defined('MOODLE_INTERNAL') || die();
  29  
  30  
  31  /**
  32   * ODS workbook abstraction.
  33   *
  34   * @package   core
  35   * @copyright 2006 Petr Skoda {@link http://skodak.org}
  36   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
  37   */
  38  class MoodleODSWorkbook {
  39      protected $worksheets = array();
  40      protected $filename;
  41  
  42      public function __construct($filename) {
  43          $this->filename = $filename;
  44      }
  45  
  46      /**
  47       * Create one Moodle Worksheet.
  48       *
  49       * @param string $name Name of the sheet
  50       * @return MoodleODSWorksheet
  51       */
  52      public function add_worksheet($name = '') {
  53          $ws = new MoodleODSWorksheet($name, $this->worksheets);
  54          $this->worksheets[] = $ws;
  55          return $ws;
  56      }
  57  
  58      /**
  59       * Create one Moodle Format.
  60       *
  61       * @param array $properties array of properties [name]=value;
  62       *                          valid names are set_XXXX existing
  63       *                          functions without the set_ part
  64       *                          i.e: [bold]=1 for set_bold(1)...Optional!
  65       * @return MoodleODSFormat
  66       */
  67      public function add_format($properties = array()) {
  68          return new MoodleODSFormat($properties);
  69      }
  70  
  71      /**
  72       * Close the Moodle Workbook.
  73       */
  74      public function close() {
  75          global $CFG;
  76          require_once($CFG->libdir . '/filelib.php');
  77  
  78          $writer = new MoodleODSWriter($this->worksheets);
  79          $contents = $writer->get_file_content();
  80  
  81          send_file($contents, $this->filename, 0, 0, true, true, $writer->get_ods_mimetype());
  82      }
  83  
  84      /**
  85       * Not required to use.
  86       * @param string $filename Name of the downloaded file
  87       */
  88      public function send($filename) {
  89          $this->filename = $filename;
  90      }
  91  
  92  }
  93  
  94  
  95  /**
  96   * ODS Cell abstraction.
  97   *
  98   * @package   core
  99   * @copyright 2013 Petr Skoda {@link http://skodak.org}
 100   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 101   */
 102  class MoodleODSCell {
 103      public $value;
 104      public $type;
 105      public $format;
 106      public $formula;
 107  }
 108  
 109  
 110  /**
 111   * ODS Worksheet abstraction.
 112   *
 113   * @package   core
 114   * @copyright 2006 Petr Skoda {@link http://skodak.org}
 115   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 116   */
 117  class MoodleODSWorksheet {
 118      public $data = array();
 119      public $columns = array();
 120      public $rows = array();
 121      public $showgrid = true;
 122      public $name;
 123      /** @var int Max number of rows in the sheet. */
 124      public $maxr = 0;
 125      /** @var int Max number of cols in the sheet. */
 126      public $maxc = 0;
 127  
 128      /**
 129       * Constructs one Moodle Worksheet.
 130       *
 131       * @param string $name The name of the file
 132       * @param array $worksheets existing worksheets
 133       */
 134      public function __construct($name, array $worksheets) {
 135          // Replace any characters in the name that Excel cannot cope with.
 136          $name = strtr($name, '[]*/\?:', '       ');
 137  
 138          if ($name === '') {
 139              // Name is required!
 140              $name = 'Sheet'.(count($worksheets)+1);
 141          }
 142  
 143          $this->name = $name;
 144      }
 145  
 146      /**
 147       * Write one string somewhere in the worksheet.
 148       *
 149       * @param integer $row    Zero indexed row
 150       * @param integer $col    Zero indexed column
 151       * @param string  $str    The string to write
 152       * @param mixed   $format The XF format for the cell
 153       */
 154      public function write_string($row, $col, $str, $format = null) {
 155          if (!isset($this->data[$row][$col])) {
 156              $this->data[$row][$col] = new MoodleODSCell();
 157          }
 158          if (is_array($format)) {
 159              $format = new MoodleODSFormat($format);
 160          }
 161          $this->data[$row][$col]->value = $str;
 162          $this->data[$row][$col]->type = 'string';
 163          $this->data[$row][$col]->format = $format;
 164          $this->data[$row][$col]->formula = null;
 165      }
 166  
 167      /**
 168       * Write one number somewhere in the worksheet.
 169       *
 170       * @param integer $row    Zero indexed row
 171       * @param integer $col    Zero indexed column
 172       * @param float   $num    The number to write
 173       * @param mixed   $format The XF format for the cell
 174       */
 175      public function write_number($row, $col, $num, $format = null) {
 176          if (!isset($this->data[$row][$col])) {
 177              $this->data[$row][$col] = new MoodleODSCell();
 178          }
 179          if (is_array($format)) {
 180              $format = new MoodleODSFormat($format);
 181          }
 182          $this->data[$row][$col]->value = $num;
 183          $this->data[$row][$col]->type = 'float';
 184          $this->data[$row][$col]->format = $format;
 185          $this->data[$row][$col]->formula = null;
 186      }
 187  
 188      /**
 189       * Write one url somewhere in the worksheet.
 190       *
 191       * @param integer $row    Zero indexed row
 192       * @param integer $col    Zero indexed column
 193       * @param string  $url    The url to write
 194       * @param mixed   $format The XF format for the cell
 195       */
 196      public function write_url($row, $col, $url, $format = null) {
 197          if (!isset($this->data[$row][$col])) {
 198              $this->data[$row][$col] = new MoodleODSCell();
 199          }
 200          if (is_array($format)) {
 201              $format = new MoodleODSFormat($format);
 202          }
 203          $this->data[$row][$col]->value = $url;
 204          $this->data[$row][$col]->type = 'string';
 205          $this->data[$row][$col]->format = $format;
 206          $this->data[$row][$col]->formula = null;
 207      }
 208  
 209      /**
 210       * Write one date somewhere in the worksheet.
 211       *
 212       * @param integer $row    Zero indexed row
 213       * @param integer $col    Zero indexed column
 214       * @param string  $date    The url to write
 215       * @param mixed   $format The XF format for the cell
 216       */
 217      public function write_date($row, $col, $date, $format = null) {
 218          if (!isset($this->data[$row][$col])) {
 219              $this->data[$row][$col] = new MoodleODSCell();
 220          }
 221          if (is_array($format)) {
 222              $format = new MoodleODSFormat($format);
 223          }
 224          $this->data[$row][$col]->value = $date;
 225          $this->data[$row][$col]->type = 'date';
 226          $this->data[$row][$col]->format = $format;
 227          $this->data[$row][$col]->formula = null;
 228      }
 229  
 230      /**
 231       * Write one formula somewhere in the worksheet.
 232       *
 233       * @param integer $row    Zero indexed row
 234       * @param integer $col    Zero indexed column
 235       * @param string  $formula The formula to write
 236       * @param mixed   $format The XF format for the cell
 237       */
 238      public function write_formula($row, $col, $formula, $format = null) {
 239          if (!isset($this->data[$row][$col])) {
 240              $this->data[$row][$col] = new MoodleODSCell();
 241          }
 242          if (is_array($format)) {
 243              $format = new MoodleODSFormat($format);
 244          }
 245          $this->data[$row][$col]->formula = $formula;
 246          $this->data[$row][$col]->format = $format;
 247          $this->data[$row][$col]->value = null;
 248          $this->data[$row][$col]->format = null;
 249      }
 250  
 251      /**
 252       * Write one blank somewhere in the worksheet.
 253       *
 254       * @param integer $row    Zero indexed row
 255       * @param integer $col    Zero indexed column
 256       * @param mixed   $format The XF format for the cell
 257       */
 258      public function write_blank($row, $col, $format = null) {
 259          if (is_array($format)) {
 260              $format = new MoodleODSFormat($format);
 261          }
 262          $this->write_string($row, $col, '', $format);
 263      }
 264  
 265      /**
 266       * Write anything somewhere in the worksheet,
 267       * type will be automatically detected.
 268       *
 269       * @param integer $row    Zero indexed row
 270       * @param integer $col    Zero indexed column
 271       * @param mixed   $token  What we are writing
 272       * @param mixed   $format The XF format for the cell
 273       */
 274      public function write($row, $col, $token, $format = null) {
 275          // Analyse what are we trying to send.
 276          if (preg_match("/^([+-]?)(?=\d|\.\d)\d*(\.\d*)?([Ee]([+-]?\d+))?$/", $token)) {
 277              // Match number
 278              return $this->write_number($row, $col, $token, $format);
 279          } elseif (preg_match("/^[fh]tt?p:\/\//", $token)) {
 280              // Match http or ftp URL
 281              return $this->write_url($row, $col, $token, '', $format);
 282          } elseif (preg_match("/^mailto:/", $token)) {
 283              // Match mailto:
 284              return $this->write_url($row, $col, $token, '', $format);
 285          } elseif (preg_match("/^(?:in|ex)ternal:/", $token)) {
 286              // Match internal or external sheet link
 287              return $this->write_url($row, $col, $token, '', $format);
 288          } elseif (preg_match("/^=/", $token)) {
 289              // Match formula
 290              return $this->write_formula($row, $col, $token, $format);
 291          } elseif (preg_match("/^@/", $token)) {
 292              // Match formula
 293              return $this->write_formula($row, $col, $token, $format);
 294          } elseif ($token == '') {
 295              // Match blank
 296              return $this->write_blank($row, $col, $format);
 297          } else {
 298              // Default: match string
 299              return $this->write_string($row, $col, $token, $format);
 300          }
 301      }
 302  
 303      /**
 304       * Sets the height (and other settings) of one row.
 305       *
 306       * @param integer $row    The row to set
 307       * @param integer $height Height we are giving to the row (null to set just format without setting the height)
 308       * @param mixed   $format The optional format we are giving to the row
 309       * @param bool    $hidden The optional hidden attribute
 310       * @param integer $level  The optional outline level (0-7)
 311       */
 312      public function set_row($row, $height, $format = null, $hidden = false, $level = 0) {
 313          if (is_array($format)) {
 314              $format = new MoodleODSFormat($format);
 315          }
 316          if ($level < 0) {
 317              $level = 0;
 318          } else if ($level > 7) {
 319              $level = 7;
 320          }
 321          if (!isset($this->rows[$row])) {
 322              $this->rows[$row] = new stdClass();
 323          }
 324          if (isset($height)) {
 325              $this->rows[$row]->height = $height;
 326          }
 327          $this->rows[$row]->format = $format;
 328          $this->rows[$row]->hidden = $hidden;
 329          $this->rows[$row]->level  = $level;
 330      }
 331  
 332      /**
 333       * Sets the width (and other settings) of one column.
 334       *
 335       * @param integer $firstcol first column on the range
 336       * @param integer $lastcol  last column on the range
 337       * @param integer $width    width to set (null to set just format without setting the width)
 338       * @param mixed   $format   The optional format to apply to the columns
 339       * @param bool    $hidden   The optional hidden attribute
 340       * @param integer $level    The optional outline level (0-7)
 341       */
 342      public function set_column($firstcol, $lastcol, $width, $format = null, $hidden = false, $level = 0) {
 343          if (is_array($format)) {
 344              $format = new MoodleODSFormat($format);
 345          }
 346          if ($level < 0) {
 347              $level = 0;
 348          } else if ($level > 7) {
 349              $level = 7;
 350          }
 351          for($i=$firstcol; $i<=$lastcol; $i++) {
 352              if (!isset($this->columns[$i])) {
 353                  $this->columns[$i] = new stdClass();
 354              }
 355              if (isset($width)) {
 356                  $this->columns[$i]->width = $width*6.15; // 6.15 is a magic constant here!
 357              }
 358              $this->columns[$i]->format = $format;
 359              $this->columns[$i]->hidden = $hidden;
 360              $this->columns[$i]->level  = $level;
 361          }
 362      }
 363  
 364      /**
 365       * Set the option to hide gridlines on the printed page.
 366       */
 367      public function hide_gridlines() {
 368          // Not implemented - always off.
 369      }
 370  
 371      /**
 372       * Set the option to hide gridlines on the worksheet (as seen on the screen).
 373       */
 374      public function hide_screen_gridlines() {
 375          $this->showgrid = false;
 376      }
 377  
 378      /**
 379       * Insert a 24bit bitmap image in a worksheet.
 380       *
 381       * @param integer $row     The row we are going to insert the bitmap into
 382       * @param integer $col     The column we are going to insert the bitmap into
 383       * @param string  $bitmap  The bitmap filename
 384       * @param integer $x       The horizontal position (offset) of the image inside the cell.
 385       * @param integer $y       The vertical position (offset) of the image inside the cell.
 386       * @param integer $scale_x The horizontal scale
 387       * @param integer $scale_y The vertical scale
 388       */
 389      public function insert_bitmap($row, $col, $bitmap, $x = 0, $y = 0, $scale_x = 1, $scale_y = 1) {
 390          // Not implemented.
 391      }
 392  
 393      /**
 394       * Merges the area given by its arguments.
 395       *
 396       * @param integer $first_row First row of the area to merge
 397       * @param integer $first_col First column of the area to merge
 398       * @param integer $last_row  Last row of the area to merge
 399       * @param integer $last_col  Last column of the area to merge
 400       */
 401      public function merge_cells($first_row, $first_col, $last_row, $last_col) {
 402          if ($first_row > $last_row or $first_col > $last_col) {
 403              return;
 404          }
 405  
 406          if (!isset($this->data[$first_row][$first_col])) {
 407              $this->data[$first_row][$first_col] = new MoodleODSCell();
 408          }
 409  
 410          $this->data[$first_row][$first_col]->merge = array('rows'=>($last_row-$first_row+1), 'columns'=>($last_col-$first_col+1));
 411      }
 412  }
 413  
 414  
 415  /**
 416   * ODS cell format abstraction.
 417   *
 418   * @package   core
 419   * @copyright 2006 Petr Skoda {@link http://skodak.org}
 420   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 421   */
 422  class MoodleODSFormat {
 423      public $id;
 424      public $properties = array();
 425  
 426      /**
 427       * Constructs one Moodle Format.
 428       *
 429       * @param array $properties
 430       */
 431      public function __construct($properties = array()) {
 432          static $fid = 1;
 433  
 434          $this->id = $fid++;
 435  
 436          foreach($properties as $property => $value) {
 437              if (method_exists($this, "set_$property")) {
 438                  $aux = 'set_'.$property;
 439                  $this->$aux($value);
 440              }
 441          }
 442      }
 443  
 444      /**
 445       * Set the size of the text in the format (in pixels).
 446       * By default all texts in generated sheets are 10pt.
 447       *
 448       * @param integer $size Size of the text (in points)
 449       */
 450      public function set_size($size) {
 451          $this->properties['size'] = $size;
 452      }
 453  
 454      /**
 455       * Set weight of the format.
 456       *
 457       * @param integer $weight Weight for the text, 0 maps to 400 (normal text),
 458       *                        1 maps to 700 (bold text). Valid range is: 100-1000.
 459       *                        It's Optional, default is 1 (bold).
 460       */
 461      public function set_bold($weight = 1) {
 462          if ($weight == 1) {
 463              $weight = 700;
 464          }
 465          $this->properties['bold'] = ($weight > 400);
 466      }
 467  
 468      /**
 469       * Set underline of the format.
 470       *
 471       * @param integer $underline The value for underline. Possible values are:
 472       *                           1 => underline, 2 => double underline
 473       */
 474      public function set_underline($underline = 1) {
 475          if ($underline == 1) {
 476              $this->properties['underline'] = 1;
 477          } else if ($underline == 2) {
 478              $this->properties['underline'] = 2;
 479          } else {
 480              unset($this->properties['underline']);
 481          }
 482      }
 483  
 484      /**
 485       * Set italic of the format.
 486       */
 487      public function set_italic() {
 488          $this->properties['italic'] = true;
 489      }
 490  
 491      /**
 492       * Set strikeout of the format
 493       */
 494      public function set_strikeout() {
 495          $this->properties['strikeout'] = true;
 496      }
 497  
 498      /**
 499       * Set outlining of the format.
 500       */
 501      public function set_outline() {
 502          // Not implemented.
 503      }
 504  
 505      /**
 506       * Set shadow of the format.
 507       */
 508      public function set_shadow() {
 509          // Not implemented.
 510      }
 511  
 512      /**
 513       * Set the script of the text.
 514       *
 515       * @param integer $script The value for script type. Possible values are:
 516       *                        1 => superscript, 2 => subscript
 517       */
 518      public function set_script($script) {
 519          if ($script == 1) {
 520              $this->properties['super_script'] = true;
 521              unset($this->properties['sub_script']);
 522  
 523          } else if ($script == 2) {
 524              $this->properties['sub_script'] = true;
 525              unset($this->properties['super_script']);
 526  
 527          } else {
 528              unset($this->properties['sub_script']);
 529              unset($this->properties['super_script']);
 530          }
 531      }
 532  
 533      /**
 534       * Set color of the format.
 535       *
 536       * @param mixed $color either a string (like 'blue'), or an integer (range is [8...63])
 537       */
 538      public function set_color($color) {
 539          $this->properties['color'] = $this->parse_color($color);
 540      }
 541  
 542      /**
 543       * Not used.
 544       *
 545       * @param mixed $color
 546       */
 547      public function set_fg_color($color) {
 548          // Not implemented.
 549      }
 550  
 551      /**
 552       * Set background color of the cell.
 553       *
 554       * @param mixed $color either a string (like 'blue'), or an integer (range is [8...63])
 555       */
 556      public function set_bg_color($color) {
 557          $this->properties['bg_color'] = $this->parse_color($color);
 558      }
 559  
 560      /**
 561       * Set the cell fill pattern.
 562       *
 563       * @deprecated use set_bg_color() instead.
 564       * @param integer
 565       */
 566      public function set_pattern($pattern=1) {
 567          if ($pattern > 0) {
 568              if (!isset($this->properties['bg_color'])) {
 569                  $this->properties['bg_color'] = $this->parse_color('black');
 570              }
 571          } else {
 572              unset($this->properties['bg_color']);
 573          }
 574  
 575      }
 576  
 577      /**
 578       * Set text wrap of the format
 579       */
 580      public function set_text_wrap() {
 581          $this->properties['wrap'] = true;
 582      }
 583  
 584      /**
 585       * Set the cell alignment of the format.
 586       *
 587       * @param string $location alignment for the cell ('left', 'right', 'justify', etc...)
 588       */
 589      public function set_align($location) {
 590          if (in_array($location, array('left', 'centre', 'center', 'right', 'fill', 'merge', 'justify', 'equal_space'))) {
 591              $this->set_h_align($location);
 592  
 593          } else if (in_array($location, array('top', 'vcentre', 'vcenter', 'bottom', 'vjustify', 'vequal_space'))) {
 594              $this->set_v_align($location);
 595          }
 596      }
 597  
 598      /**
 599       * Set the cell horizontal alignment of the format.
 600       *
 601       * @param string $location alignment for the cell ('left', 'right', 'justify', etc...)
 602       */
 603      public function set_h_align($location) {
 604          switch ($location) {
 605              case 'left':
 606                  $this->properties['align'] = 'start';
 607                  break;
 608              case 'center':
 609              case 'centre':
 610              $this->properties['align'] = 'center';
 611                  break;
 612              case 'right':
 613                  $this->properties['align'] = 'end';
 614                  break;
 615          }
 616      }
 617  
 618      /**
 619       * Set the cell vertical alignment of the format.
 620       *
 621       * @param string $location alignment for the cell ('top', 'bottom', 'center', 'justify')
 622       */
 623      public function set_v_align($location) {
 624          switch ($location) {
 625              case 'top':
 626                  $this->properties['v_align'] = 'top';
 627                  break;
 628              case 'vcentre':
 629              case 'vcenter':
 630              case 'centre':
 631              case 'center':
 632                  $this->properties['v_align'] = 'middle';
 633                  break;
 634              default:
 635                  $this->properties['v_align'] = 'bottom';
 636          }
 637      }
 638  
 639      /**
 640       * Set the top border of the format.
 641       *
 642       * @param integer $style style for the cell. 1 => thin, 2 => thick
 643       */
 644      public function set_top($style) {
 645          if ($style == 1) {
 646              $style = 0.2;
 647          } else if ($style == 2) {
 648              $style = 0.5;
 649          } else {
 650              return;
 651          }
 652          $this->properties['border_top'] = $style;
 653      }
 654  
 655      /**
 656       * Set the bottom border of the format.
 657       *
 658       * @param integer $style style for the cell. 1 => thin, 2 => thick
 659       */
 660      public function set_bottom($style) {
 661          if ($style == 1) {
 662              $style = 0.2;
 663          } else if ($style == 2) {
 664              $style = 0.5;
 665          } else {
 666              return;
 667          }
 668          $this->properties['border_bottom'] = $style;
 669      }
 670  
 671      /**
 672       * Set the left border of the format.
 673       *
 674       * @param integer $style style for the cell. 1 => thin, 2 => thick
 675       */
 676      public function set_left($style) {
 677          if ($style == 1) {
 678              $style = 0.2;
 679          } else if ($style == 2) {
 680              $style = 0.5;
 681          } else {
 682              return;
 683          }
 684          $this->properties['border_left'] = $style;
 685      }
 686  
 687      /**
 688       * Set the right border of the format.
 689       *
 690       * @param integer $style style for the cell. 1 => thin, 2 => thick
 691       */
 692      public function set_right($style) {
 693          if ($style == 1) {
 694              $style = 0.2;
 695          } else if ($style == 2) {
 696              $style = 0.5;
 697          } else {
 698              return;
 699          }
 700          $this->properties['border_right'] = $style;
 701      }
 702  
 703      /**
 704       * Set cells borders to the same style
 705       * @param integer $style style to apply for all cell borders. 1 => thin, 2 => thick.
 706       */
 707      public function set_border($style) {
 708          $this->set_top($style);
 709          $this->set_bottom($style);
 710          $this->set_left($style);
 711          $this->set_right($style);
 712      }
 713  
 714      /**
 715       * Set the numerical format of the format.
 716       * It can be date, time, currency, etc...
 717       *
 718       * @param mixed $num_format The numeric format
 719       */
 720      public function set_num_format($num_format) {
 721  
 722          $numbers = array();
 723  
 724          $numbers[1] = '0';
 725          $numbers[2] = '0.00';
 726          $numbers[3] = '#,##0';
 727          $numbers[4] = '#,##0.00';
 728          $numbers[11] = '0.00E+00';
 729          $numbers[12] = '# ?/?';
 730          $numbers[13] = '# ??/??';
 731          $numbers[14] = 'mm-dd-yy';
 732          $numbers[15] = 'd-mmm-yy';
 733          $numbers[16] = 'd-mmm';
 734          $numbers[17] = 'mmm-yy';
 735          $numbers[22] = 'm/d/yy h:mm';
 736          $numbers[49] = '@';
 737  
 738          if ($num_format !== 0 and in_array($num_format, $numbers)) {
 739              $flipped = array_flip($numbers);
 740              $this->properties['num_format'] = $flipped[$num_format];
 741          }
 742          if (!isset($numbers[$num_format])) {
 743              return;
 744          }
 745  
 746          $this->properties['num_format'] = $num_format;
 747      }
 748  
 749      /**
 750       * Standardise colour name.
 751       *
 752       * @param mixed $color name of the color (i.e.: 'blue', 'red', etc..), or an integer (range is [8...63]).
 753       * @return string the RGB color value
 754       */
 755      protected function parse_color($color) {
 756          if (strpos($color, '#') === 0) {
 757              // No conversion should be needed.
 758              return $color;
 759          }
 760  
 761          if ($color > 7 and $color < 53) {
 762              $numbers = array(
 763                  8  => 'black',
 764                  12 => 'blue',
 765                  16 => 'brown',
 766                  15 => 'cyan',
 767                  23 => 'gray',
 768                  17 => 'green',
 769                  11 => 'lime',
 770                  14 => 'magenta',
 771                  18 => 'navy',
 772                  53 => 'orange',
 773                  33 => 'pink',
 774                  20 => 'purple',
 775                  10 => 'red',
 776                  22 => 'silver',
 777                  9  => 'white',
 778                  13 => 'yellow',
 779              );
 780              if (isset($numbers[$color])) {
 781                  $color = $numbers[$color];
 782              } else {
 783                  $color = 'black';
 784              }
 785          }
 786  
 787          $colors = array(
 788              'aqua'    => '00FFFF',
 789              'black'   => '000000',
 790              'blue'    => '0000FF',
 791              'brown'   => 'A52A2A',
 792              'cyan'    => '00FFFF',
 793              'fuchsia' => 'FF00FF',
 794              'gray'    => '808080',
 795              'grey'    => '808080',
 796              'green'   => '00FF00',
 797              'lime'    => '00FF00',
 798              'magenta' => 'FF00FF',
 799              'maroon'  => '800000',
 800              'navy'    => '000080',
 801              'orange'  => 'FFA500',
 802              'olive'   => '808000',
 803              'pink'    => 'FAAFBE',
 804              'purple'  => '800080',
 805              'red'     => 'FF0000',
 806              'silver'  => 'C0C0C0',
 807              'teal'    => '008080',
 808              'white'   => 'FFFFFF',
 809              'yellow'  => 'FFFF00',
 810          );
 811  
 812          if (isset($colors[$color])) {
 813              return('#'.$colors[$color]);
 814          }
 815  
 816          return('#'.$colors['black']);
 817      }
 818  }
 819  
 820  
 821  /**
 822   * ODS file writer.
 823   *
 824   * @package   core
 825   * @copyright 2013 Petr Skoda {@link http://skodak.org}
 826   * @license   http://www.gnu.org/copyleft/gpl.html GNU GPL v3 or later
 827   */
 828  class MoodleODSWriter {
 829      protected $worksheets;
 830  
 831      public function __construct(array $worksheets) {
 832          $this->worksheets = $worksheets;
 833      }
 834  
 835      /**
 836       * Fetch the file ocntnet for the ODS.
 837       *
 838       * @return string
 839       */
 840      public function get_file_content() {
 841          $dir = make_request_directory();
 842          $filename = $dir . '/result.ods';
 843  
 844          $files = [
 845                  'mimetype'              => [$this->get_ods_mimetype()],
 846                  'content.xml'           => [$this->get_ods_content($this->worksheets)],
 847                  'meta.xml'              => [$this->get_ods_meta()],
 848                  'styles.xml'            => [$this->get_ods_styles()],
 849                  'settings.xml'          => [$this->get_ods_settings()],
 850                  'META-INF/manifest.xml' => [$this->get_ods_manifest()],
 851              ];
 852  
 853          $packer = get_file_packer('application/zip');
 854          $packer->archive_to_pathname($files, $filename);
 855  
 856          $contents = file_get_contents($filename);
 857  
 858          remove_dir($dir);
 859          return $contents;
 860      }
 861  
 862      protected function get_ods_content() {
 863  
 864          // Find out the size of worksheets and used styles.
 865          $formats = array();
 866          $formatstyles = '';
 867          $rowstyles = '';
 868          $colstyles = '';
 869  
 870          foreach($this->worksheets as $wsnum=>$ws) {
 871              foreach($ws->data as $rnum=>$row) {
 872                  if ($rnum > $this->worksheets[$wsnum]->maxr) {
 873                      $this->worksheets[$wsnum]->maxr = $rnum;
 874                  }
 875                  foreach($row as $cnum=>$cell) {
 876                      if ($cnum > $this->worksheets[$wsnum]->maxc) {
 877                          $this->worksheets[$wsnum]->maxc = $cnum;
 878                      }
 879                      if (!empty($cell->format)) {
 880                          if (!array_key_exists($cell->format->id, $formats)) {
 881                              $formats[$cell->format->id] = $cell->format;
 882                          }
 883                      }
 884                  }
 885              }
 886  
 887              foreach($ws->rows as $rnum=>$row) {
 888                  if (!empty($row->format)) {
 889                      if (!array_key_exists($row->format->id, $formats)) {
 890                          $formats[$row->format->id] = $row->format;
 891                      }
 892                  }
 893                  if ($rnum > $this->worksheets[$wsnum]->maxr) {
 894                      $this->worksheets[$wsnum]->maxr = $rnum;
 895                  }
 896                  // Define all column styles.
 897                  if (!empty($ws->rows[$rnum])) {
 898                      $rowstyles .= '<style:style style:name="ws'.$wsnum.'ro'.$rnum.'" style:family="table-row">';
 899                      if (isset($row->height)) {
 900                          $rowstyles .= '<style:table-row-properties style:row-height="'.$row->height.'pt"/>';
 901                      }
 902                      $rowstyles .= '</style:style>';
 903                  }
 904              }
 905  
 906              foreach($ws->columns as $cnum=>$col) {
 907                  if (!empty($col->format)) {
 908                      if (!array_key_exists($col->format->id, $formats)) {
 909                          $formats[$col->format->id] = $col->format;
 910                      }
 911                  }
 912                  if ($cnum > $this->worksheets[$wsnum]->maxc) {
 913                      $this->worksheets[$wsnum]->maxc = $cnum;
 914                  }
 915                  // Define all column styles.
 916                  if (!empty($ws->columns[$cnum])) {
 917                      $colstyles .= '<style:style style:name="ws'.$wsnum.'co'.$cnum.'" style:family="table-column">';
 918                      if (isset($col->width)) {
 919                          $colstyles .= '<style:table-column-properties style:column-width="'.$col->width.'pt"/>';
 920                      }
 921                      $colstyles .= '</style:style>';
 922                  }
 923              }
 924          }
 925  
 926          foreach($formats as $format) {
 927              $textprop = '';
 928              $cellprop = '';
 929              $parprop  = '';
 930              $dataformat = '';
 931              foreach($format->properties as $pname=>$pvalue) {
 932                  switch ($pname) {
 933                      case 'size':
 934                          if (!empty($pvalue)) {
 935                              $textprop .= ' fo:font-size="'.$pvalue.'pt"';
 936                          }
 937                          break;
 938                      case 'bold':
 939                          if (!empty($pvalue)) {
 940                              $textprop .= ' fo:font-weight="bold"';
 941                          }
 942                          break;
 943                      case 'italic':
 944                          if (!empty($pvalue)) {
 945                              $textprop .= ' fo:font-style="italic"';
 946                          }
 947                          break;
 948                      case 'underline':
 949                          if (!empty($pvalue)) {
 950                              $textprop .= ' style:text-underline-color="font-color" style:text-underline-style="solid" style:text-underline-width="auto"';
 951                              if ($pvalue == 2) {
 952                                  $textprop .= ' style:text-underline-type="double"';
 953                              }
 954                          }
 955                          break;
 956                      case 'strikeout':
 957                          if (!empty($pvalue)) {
 958                              $textprop .= ' style:text-line-through-style="solid"';
 959                          }
 960                          break;
 961                      case 'color':
 962                          if ($pvalue !== false) {
 963                              $textprop .= ' fo:color="'.$pvalue.'"';
 964                          }
 965                          break;
 966                      case 'bg_color':
 967                          if ($pvalue !== false) {
 968                              $cellprop .= ' fo:background-color="'.$pvalue.'"';
 969                          }
 970                          break;
 971                      case 'align':
 972                          $parprop .= ' fo:text-align="'.$pvalue.'"';
 973                          break;
 974                      case 'v_align':
 975                          $cellprop .= ' style:vertical-align="'.$pvalue.'"';
 976                          break;
 977                      case 'wrap':
 978                          if ($pvalue) {
 979                              $cellprop .= ' fo:wrap-option="wrap"';
 980                          }
 981                          break;
 982                      case 'border_top':
 983                          $cellprop .= ' fo:border-top="'.$pvalue.'pt solid #000000"';
 984                          break;
 985                      case 'border_left':
 986                          $cellprop .= ' fo:border-left="'.$pvalue.'pt solid #000000"';
 987                          break;
 988                      case 'border_bottom':
 989                          $cellprop .= ' fo:border-bottom="'.$pvalue.'pt solid #000000"';
 990                          break;
 991                      case 'border_right':
 992                          $cellprop .= ' fo:border-right="'.$pvalue.'pt solid #000000"';
 993                          break;
 994                      case 'num_format':
 995                          $dataformat = ' style:data-style-name="NUM'.$pvalue.'"';
 996                          break;
 997                  }
 998              }
 999              if (!empty($textprop)) {
1000                  $textprop = '
1001     <style:text-properties'.$textprop.'/>';
1002              }
1003  
1004              if (!empty($cellprop)) {
1005                  $cellprop = '
1006     <style:table-cell-properties'.$cellprop.'/>';
1007              }
1008  
1009              if (!empty($parprop)) {
1010                  $parprop = '
1011     <style:paragraph-properties'.$parprop.'/>';
1012              }
1013  
1014              $formatstyles .= '
1015    <style:style style:name="format'.$format->id.'" style:family="table-cell"'.$dataformat.'>'.$textprop.$cellprop.$parprop.'
1016    </style:style>';
1017          }
1018  
1019          // The text styles may be breaking older ODF validators.
1020          $scriptstyles ='
1021    <style:style style:name="T1" style:family="text">
1022      <style:text-properties style:text-position="33% 58%"/>
1023    </style:style>
1024    <style:style style:name="T2" style:family="text">
1025      <style:text-properties style:text-position="-33% 58%"/>
1026    </style:style>
1027  ';
1028          // Header.
1029          $buffer =
1030  '<?xml version="1.0" encoding="UTF-8"?>
1031  <office:document-content xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0"
1032                           xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0"
1033                           xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0"
1034                           xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0"
1035                           xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0"
1036                           xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0"
1037                           xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/"
1038                           xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0"
1039                           xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0"
1040                           xmlns:presentation="urn:oasis:names:tc:opendocument:xmlns:presentation:1.0"
1041                           xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0"
1042                           xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0"
1043                           xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0"
1044                           xmlns:math="http://www.w3.org/1998/Math/MathML"
1045                           xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0"
1046                           xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0"
1047                           xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer"
1048                           xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dom="http://www.w3.org/2001/xml-events"
1049                           xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema"
1050                           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
1051                           xmlns:rpt="http://openoffice.org/2005/report"
1052                           xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2"
1053                           xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#"
1054                           xmlns:tableooo="http://openoffice.org/2009/table"
1055                           xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0"
1056                           xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0"
1057                           xmlns:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0"
1058                           xmlns:css3t="http://www.w3.org/TR/css3-text/" office:version="1.2">
1059    <office:scripts/>
1060    <office:font-face-decls>
1061      <style:font-face style:name="Arial" svg:font-family="Arial" style:font-family-generic="swiss"
1062                       style:font-pitch="variable"/>
1063      <style:font-face style:name="Arial Unicode MS" svg:font-family="&apos;Arial Unicode MS&apos;"
1064                       style:font-family-generic="system" style:font-pitch="variable"/>
1065      <style:font-face style:name="Tahoma" svg:font-family="Tahoma" style:font-family-generic="system"
1066                       style:font-pitch="variable"/>
1067    </office:font-face-decls>
1068    <office:automatic-styles>';
1069          $buffer .= $this->get_num_styles();
1070          $buffer .= '
1071      <style:style style:name="ta1" style:family="table" style:master-page-name="Standard1">
1072        <style:table-properties table:display="true"/>
1073      </style:style>';
1074  
1075          $buffer .= $formatstyles;
1076          $buffer .= $rowstyles;
1077          $buffer .= $colstyles;
1078          $buffer .= $scriptstyles;
1079  
1080           $buffer .= '
1081    </office:automatic-styles>
1082    <office:body>
1083      <office:spreadsheet>
1084  ';
1085  
1086          foreach($this->worksheets as $wsnum=>$ws) {
1087  
1088              // Worksheet header.
1089              $buffer .= '<table:table table:name="' . htmlspecialchars($ws->name, ENT_QUOTES, 'utf-8') . '" table:style-name="ta1">'."\n";
1090  
1091              // Define column properties.
1092              $level = 0;
1093              for($c=0; $c<=$ws->maxc; $c++) {
1094                  if (array_key_exists($c, $ws->columns)) {
1095                      $column = $ws->columns[$c];
1096                      if ($column->level > $level) {
1097                          while ($column->level > $level) {
1098                              $buffer .= '<table:table-column-group>';
1099                              $level++;
1100                          }
1101                      } else if ($column->level < $level) {
1102                          while ($column->level < $level) {
1103                              $buffer .= '</table:table-column-group>';
1104                              $level--;
1105                          }
1106                      }
1107                      $extra = '';
1108                      if (!empty($column->format)) {
1109                          $extra .= ' table:default-cell-style-name="format'.$column->format->id.'"';
1110                      }
1111                      if ($column->hidden) {
1112                          $extra .= ' table:visibility="collapse"';
1113                      }
1114                      $buffer .= '<table:table-column table:style-name="ws'.$wsnum.'co'.$c.'"'.$extra.'/>'."\n";
1115                  } else {
1116                      while ($level > 0) {
1117                          $buffer .= '</table:table-column-group>';
1118                          $level--;
1119                      }
1120                      $buffer .= '<table:table-column/>'."\n";
1121                  }
1122              }
1123              while ($level > 0) {
1124                  $buffer .= '</table:table-column-group>';
1125                  $level--;
1126              }
1127  
1128              // Print all rows.
1129              $level = 0;
1130              for($r=0; $r<=$ws->maxr; $r++) {
1131                  if (array_key_exists($r, $ws->rows)) {
1132                      $row = $ws->rows[$r];
1133                      if ($row->level > $level) {
1134                          while ($row->level > $level) {
1135                              $buffer .= '<table:table-row-group>';
1136                              $level++;
1137                          }
1138                      } else if ($row->level < $level) {
1139                          while ($row->level < $level) {
1140                              $buffer .= '</table:table-row-group>';
1141                              $level--;
1142                          }
1143                      }
1144                      $extra = '';
1145                      if (!empty($row->format)) {
1146                          $extra .= ' table:default-cell-style-name="format'.$row->format->id.'"';
1147                      }
1148                      if ($row->hidden) {
1149                          $extra .= ' table:visibility="collapse"';
1150                      }
1151                      $buffer .= '<table:table-row table:style-name="ws'.$wsnum.'ro'.$r.'"'.$extra.'>'."\n";
1152                  } else {
1153                      while ($level > 0) {
1154                          $buffer .= '</table:table-row-group>';
1155                          $level--;
1156                      }
1157                      $buffer .= '<table:table-row>'."\n";
1158                  }
1159                  for($c=0; $c<=$ws->maxc; $c++) {
1160                      if (isset($ws->data[$r][$c])) {
1161                          $cell = $ws->data[$r][$c];
1162                          $extra = '';
1163                          if (!empty($cell->format)) {
1164                              $extra .= ' table:style-name="format'.$cell->format->id.'"';
1165                          }
1166                          if (!empty($cell->merge)) {
1167                              $extra .= ' table:number-columns-spanned="'.$cell->merge['columns'].'" table:number-rows-spanned="'.$cell->merge['rows'].'"';
1168                          }
1169                          $pretext = '<text:p>';
1170                          $posttext = '</text:p>';
1171                          if (!empty($cell->format->properties['sub_script'])) {
1172                              $pretext = $pretext.'<text:span text:style-name="T2">';
1173                              $posttext = '</text:span>'.$posttext;
1174                          } else if (!empty($cell->format->properties['super_script'])) {
1175                              $pretext = $pretext.'<text:span text:style-name="T1">';
1176                              $posttext = '</text:span>'.$posttext;
1177                          }
1178  
1179                          if (isset($cell->formula)) {
1180                              $buffer .= '<table:table-cell table:formula="of:'.$cell->formula.'"'.$extra.'></table:table-cell>'."\n";
1181                          } else if ($cell->type == 'date') {
1182                              $buffer .= '<table:table-cell office:value-type="date" office:date-value="' . date("Y-m-d\\TH:i:s", $cell->value) . '"'.$extra.'>'
1183                                       . $pretext . date("Y-m-d\\TH:i:s", $cell->value) . $posttext
1184                                       . '</table:table-cell>'."\n";
1185                          } else if ($cell->type == 'float') {
1186                              $buffer .= '<table:table-cell office:value-type="float" office:value="' . htmlspecialchars($cell->value, ENT_QUOTES, 'utf-8') . '"'.$extra.'>'
1187                                       . $pretext . htmlspecialchars($cell->value, ENT_QUOTES, 'utf-8') . $posttext
1188                                       . '</table:table-cell>'."\n";
1189                          } else if ($cell->type == 'string') {
1190                              $buffer .= '<table:table-cell office:value-type="string"'.$extra.'>'
1191                                       . $pretext . htmlspecialchars($cell->value, ENT_QUOTES, 'utf-8') . $posttext
1192                                       . '</table:table-cell>'."\n";
1193                          } else {
1194                              $buffer .= '<table:table-cell office:value-type="string"'.$extra.'>'
1195                                       . $pretext . '!!Error - unknown type!!' . $posttext
1196                                       . '</table:table-cell>'."\n";
1197                          }
1198                      } else {
1199                          $buffer .= '<table:table-cell/>'."\n";
1200                      }
1201                  }
1202                  $buffer .= '</table:table-row>'."\n";
1203              }
1204              while ($level > 0) {
1205                  $buffer .= '</table:table-row-group>';
1206                  $level--;
1207              }
1208              $buffer .= '</table:table>'."\n";
1209  
1210          }
1211  
1212          // Footer.
1213          $buffer .= '
1214      </office:spreadsheet>
1215    </office:body>
1216  </office:document-content>';
1217  
1218          return $buffer;
1219      }
1220  
1221      public function get_ods_mimetype() {
1222          return 'application/vnd.oasis.opendocument.spreadsheet';
1223      }
1224  
1225      protected function get_ods_settings() {
1226          $buffer =
1227  '<?xml version="1.0" encoding="UTF-8"?>
1228  <office:document-settings xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0"
1229                            xmlns:xlink="http://www.w3.org/1999/xlink"
1230                            xmlns:config="urn:oasis:names:tc:opendocument:xmlns:config:1.0"
1231                            xmlns:ooo="http://openoffice.org/2004/office" office:version="1.2">
1232      <office:settings>
1233        <config:config-item-set config:name="ooo:view-settings">
1234          <config:config-item config:name="VisibleAreaTop" config:type="int">0</config:config-item>
1235          <config:config-item config:name="VisibleAreaLeft" config:type="int">0</config:config-item>
1236          <config:config-item-map-indexed config:name="Views">
1237            <config:config-item-map-entry>
1238              <config:config-item config:name="ViewId" config:type="string">view1</config:config-item>
1239              <config:config-item-map-named config:name="Tables">
1240  ';
1241          foreach ($this->worksheets as $ws) {
1242              $buffer .= '               <config:config-item-map-entry config:name="'.htmlspecialchars($ws->name, ENT_QUOTES, 'utf-8').'">'."\n";
1243              $buffer .= '                 <config:config-item config:name="ShowGrid" config:type="boolean">'.($ws->showgrid ? 'true' : 'false').'</config:config-item>'."\n";
1244              $buffer .= '               </config:config-item-map-entry>."\n"';
1245          }
1246              $buffer .=
1247  '           </config:config-item-map-named>
1248            </config:config-item-map-entry>
1249          </config:config-item-map-indexed>
1250        </config:config-item-set>
1251        <config:config-item-set config:name="ooo:configuration-settings">
1252          <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item>
1253        </config:config-item-set>
1254      </office:settings>
1255  </office:document-settings>';
1256  
1257          return $buffer;
1258      }
1259      protected function get_ods_meta() {
1260          global $CFG, $USER;
1261  
1262          return
1263  '<?xml version="1.0" encoding="UTF-8"?>
1264  <office:document-meta xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0"
1265                        xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/"
1266                        xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0"
1267                        xmlns:ooo="http://openoffice.org/2004/office" xmlns:grddl="http://www.w3.org/2003/g/data-view#"
1268                        office:version="1.2">
1269      <office:meta>
1270          <meta:generator>Moodle '.$CFG->release.'</meta:generator>
1271          <meta:initial-creator>' . htmlspecialchars(fullname($USER, true), ENT_QUOTES, 'utf-8') . '</meta:initial-creator>
1272          <meta:creation-date>'.date("Y-m-d\\TH:i:s").'</meta:creation-date>
1273          <meta:document-statistic meta:table-count="1" meta:cell-count="0" meta:object-count="0"/>
1274      </office:meta>
1275  </office:document-meta>';
1276      }
1277  
1278      protected function get_ods_styles() {
1279          return
1280  '<?xml version="1.0" encoding="UTF-8"?>
1281  <office:document-styles xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0"
1282                          xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0"
1283                          xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0"
1284                          xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0"
1285                          xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0"
1286                          xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0"
1287                          xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/"
1288                          xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0"
1289                          xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0"
1290                          xmlns:presentation="urn:oasis:names:tc:opendocument:xmlns:presentation:1.0"
1291                          xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0"
1292                          xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0"
1293                          xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0"
1294                          xmlns:math="http://www.w3.org/1998/Math/MathML"
1295                          xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0"
1296                          xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0"
1297                          xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer"
1298                          xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dom="http://www.w3.org/2001/xml-events"
1299                          xmlns:rpt="http://openoffice.org/2005/report"
1300                          xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2"
1301                          xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#"
1302                          xmlns:tableooo="http://openoffice.org/2009/table"
1303                          xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0"
1304                          xmlns:css3t="http://www.w3.org/TR/css3-text/" office:version="1.2">
1305      <office:font-face-decls>
1306          <style:font-face style:name="Arial" svg:font-family="Arial" style:font-family-generic="swiss"
1307                           style:font-pitch="variable"/>
1308          <style:font-face style:name="Arial Unicode MS" svg:font-family="&apos;Arial Unicode MS&apos;"
1309                           style:font-family-generic="system" style:font-pitch="variable"/>
1310          <style:font-face style:name="Tahoma" svg:font-family="Tahoma" style:font-family-generic="system"
1311                           style:font-pitch="variable"/>
1312      </office:font-face-decls>
1313      <office:styles>
1314          <style:default-style style:family="table-cell">
1315              <style:paragraph-properties style:tab-stop-distance="1.25cm"/>
1316          </style:default-style>
1317          <number:number-style style:name="N0">
1318              <number:number number:min-integer-digits="1"/>
1319          </number:number-style>
1320          <style:style style:name="Default" style:family="table-cell">
1321              <style:text-properties style:font-name-asian="Arial Unicode MS" style:font-name-complex="Arial Unicode MS"/>
1322          </style:style>
1323          <style:style style:name="Result" style:family="table-cell" style:parent-style-name="Default">
1324              <style:text-properties fo:font-style="italic" style:text-underline-style="solid"
1325                                     style:text-underline-width="auto" style:text-underline-color="font-color"
1326                                     fo:font-weight="bold"/>
1327          </style:style>
1328          <style:style style:name="Result2" style:family="table-cell" style:parent-style-name="Result"
1329                       style:data-style-name="N104"/>
1330          <style:style style:name="Heading" style:family="table-cell" style:parent-style-name="Default">
1331              <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/>
1332              <style:paragraph-properties fo:text-align="center"/>
1333              <style:text-properties fo:font-size="16pt" fo:font-style="italic" fo:font-weight="bold"/>
1334          </style:style>
1335          <style:style style:name="Heading1" style:family="table-cell" style:parent-style-name="Heading">
1336              <style:table-cell-properties style:rotation-angle="90"/>
1337          </style:style>
1338      </office:styles>
1339      <office:automatic-styles>
1340          <style:page-layout style:name="Mpm1">
1341              <style:page-layout-properties style:writing-mode="lr-tb"/>
1342              <style:header-style>
1343                  <style:header-footer-properties fo:min-height="0.75cm" fo:margin-left="0cm" fo:margin-right="0cm"
1344                                                  fo:margin-bottom="0.25cm"/>
1345              </style:header-style>
1346              <style:footer-style>
1347                  <style:header-footer-properties fo:min-height="0.75cm" fo:margin-left="0cm" fo:margin-right="0cm"
1348                                                  fo:margin-top="0.25cm"/>
1349              </style:footer-style>
1350          </style:page-layout>
1351          <style:page-layout style:name="Mpm2">
1352              <style:page-layout-properties style:writing-mode="lr-tb"/>
1353              <style:header-style>
1354                  <style:header-footer-properties fo:min-height="0.75cm" fo:margin-left="0cm" fo:margin-right="0cm"
1355                                                  fo:margin-bottom="0.25cm" fo:border="2.49pt solid #000000"
1356                                                  fo:padding="0.018cm" fo:background-color="#c0c0c0">
1357                      <style:background-image/>
1358                  </style:header-footer-properties>
1359              </style:header-style>
1360              <style:footer-style>
1361                  <style:header-footer-properties fo:min-height="0.75cm" fo:margin-left="0cm" fo:margin-right="0cm"
1362                                                  fo:margin-top="0.25cm" fo:border="2.49pt solid #000000"
1363                                                  fo:padding="0.018cm" fo:background-color="#c0c0c0">
1364                      <style:background-image/>
1365                  </style:header-footer-properties>
1366              </style:footer-style>
1367          </style:page-layout>
1368      </office:automatic-styles>
1369      <office:master-styles>
1370          <style:master-page style:name="Default" style:page-layout-name="Mpm1">
1371              <style:header>
1372                  <text:p>
1373                      <text:sheet-name>???</text:sheet-name>
1374                  </text:p>
1375              </style:header>
1376              <style:header-left style:display="false"/>
1377              <style:footer>
1378                  <text:p>Page
1379                      <text:page-number>1</text:page-number>
1380                  </text:p>
1381              </style:footer>
1382              <style:footer-left style:display="false"/>
1383          </style:master-page>
1384          <style:master-page style:name="Report" style:page-layout-name="Mpm2">
1385              <style:header>
1386                  <style:region-left>
1387                      <text:p>
1388                          <text:sheet-name>???</text:sheet-name>
1389                          (<text:title>???</text:title>)
1390                      </text:p>
1391                  </style:region-left>
1392                  <style:region-right>
1393                      <text:p><text:date style:data-style-name="N2" text:date-value="2013-01-05">00.00.0000</text:date>,
1394                          <text:time>00:00:00</text:time>
1395                      </text:p>
1396                  </style:region-right>
1397              </style:header>
1398              <style:header-left style:display="false"/>
1399              <style:footer>
1400                  <text:p>Page
1401                      <text:page-number>1</text:page-number>
1402                      /
1403                      <text:page-count>99</text:page-count>
1404                  </text:p>
1405              </style:footer>
1406              <style:footer-left style:display="false"/>
1407          </style:master-page>
1408      </office:master-styles>
1409  </office:document-styles>';
1410      }
1411  
1412      protected function get_ods_manifest() {
1413          return
1414  '<?xml version="1.0" encoding="UTF-8"?>
1415  <manifest:manifest xmlns:manifest="urn:oasis:names:tc:opendocument:xmlns:manifest:1.0" manifest:version="1.2">
1416   <manifest:file-entry manifest:full-path="/" manifest:version="1.2" manifest:media-type="application/vnd.oasis.opendocument.spreadsheet"/>
1417   <manifest:file-entry manifest:full-path="meta.xml" manifest:media-type="text/xml"/>
1418   <manifest:file-entry manifest:full-path="content.xml" manifest:media-type="text/xml"/>
1419   <manifest:file-entry manifest:full-path="styles.xml" manifest:media-type="text/xml"/>
1420   <manifest:file-entry manifest:full-path="settings.xml" manifest:media-type="text/xml"/>
1421  </manifest:manifest>';
1422      }
1423  
1424      protected function get_num_styles() {
1425          return '
1426          <number:number-style style:name="NUM1">
1427              <number:number number:decimal-places="0" number:min-integer-digits="1"/>
1428          </number:number-style>
1429          <number:number-style style:name="NUM2">
1430              <number:number number:decimal-places="2" number:min-integer-digits="1"/>
1431          </number:number-style>
1432          <number:number-style style:name="NUM3">
1433              <number:number number:decimal-places="0" number:min-integer-digits="1" number:grouping="true"/>
1434          </number:number-style>
1435          <number:number-style style:name="NUM4">
1436              <number:number number:decimal-places="2" number:min-integer-digits="1" number:grouping="true"/>
1437          </number:number-style>
1438          <number:number-style style:name="NUM11">
1439              <number:scientific-number number:decimal-places="2" number:min-integer-digits="1"
1440                                        number:min-exponent-digits="2"/>
1441          </number:number-style>
1442          <number:number-style style:name="NUM12">
1443              <number:fraction number:min-integer-digits="0" number:min-numerator-digits="1"
1444                               number:min-denominator-digits="1"/>
1445          </number:number-style>
1446          <number:number-style style:name="NUM13">
1447              <number:fraction number:min-integer-digits="0" number:min-numerator-digits="2"
1448                               number:min-denominator-digits="2"/>
1449          </number:number-style>
1450          <number:date-style style:name="NUM14" number:automatic-order="true">
1451              <number:month number:style="long"/>
1452              <number:text>/</number:text>
1453              <number:day number:style="long"/>
1454              <number:text>/</number:text>
1455              <number:year/>
1456          </number:date-style>
1457          <number:date-style style:name="NUM15">
1458              <number:day/>
1459              <number:text>.</number:text>
1460              <number:month number:textual="true"/>
1461              <number:text>.</number:text>
1462              <number:year number:style="long"/>
1463          </number:date-style>
1464          <number:date-style style:name="NUM16" number:automatic-order="true">
1465              <number:month number:textual="true"/>
1466              <number:text></number:text>
1467              <number:day number:style="long"/>
1468          </number:date-style>
1469          <number:date-style style:name="NUM17">
1470              <number:month number:style="long"/>
1471              <number:text>-</number:text>
1472              <number:day number:style="long"/>
1473          </number:date-style>
1474          <number:date-style style:name="NUM22" number:automatic-order="true"
1475                             number:format-source="language">
1476              <number:month/>
1477              <number:text>/</number:text>
1478              <number:day/>
1479              <number:text>/</number:text>
1480              <number:year/>
1481              <number:text></number:text>
1482              <number:hours number:style="long"/>
1483              <number:text>:</number:text>
1484              <number:minutes number:style="long"/>
1485              <number:text></number:text>
1486              <number:am-pm/>
1487          </number:date-style>
1488          <number:text-style style:name="NUM49">
1489              <number:text-content/>
1490          </number:text-style>
1491  ';
1492      }
1493  }