[Summary view]

Differences Between: [Versions 311 and 400] [Versions 311 and 401] [Versions 311 and 402] [Versions 311 and 403]

   1  <?php
   2  
   3  namespace PhpOffice\PhpSpreadsheet;
   4  
   5  use PhpOffice\PhpSpreadsheet\Worksheet\Worksheet;
   6  
   7  class NamedFormula extends DefinedName
   8  {
   9      /**
  10       * Create a new Named Formula.
  11       */
  12      public function __construct(
  13          string $name,
  14          ?Worksheet $worksheet = null,
  15          ?string $formula = null,
  16          bool $localOnly = false,
  17          ?Worksheet $scope = null
  18      ) {
  19          // Validate data
  20          if (empty($formula)) {
  21              throw new Exception('You must specify a Formula value for a Named Formula');
  22          }
  23          parent::__construct($name, $worksheet, $formula, $localOnly, $scope);
  24      }
  25  
  26      /**
  27       * Get the formula value.
  28       */
  29      public function getFormula(): string
  30      {
  31          return $this->value;
  32      }
  33  
  34      /**
  35       * Set the formula value.
  36       */
  37      public function setFormula(string $formula): self
  38      {
  39          if (!empty($formula)) {
  40              $this->value = $formula;
  41          }
  42  
  43          return $this;
  44      }
  45  }