Description

class Axlsx::DefinedName

This element defines the defined names that are defined within this workbook. Defined names are descriptive text that is used to represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30. A defined name in a formula can make it easier to understand the purpose of the formula. Names are available to any sheet. Names can also be used to represent formulas or values that do not change (constants).

You can also link to a defined name in another workbook, or define a name that refers to cells in another workbook.

A compliant producer or consumer considers a defined name in the range A1-XFD1048576 to be an error. All other names outside this range can be defined as names and overrides a cell reference if an ambiguity exists.

Examples:

The formula =SUM(FirstQuarterSales) might be easier to identify than =SUM(C20:C30
If the name ProjectedSales refers to the range A20:A30 on the first worksheet in a workbook,
you can use the name ProjectedSales on any other sheet in the same workbook to refer to range A20:A30 on the first worksheet.
The name SalesTax can be used to represent the sales tax amount (such as 6.2 percent) applied to sales transactions.
The formula =SUM(Sales.xls!ProjectedSales) refers to the named range ProjectedSales in the workbook named Sales.
For clarification: LOG10 is always a cell reference, LOG10() is always formula, LOGO1000 can be a defined name that overrides a cell reference.

creates a new DefinedName.

Parameters:

  • formula (String)
    • the formula the defined name references

  • options (Hash) (defaults to: {})
    • A hash of key/value pairs that will be mapped to this instances attributes.

  • [String] (Hash)

    a customizable set of options

  • [Boolean] (Hash)

    a customizable set of options

  • [Integer] (Hash)

    a customizable set of options

Returns the value of attribute local_sheet_id

Raises:

  • (ArgumentError)

DefinedName is referenced in 0 repositories