Comment.php 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  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. * PHPExcel_Writer_OpenDocument_Cell_Comment
  29. *
  30. * @category PHPExcel
  31. * @package PHPExcel_Writer_OpenDocument
  32. * @copyright Copyright (c) 2006 - 2015 PHPExcel (http://www.codeplex.com/PHPExcel)
  33. * @author Alexander Pervakov <frost-nzcr4@jagmort.com>
  34. */
  35. class PHPExcel_Writer_OpenDocument_Cell_Comment
  36. {
  37. public static function write(PHPExcel_Shared_XMLWriter $objWriter, PHPExcel_Cell $cell)
  38. {
  39. $comments = $cell->getWorksheet()->getComments();
  40. if (!isset($comments[$cell->getCoordinate()])) {
  41. return;
  42. }
  43. $comment = $comments[$cell->getCoordinate()];
  44. $objWriter->startElement('office:annotation');
  45. //$objWriter->writeAttribute('draw:style-name', 'gr1');
  46. //$objWriter->writeAttribute('draw:text-style-name', 'P1');
  47. $objWriter->writeAttribute('svg:width', $comment->getWidth());
  48. $objWriter->writeAttribute('svg:height', $comment->getHeight());
  49. $objWriter->writeAttribute('svg:x', $comment->getMarginLeft());
  50. $objWriter->writeAttribute('svg:y', $comment->getMarginTop());
  51. //$objWriter->writeAttribute('draw:caption-point-x', $comment->getMarginLeft());
  52. //$objWriter->writeAttribute('draw:caption-point-y', $comment->getMarginTop());
  53. $objWriter->writeElement('dc:creator', $comment->getAuthor());
  54. // TODO: Not realized in PHPExcel_Comment yet.
  55. //$objWriter->writeElement('dc:date', $comment->getDate());
  56. $objWriter->writeElement('text:p', $comment->getText()->getPlainText());
  57. //$objWriter->writeAttribute('draw:text-style-name', 'P1');
  58. $objWriter->endElement();
  59. }
  60. }