Difference between revisions of "Deprecated - Custom Field Type: Special - Spreadsheet"

Revision as of 14:52, 20 May 2010

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>