author = 'Author'; $this->text = new PHPExcel_RichText(); $this->fillColor = new PHPExcel_Style_Color('FFFFFFE1'); $this->alignment = PHPExcel_Style_Alignment::HORIZONTAL_GENERAL; } /** * Get Author * * @return string */ public function getAuthor() { return $this->author; } /** * Set Author * * @param string $pValue * @return PHPExcel_Comment */ public function setAuthor($pValue = '') { $this->author = $pValue; return $this; } /** * Get Rich text comment * * @return PHPExcel_RichText */ public function getText() { return $this->text; } /** * Set Rich text comment * * @param PHPExcel_RichText $pValue * @return PHPExcel_Comment */ public function setText(PHPExcel_RichText $pValue) { $this->text = $pValue; return $this; } /** * Get comment width (CSS style, i.e. XXpx or YYpt) * * @return string */ public function getWidth() { return $this->width; } /** * Set comment width (CSS style, i.e. XXpx or YYpt) * * @param string $value * @return PHPExcel_Comment */ public function setWidth($value = '96pt') { $this->width = $value; return $this; } /** * Get comment height (CSS style, i.e. XXpx or YYpt) * * @return string */ public function getHeight() { return $this->height; } /** * Set comment height (CSS style, i.e. XXpx or YYpt) * * @param string $value * @return PHPExcel_Comment */ public function setHeight($value = '55.5pt') { $this->height = $value; return $this; } /** * Get left margin (CSS style, i.e. XXpx or YYpt) * * @return string */ public function getMarginLeft() { return $this->marginLeft; } /** * Set left margin (CSS style, i.e. XXpx or YYpt) * * @param string $value * @return PHPExcel_Comment */ public function setMarginLeft($value = '59.25pt') { $this->marginLeft = $value; return $this; } /** * Get top margin (CSS style, i.e. XXpx or YYpt) * * @return string */ public function getMarginTop() { return $this->marginTop; } /** * Set top margin (CSS style, i.e. XXpx or YYpt) * * @param string $value * @return PHPExcel_Comment */ public function setMarginTop($value = '1.5pt') { $this->marginTop = $value; return $this; } /** * Is the comment visible by default? * * @return boolean */ public function getVisible() { return $this->visible; } /** * Set comment default visibility * * @param boolean $value * @return PHPExcel_Comment */ public function setVisible($value = false) { $this->visible = $value; return $this; } /** * Get fill color * * @return PHPExcel_Style_Color */ public function getFillColor() { return $this->fillColor; } /** * Set Alignment * * @param string $pValue * @return PHPExcel_Comment */ public function setAlignment($pValue = PHPExcel_Style_Alignment::HORIZONTAL_GENERAL) { $this->alignment = $pValue; return $this; } /** * Get Alignment * * @return string */ public function getAlignment() { return $this->alignment; } /** * Get hash code * * @return string Hash code */ public function getHashCode() { return md5( $this->author . $this->text->getHashCode() . $this->width . $this->height . $this->marginLeft . $this->marginTop . ($this->visible ? 1 : 0) . $this->fillColor->getHashCode() . $this->alignment . __CLASS__ ); } /** * Implement PHP __clone to create a deep clone, not just a shallow copy. */ public function __clone() { $vars = get_object_vars($this); foreach ($vars as $key => $value) { if (is_object($value)) { $this->$key = clone $value; } else { $this->$key = $value; } } } /** * Convert to string * * @return string */ public function __toString() { return $this->text->getPlainText(); } }