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