When first start working with aPriori spreadsheet reports, it is best to begin with the simple snippets based on the samples shown in this document: Creating a Custom Spreadsheet Report
The system-defined spreadsheet report files that are installed as part of aPriori may contain advanced features that are not meant to be used for custom reports, and which are not documented.