[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3   * PHPExcel
   4   *
   5   * Copyright (c) 2006 - 2015 PHPExcel
   6   *
   7   * This library is free software; you can redistribute it and/or
   8   * modify it under the terms of the GNU Lesser General Public
   9   * License as published by the Free Software Foundation; either
  10   * version 2.1 of the License, or (at your option) any later version.
  11   *
  12   * This library is distributed in the hope that it will be useful,
  13   * but WITHOUT ANY WARRANTY; without even the implied warranty of
  14   * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
  15   * Lesser General Public License for more details.
  16   *
  17   * You should have received a copy of the GNU Lesser General Public
  18   * License along with this library; if not, write to the Free Software
  19   * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
  20   *
  21   * @category   PHPExcel
  22   * @package    PHPExcel_Writer_OpenDocument
  23   * @copyright  Copyright (c) 2006 - 2015 PHPExcel (http://www.codeplex.com/PHPExcel)
  24   * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt    LGPL
  25   * @version    ##VERSION##, ##DATE##
  26   */
  27  
  28  
  29  /**
  30   * PHPExcel_Writer_OpenDocument_Cell_Comment
  31   *
  32   * @category   PHPExcel
  33   * @package    PHPExcel_Writer_OpenDocument
  34   * @copyright  Copyright (c) 2006 - 2015 PHPExcel (http://www.codeplex.com/PHPExcel)
  35   * @author     Alexander Pervakov <frost-nzcr4@jagmort.com>
  36   */
  37  class PHPExcel_Writer_OpenDocument_Cell_Comment
  38  {
  39      public static function write(PHPExcel_Shared_XMLWriter $objWriter, PHPExcel_Cell $cell)
  40      {
  41          $comments = $cell->getWorksheet()->getComments();
  42          if (!isset($comments[$cell->getCoordinate()])) {
  43              return;
  44          }
  45          $comment = $comments[$cell->getCoordinate()];
  46  
  47          $objWriter->startElement('office:annotation');
  48              //$objWriter->writeAttribute('draw:style-name', 'gr1');
  49              //$objWriter->writeAttribute('draw:text-style-name', 'P1');
  50              $objWriter->writeAttribute('svg:width', $comment->getWidth());
  51              $objWriter->writeAttribute('svg:height', $comment->getHeight());
  52              $objWriter->writeAttribute('svg:x', $comment->getMarginLeft());
  53              $objWriter->writeAttribute('svg:y', $comment->getMarginTop());
  54              //$objWriter->writeAttribute('draw:caption-point-x', $comment->getMarginLeft());
  55              //$objWriter->writeAttribute('draw:caption-point-y', $comment->getMarginTop());
  56                  $objWriter->writeElement('dc:creator', $comment->getAuthor());
  57                  // TODO: Not realized in PHPExcel_Comment yet.
  58                  //$objWriter->writeElement('dc:date', $comment->getDate());
  59                  $objWriter->writeElement('text:p', $comment->getText()->getPlainText());
  60                      //$objWriter->writeAttribute('draw:text-style-name', 'P1');
  61          $objWriter->endElement();
  62      }
  63  }