| 123456789101112131415161718192021222324252627282930313233343536373839404142434445 |
- <?php
- namespace PhpOffice\PhpSpreadsheet;
- use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
- class NamedFormula extends DefinedName
- {
- /**
- * Create a new Named Formula.
- */
- public function __construct(
- string $name,
- ?Worksheet $worksheet = null,
- ?string $formula = null,
- bool $localOnly = false,
- ?Worksheet $scope = null
- ) {
- // Validate data
- if (!isset($formula)) {
- throw new Exception('You must specify a Formula value for a Named Formula');
- }
- parent::__construct($name, $worksheet, $formula, $localOnly, $scope);
- }
- /**
- * Get the formula value.
- */
- public function getFormula(): string
- {
- return $this->value;
- }
- /**
- * Set the formula value.
- */
- public function setFormula(string $formula): self
- {
- if (!empty($formula)) {
- $this->value = $formula;
- }
- return $this;
- }
- }
|