# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Chart/Chart.php

TablePress – Tables in WordPress made easy, version 3.4. 901 lines.

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Chart/Chart.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Chart/Chart.php
- Modified: 2026-08-19T03:43:04+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Chart/Chart.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Chart;

use TablePress\PhpOffice\PhpSpreadsheet\Settings;
use TablePress\PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;

class Chart
{
	/**
	 * Chart Name.
	 */
	private string $name;

	/**
	 * Worksheet.
	 */
	private ?Worksheet $worksheet = null;

	/**
	 * Chart Title.
	 */
	private ?Title $title;

	/**
	 * Chart Legend.
	 */
	private ?Legend $legend;

	/**
	 * X-Axis Label.
	 */
	private ?Title $xAxisLabel;

	/**
	 * Y-Axis Label.
	 */
	private ?Title $yAxisLabel;

	/**
	 * Chart Plot Area.
	 */
	private ?PlotArea $plotArea;

	/**
	 * Plot Visible Only.
	 */
	private bool $plotVisibleOnly;

	/**
	 * Display Blanks as.
	 */
	private string $displayBlanksAs;

	/**
	 * Chart Asix Y as.
	 */
	private Axis $yAxis;

	/**
	 * Chart Asix X as.
	 */
	private Axis $xAxis;

	/**
	 * Top-Left Cell Position.
	 */
	private string $topLeftCellRef = 'A1';

	/**
	 * Top-Left X-Offset.
	 */
	private int $topLeftXOffset = 0;

	/**
	 * Top-Left Y-Offset.
	 */
	private int $topLeftYOffset = 0;

	/**
	 * Bottom-Right Cell Position.
	 */
	private string $bottomRightCellRef = '';

	/**
	 * Bottom-Right X-Offset.
	 */
	private int $bottomRightXOffset = 10;

	/**
	 * Bottom-Right Y-Offset.
	 */
	private int $bottomRightYOffset = 10;

	private ?int $rotX = null;

	private ?int $rotY = null;

	private ?int $rAngAx = null;

	private ?int $perspective = null;

	private bool $oneCellAnchor = false;

	private bool $autoTitleDeleted = false;

	private bool $noFill = false;

	private bool $noBorder = false;

	private bool $roundedCorners = false;

	private bool $date1904 = false;

	private string $lang = 'en-GB';

	/** @var array{
	 *     b?: numeric-string,
	 *     l?: numeric-string,
	 *     r?: numeric-string,
	 *     t?: numeric-string,
	 *     header?: numeric-string,
	 *     footer?: numeric-string,
	 * }
	 */
	private array $pageMargins = [
		'b' => '0.75',
		'l' => '0.7',
		'r' => '0.7',
		't' => '0.75',
		'header' => '0.3',
		'footer' => '0.3',
	];

	/** @var array{
	 *     paperSize?: string,
	 *     orientation?: string,
	 * }
	 */
	private array $pageSetup = [
		'orientation' => 'portrait',
	];

	private GridLines $borderLines;

	private ChartColor $fillColor;

	/**
	 * Rendered width in pixels.
	 */
	private ?float $renderedWidth = null;

	/**
	 * Rendered height in pixels.
	 */
	private ?float $renderedHeight = null;

	/**
	 * Create a new Chart.
	 * majorGridlines and minorGridlines are deprecated, moved to Axis.
	 */
	public function __construct(string $name, ?Title $title = null, ?Legend $legend = null, ?PlotArea $plotArea = null, bool $plotVisibleOnly = true, string $displayBlanksAs = DataSeries::DEFAULT_EMPTY_AS, ?Title $xAxisLabel = null, ?Title $yAxisLabel = null, ?Axis $xAxis = null, ?Axis $yAxis = null, ?GridLines $majorGridlines = null, ?GridLines $minorGridlines = null)
	{
		$this->name = $name;
		$this->title = $title;
		$this->legend = $legend;
		$this->xAxisLabel = $xAxisLabel;
		$this->yAxisLabel = $yAxisLabel;
		$this->plotArea = $plotArea;
		$this->plotVisibleOnly = $plotVisibleOnly;
		$this->setDisplayBlanksAs($displayBlanksAs);
		$this->xAxis = $xAxis ?? new Axis();
		$this->yAxis = $yAxis ?? new Axis();
		if ($majorGridlines !== null) {
			$this->yAxis->setMajorGridlines($majorGridlines);
		}
		if ($minorGridlines !== null) {
			$this->yAxis->setMinorGridlines($minorGridlines);
		}
		$this->fillColor = new ChartColor();
		$this->borderLines = new GridLines();
	}

	public function __destruct()
	{
		$this->worksheet = null;
	}

	/**
	 * Get Name.
	 */
	public function getName(): string
	{
		return $this->name;
	}

	public function setName(string $name): self
	{
		$this->name = $name;

		return $this;
	}

	/**
	 * Get Worksheet.
	 */
	public function getWorksheet(): ?Worksheet
	{
		return $this->worksheet;
	}

	/**
	 * Set Worksheet.
	 *
	 * @return $this
	 */
	public function setWorksheet(?Worksheet $worksheet = null)
	{
		$this->worksheet = $worksheet;

		return $this;
	}

	public function getTitle(): ?Title
	{
		return $this->title;
	}

	/**
	 * Set Title.
	 *
	 * @return $this
	 */
	public function setTitle(Title $title)
	{
		$this->title = $title;

		return $this;
	}

	public function getLegend(): ?Legend
	{
		return $this->legend;
	}

	/**
	 * Set Legend.
	 *
	 * @return $this
	 */
	public function setLegend(Legend $legend)
	{
		$this->legend = $legend;

		return $this;
	}

	public function getXAxisLabel(): ?Title
	{
		return $this->xAxisLabel;
	}

	/**
	 * Set X-Axis Label.
	 *
	 * @return $this
	 */
	public function setXAxisLabel(Title $label)
	{
		$this->xAxisLabel = $label;

		return $this;
	}

	public function getYAxisLabel(): ?Title
	{
		return $this->yAxisLabel;
	}

	/**
	 * Set Y-Axis Label.
	 *
	 * @return $this
	 */
	public function setYAxisLabel(Title $label)
	{
		$this->yAxisLabel = $label;

		return $this;
	}

	public function getPlotArea(): ?PlotArea
	{
		return $this->plotArea;
	}

	public function getPlotAreaOrThrow(): PlotArea
	{
		$plotArea = $this->getPlotArea();
		if ($plotArea !== null) {
			return $plotArea;
		}

		throw new Exception('Chart has no PlotArea');
	}

	/**
	 * Set Plot Area.
	 */
	public function setPlotArea(PlotArea $plotArea): self
	{
		$this->plotArea = $plotArea;

		return $this;
	}

	/**
	 * Get Plot Visible Only.
	 */
	public function getPlotVisibleOnly(): bool
	{
		return $this->plotVisibleOnly;
	}

	/**
	 * Set Plot Visible Only.
	 *
	 * @return $this
	 */
	public function setPlotVisibleOnly(bool $plotVisibleOnly)
	{
		$this->plotVisibleOnly = $plotVisibleOnly;

		return $this;
	}

	/**
	 * Get Display Blanks as.
	 */
	public function getDisplayBlanksAs(): string
	{
		return $this->displayBlanksAs;
	}

	/**
	 * Set Display Blanks as.
	 *
	 * @return $this
	 */
	public function setDisplayBlanksAs(string $displayBlanksAs)
	{
		$displayBlanksAs = strtolower($displayBlanksAs);
		$this->displayBlanksAs = in_array($displayBlanksAs, DataSeries::VALID_EMPTY_AS, true) ? $displayBlanksAs : DataSeries::DEFAULT_EMPTY_AS;

		return $this;
	}

	public function getChartAxisY(): Axis
	{
		return $this->yAxis;
	}

	/**
	 * Set yAxis.
	 */
	public function setChartAxisY(?Axis $axis): self
	{
		$this->yAxis = $axis ?? new Axis();

		return $this;
	}

	public function getChartAxisX(): Axis
	{
		return $this->xAxis;
	}

	/**
	 * Set xAxis.
	 */
	public function setChartAxisX(?Axis $axis): self
	{
		$this->xAxis = $axis ?? new Axis();

		return $this;
	}

	/**
	 * Set the Top Left position for the chart.
	 *
	 * @return $this
	 */
	public function setTopLeftPosition(string $cellAddress, ?int $xOffset = null, ?int $yOffset = null)
	{
		$this->topLeftCellRef = $cellAddress;
		if ($xOffset !== null) {
			$this->setTopLeftXOffset($xOffset);
		}
		if ($yOffset !== null) {
			$this->setTopLeftYOffset($yOffset);
		}

		return $this;
	}

	/**
	 * Get the top left position of the chart.
	 *
	 * Returns ['cell' => string cell address, 'xOffset' => int, 'yOffset' => int].
	 *
	 * @return array{cell: string, xOffset: int, yOffset: int} an associative array containing the cell address, X-Offset and Y-Offset from the top left of that cell
	 */
	public function getTopLeftPosition(): array
	{
		return [
			'cell' => $this->topLeftCellRef,
			'xOffset' => $this->topLeftXOffset,
			'yOffset' => $this->topLeftYOffset,
		];
	}

	/**
	 * Get the cell address where the top left of the chart is fixed.
	 */
	public function getTopLeftCell(): string
	{
		return $this->topLeftCellRef;
	}

	/**
	 * Set the Top Left cell position for the chart.
	 *
	 * @return $this
	 */
	public function setTopLeftCell(string $cellAddress)
	{
		$this->topLeftCellRef = $cellAddress;

		return $this;
	}

	/**
	 * Set the offset position within the Top Left cell for the chart.
	 *
	 * @return $this
	 */
	public function setTopLeftOffset(?int $xOffset, ?int $yOffset)
	{
		if ($xOffset !== null) {
			$this->setTopLeftXOffset($xOffset);
		}

		if ($yOffset !== null) {
			$this->setTopLeftYOffset($yOffset);
		}

		return $this;
	}

	/**
	 * Get the offset position within the Top Left cell for the chart.
	 *
	 * @return int[]
	 */
	public function getTopLeftOffset(): array
	{
		return [
			'X' => $this->topLeftXOffset,
			'Y' => $this->topLeftYOffset,
		];
	}

	/**
	 * @return $this
	 */
	public function setTopLeftXOffset(int $xOffset)
	{
		$this->topLeftXOffset = $xOffset;

		return $this;
	}

	public function getTopLeftXOffset(): int
	{
		return $this->topLeftXOffset;
	}

	/**
	 * @return $this
	 */
	public function setTopLeftYOffset(int $yOffset)
	{
		$this->topLeftYOffset = $yOffset;

		return $this;
	}

	public function getTopLeftYOffset(): int
	{
		return $this->topLeftYOffset;
	}

	/**
	 * Set the Bottom Right position of the chart.
	 *
	 * @return $this
	 */
	public function setBottomRightPosition(string $cellAddress = '', ?int $xOffset = null, ?int $yOffset = null)
	{
		$this->bottomRightCellRef = $cellAddress;
		if ($xOffset !== null) {
			$this->setBottomRightXOffset($xOffset);
		}
		if ($yOffset !== null) {
			$this->setBottomRightYOffset($yOffset);
		}

		return $this;
	}

	/**
	 * Get the bottom right position of the chart.
	 *
	 * @return array{cell: string, xOffset: int, yOffset:int} an associative array containing the cell address, X-Offset and Y-Offset from the top left of that cell
	 */
	public function getBottomRightPosition(): array
	{
		return [
			'cell' => $this->bottomRightCellRef,
			'xOffset' => $this->bottomRightXOffset,
			'yOffset' => $this->bottomRightYOffset,
		];
	}

	/**
	 * Set the Bottom Right cell for the chart.
	 *
	 * @return $this
	 */
	public function setBottomRightCell(string $cellAddress = '')
	{
		$this->bottomRightCellRef = $cellAddress;

		return $this;
	}

	/**
	 * Get the cell address where the bottom right of the chart is fixed.
	 */
	public function getBottomRightCell(): string
	{
		return $this->bottomRightCellRef;
	}

	/**
	 * Set the offset position within the Bottom Right cell for the chart.
	 *
	 * @return $this
	 */
	public function setBottomRightOffset(?int $xOffset, ?int $yOffset)
	{
		if ($xOffset !== null) {
			$this->setBottomRightXOffset($xOffset);
		}

		if ($yOffset !== null) {
			$this->setBottomRightYOffset($yOffset);
		}

		return $this;
	}

	/**
	 * Get the offset position within the Bottom Right cell for the chart.
	 *
	 * @return int[]
	 */
	public function getBottomRightOffset(): array
	{
		return [
			'X' => $this->bottomRightXOffset,
			'Y' => $this->bottomRightYOffset,
		];
	}

	/**
	 * @return $this
	 */
	public function setBottomRightXOffset(int $xOffset)
	{
		$this->bottomRightXOffset = $xOffset;

		return $this;
	}

	public function getBottomRightXOffset(): int
	{
		return $this->bottomRightXOffset;
	}

	/**
	 * @return $this
	 */
	public function setBottomRightYOffset(int $yOffset)
	{
		$this->bottomRightYOffset = $yOffset;

		return $this;
	}

	public function getBottomRightYOffset(): int
	{
		return $this->bottomRightYOffset;
	}

	public function refresh(): void
	{
		if ($this->worksheet !== null && $this->plotArea !== null) {
			$this->plotArea->refresh($this->worksheet);
		}
	}

	/**
	 * Render the chart to given file (or stream).
	 *
	 * @param ?string $outputDestination Name of the file render to
	 *
	 * @return bool true on success
	 */
	public function render(?string $outputDestination = null): bool
	{
		if ($outputDestination == 'php://output') {
			$outputDestination = null;
		}

		$libraryName = Settings::getChartRenderer();
		if ($libraryName === null) {
			return false;
		}

		// Ensure that data series values are up-to-date before we render
		$this->refresh();

		$renderer = new $libraryName($this);

		return $renderer->render($outputDestination);
	}

	public function getRotX(): ?int
	{
		return $this->rotX;
	}

	public function setRotX(?int $rotX): self
	{
		$this->rotX = $rotX;

		return $this;
	}

	public function getRotY(): ?int
	{
		return $this->rotY;
	}

	public function setRotY(?int $rotY): self
	{
		$this->rotY = $rotY;

		return $this;
	}

	public function getRAngAx(): ?int
	{
		return $this->rAngAx;
	}

	public function setRAngAx(?int $rAngAx): self
	{
		$this->rAngAx = $rAngAx;

		return $this;
	}

	public function getPerspective(): ?int
	{
		return $this->perspective;
	}

	public function setPerspective(?int $perspective): self
	{
		$this->perspective = $perspective;

		return $this;
	}

	public function getOneCellAnchor(): bool
	{
		return $this->oneCellAnchor;
	}

	public function setOneCellAnchor(bool $oneCellAnchor): self
	{
		$this->oneCellAnchor = $oneCellAnchor;

		return $this;
	}

	public function getAutoTitleDeleted(): bool
	{
		return $this->autoTitleDeleted;
	}

	public function setAutoTitleDeleted(?bool $autoTitleDeleted): self
	{
		if (is_bool($autoTitleDeleted)) {
			$this->autoTitleDeleted = $autoTitleDeleted;
		}

		return $this;
	}

	public function getNoFill(): bool
	{
		return $this->noFill;
	}

	public function setNoFill(bool $noFill): self
	{
		$this->noFill = $noFill;

		return $this;
	}

	public function getNoBorder(): bool
	{
		return $this->noBorder;
	}

	public function setNoBorder(bool $noBorder): self
	{
		$this->noBorder = $noBorder;

		return $this;
	}

	public function getRoundedCorners(): bool
	{
		return $this->roundedCorners;
	}

	public function setRoundedCorners(?bool $roundedCorners): self
	{
		if ($roundedCorners !== null) {
			$this->roundedCorners = $roundedCorners;
		}

		return $this;
	}

	public function getDate1904(): bool
	{
		return $this->date1904;
	}

	public function setDate1904(?bool $date1904): self
	{
		if ($date1904 !== null) {
			$this->date1904 = $date1904;
		}

		return $this;
	}

	public function getLang(): string
	{
		return $this->lang;
	}

	public function setLang(?string $lang): self
	{
		if ($lang !== null && $lang !== '') {
			$this->lang = $lang;
		}

		return $this;
	}

	public function getBorderLines(): GridLines
	{
		return $this->borderLines;
	}

	public function setBorderLines(GridLines $borderLines): self
	{
		$this->borderLines = $borderLines;

		return $this;
	}

	public function getFillColor(): ChartColor
	{
		return $this->fillColor;
	}

	public function setRenderedWidth(?float $width): self
	{
		$this->renderedWidth = $width;

		return $this;
	}

	public function getRenderedWidth(): ?float
	{
		return $this->renderedWidth;
	}

	public function setRenderedHeight(?float $height): self
	{
		$this->renderedHeight = $height;

		return $this;
	}

	public function getRenderedHeight(): ?float
	{
		return $this->renderedHeight;
	}

	/**
	 * Implement PHP __clone to create a deep clone, not just a shallow copy.
	 */
	public function __clone()
	{
		$this->worksheet = null;
		$this->title = ($this->title === null) ? null : clone $this->title;
		$this->legend = ($this->legend === null) ? null : clone $this->legend;
		$this->xAxisLabel = ($this->xAxisLabel === null) ? null : clone $this->xAxisLabel;
		$this->yAxisLabel = ($this->yAxisLabel === null) ? null : clone $this->yAxisLabel;
		$this->plotArea = ($this->plotArea === null) ? null : clone $this->plotArea;
		$this->xAxis = clone $this->xAxis;
		$this->yAxis = clone $this->yAxis;
		$this->borderLines = clone $this->borderLines;
		$this->fillColor = clone $this->fillColor;
	}

	/** @return array{
	 * b?: numeric-string,
	 * l?: numeric-string,
	 * r?: numeric-string,
	 * t?: numeric-string,
	 * header?: numeric-string,
	 * footer?: numeric-string,
	 * }
	 */
	public function getPageMargins(): array
	{
		return $this->pageMargins;
	}

	/** @param mixed $pageMargins expecting array matching $this->pageMargins */
	public function setPageMargins($pageMargins): self
	{
		if (is_array($pageMargins)) {
			foreach (['b', 'l', 'r', 't', 'header', 'footer'] as $key) {
				$value = $pageMargins[$key] ?? null;
				if (is_string($value) && is_numeric($value)) {
					$this->pageMargins[$key] = "$value";
				}
			}
		}

		return $this;
	}

	/** @return array{
	 *     paperSize?: string,
	 *     orientation?: string,
	 * }
	 */
	public function getPageSetup(): array
	{
		return $this->pageSetup;
	}

	/** @param mixed $pageSetup expecting array matching $this->pageSetup */
	public function setPageSetup($pageSetup): self
	{
		if (is_array($pageSetup)) {
			foreach (['paperSize', 'orientation'] as $key) {
				$value = $pageSetup[$key] ?? null;
				if (is_string($value)) {
					$this->pageSetup[$key] = "$value";
				}
			}
		}

		return $this;
	}
}

```