visualizer / vendor / phpoffice / phpexcel / Classes / PHPExcel / Writer / OpenDocument / Cell / Comment.php

Comment.php in Visualizer – Tables & Charts Manager with Built-in AI Generator 3.0.3, at vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/OpenDocument/Cell/Comment.php

64 lines 2.7 KB

Raw Download Zip

1	<?php
2	/**
3	* PHPExcel
4	*
5	* Copyright (c) 2006 - 2014 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 - 2014 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 - 2014 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	}
64