ExVEx.OOXML.Workbook.DefinedName (ExVEx v0.2.0)

Copy Markdown View Source

A single <definedName> record from xl/workbook.xml. Named ranges and named formulas live here.

scope is :global for workbook-wide names or a sheet index ({:sheet, sheet_id}) for sheet-local names. The reference string is stored verbatim — static cell ranges ("Sheet1!$A$1:$A$10") and dynamic formulas ("=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)") are both supported; Excel evaluates them when the file is opened.

Summary

Types

scope()
t()

Types

scope()

@type scope() :: :global | {:sheet, non_neg_integer()}

t()

@type t() :: %ExVEx.OOXML.Workbook.DefinedName{
  hidden: boolean(),
  name: String.t(),
  reference: String.t(),
  scope: scope()
}