Proyectos de Subversion Moodle

Rev

| Ultima modificación | Ver Log |

Rev Autor Línea Nro. Línea
1 efrain 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 (!isset($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 
}