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>