Deprecated - Custom Field Type: Special - Spreadsheet
Notes
Values
The Values field allows you define a default template including formatting, formulae and initial values.
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>