Information relating to a named reference, formula, macro, etc.
This is a convenience method for the use case where the name refers to one rectangular area in one worksheet.
Parameters: |
|
---|---|
Returns: | a tuple (sheet_object, rowxlo, rowxhi, colxlo, colxhi). |
0 = Formula definition; 1 = Binary data
No examples have been sighted.
0 = User-defined name; 1 = Built-in name
(common examples: Print_Area, Print_Titles; see OOo docs for full list)
This is a convenience method for the frequent use case where the name refers to a single cell.
0 = Simple formula; 1 = Complex formula (array formula or user defined)
No examples have been sighted.
0 = Command macro; 1 = Function macro. Relevant only if macro == 1
Function group. Relevant only if macro == 1; see OOo docs for values.
0 = Visible; 1 = Hidden
0 = Standard name; 1 = Macro name
A string. If builtin, decoded as per OOo docs.
The index of this object in book.name_obj_list
An 8-bit string.
The result of evaluating the formula, if any. If no formula, or evaluation of the formula encountered problems, the result is None. Otherwise the result is a single instance of the Operand class.
Value | Description |
---|---|
-1 | The name is global (visible in all calculation sheets). |
-2 | The name belongs to a macro sheet or VBA sheet. |
-3 | The name is invalid. |
0 .. nsheets | The name is local to the sheet whose index is scope. |
0 = Sheet macro; 1 = VisualBasic macro. Relevant only if macro == 1