Deprecated - Custom Field Type: Special - Spreadsheet
Notes
Values
The Values field allows you define a default template including formatting, formulae and initial 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.
Sample:
<TABLE border="1px" id="jSheet" class="jSheet ui-widget-content ui-corner-all" style="width: 708px;"> <TR height="30" style="height: 30px;"> <TD height="30" id="cell_c1_r1" class="styleBold styleUpper">Requested Budget</TD> <TD id="cell_c2_r1"/> <TD id="cell_c3_r1"/> <TD id="cell_c4_r1"/> <TD id="cell_c5_r1"/></TR> <TR><TD id="cell_c1_r2">Cost Items</TD> <TD id="cell_c2_r2">Year 1</TD> <TD id="cell_c3_r2">Year 2</TD> <TD id="cell_c4_r2">Year 3</TD> <TD id="cell_c5_r2">Total</TD></TR> <TR style="height: 16px;"><TD style="font-weight: bold;" id="cell_c1_r3">Staff</TD> <TD id="cell_c2_r3"/> <TD id="cell_c3_r3"/> <TD id="cell_c4_r3"/> <TD id="cell_c5_r3" formula="=SUM(B3:D3)"/></TR> <TR style="height: 16px;"> <TD style="font-weight: bold;" id="cell_c1_r4">Equipment</TD> <TD id="cell_c2_r4"/> <TD id="cell_c3_r4"/> <TD id="cell_c4_r4"/> <TD id="cell_c5_r4" formula="=SUM(B4:D4)"/></TR> <TR><TD id="cell_c1_r5">Materials</TD> <TD id="cell_c2_r5"/> <TD id="cell_c3_r5"/> <TD id="cell_c4_r5"/> <TD id="cell_c5_r5" formula="=SUM(B5:D5)"/></TR> <TR><TD style="font-weight: bold;" id="cell_c1_r6">Travel</TD> <TD id="cell_c2_r6"/> <TD id="cell_c3_r6"/> <TD id="cell_c4_r6"/> <TD id="cell_c5_r6"/> <TD id="cell_c6_r6" formula="=SUM(B6:D6)"/></TR> </TABLE>