0
edits
Changes
no edit summary
==Notes==
===ValuesTemplate===The '''Values''' field allows you define a default template including formatting, formulae and initial default values.
* The default template can be created by creating a record that contains a '''Spreadsheet''' custom field. Create the spreadsheet as desired, including any formatting, formulas and initial values. Then from the Spreadsheet menu select '''View''' and then '''Source'''. The HTML shown can be copied and pasted into the '''Values''' field.
</pre>
===Variables===
The data stored within cells on the spreadsheet can be referenced as [[Variables]] in [[Read Only - System Variables]] fields, [[Web Page View]]s etc:
'''Syntax:'''
*Single Cell:
:<font size=3>@sps.''fieldname''.B2@</font>
*Range of Cells:
:<font size=3>@sps.''fieldname''.A1:C1@</font>
:<font size=3>@sps.''fieldname''.A1:C3@</font>
'''Where:''' ''fieldname'' is the name of the '''Spreadsheet''' custom field.
[[Category:Custom Fields]]