Unique Cell Names
Markers, supporting uid attribute (unique identifier) can be used as named data areas in formulas.
Marker name is unique within the template. If name is used in a few markers, then the result named area will be conclusion totality of these markers. While using uid (unique identifier) in structured markers named areas will be changed according to used context. For example, while using uid in GROUP_CELL group structure, column group area will be limited data of this group, for group – set of data structure. As it shown on picture, Total1_1 is marked green, Total1_2 – yellow, Total1 – green and yellow, Total2 – blue. Common Total is bordered with red frame
Header |
|
Group1 |
|
Group1_1 |
|
uid="cell" |
|
|
|
Total1_1 |
formula="=SUM({cell})" |
Group1_2 |
|
uid="cell" |
|
|
|
Total1_2 |
formula="=SUM({cell})" |
Total1 |
formula="=SUM({cell})" |
Group2 |
|
uid="cell" |
|
|
|
|
|
Total2 |
formula="=SUM({cell})" |
Total |
formula="=SUM({cell})" |
While using uid in PIVOT_CELL summary table structure, header or total series (column) named area will be limited series (column) data. «Cell» named area for series is marked blue, green-for column.
|
col1 |
col2 |
col3 |
|
series1 |
|
|
|
|
series2 |
|
uid="cell" |
|
formula="=SUM({cell})" |
series3 |
|
|
|
|
|
|
formula="=SUM({cell})" |
|
|
As Excel 2003 doesn`t support cell range, consisting of more than 31 parts (Excel 2007 support bigger quantity parts), for merging parts use extra Ranges Layer sheet. Every unique cell name corresponds with column on this sheet.
Examples: Naming.xlsx.
Created with the Personal Edition of HelpNDoc: Create help files for the Qt Help Framework