|
| __construct (string $name, ?Worksheet $worksheet=null, string $range='A1', bool $localOnly=false, ?Worksheet $scope=null) |
|
| __clone () |
| Implement PHP __clone to create a deep clone, not just a shallow copy.
|
|
| getCellsInRange () |
|
| getLocalOnly () |
| Get localOnly.
|
|
| getName () |
| Get name.
|
|
| getRange () |
| Get the range value.
|
|
| getScope () |
| Get scope.
|
|
| getValue () |
| Get range or formula value.
|
|
| getWorksheet () |
| Get worksheet.
|
|
| isFormula () |
| Identify whether this is a named range or a named formula.
|
|
| setLocalOnly (bool $localScope) |
| Set localOnly.
|
|
| setName (string $name) |
| Set name.
|
|
| setRange (string $range) |
| Set the range value.
|
|
| setScope (?Worksheet $worksheet) |
| Set scope.
|
|
| setValue (string $value) |
| Set range or formula value.
|
|
| setWorksheet (?Worksheet $worksheet) |
| Set worksheet.
|
|
|
static | createInstance (string $name, ?Worksheet $worksheet=null, ?string $value=null, bool $localOnly=false, ?Worksheet $scope=null) |
| Create a new defined name, either a range or a formula.
|
|
static | resolveName (string $definedName, Worksheet $worksheet, string $sheetName='') |
| Resolve a named range to a regular cell range or formula.
|
|
static | testIfFormula (string $value) |
|
|
bool | $isFormula |
| Whether this is a named range or a named formula.
|
|
bool | $localOnly |
| Is the defined named local?
|
|
string | $name |
|
Worksheet | $scope |
| Scope.
|
|
string | $value |
| Value of the named object.
|
|
Worksheet | $worksheet |
| Worksheet on which the defined name can be resolved.
|
|
const | REGEXP_IDENTIFY_FORMULA = '[^_\p{N}\p{L}:, $\'!]' |
|
◆ $localOnly
bool PhpOffice\PhpSpreadsheet\DefinedName::$localOnly |
|
protectedinherited |
Is the defined named local?
(i.e. can only be used on $this->worksheet).
The documentation for this class was generated from the following file:
- lib/phpspreadsheet/phpspreadsheet/src/PhpSpreadsheet/NamedRange.php