0
edits
Changes
no edit summary
==Notes==
===Values===
The '''Values''' field allows you define a default template including formatting, formulae and initial values.
'''Sample:'''
<pre>
<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>
</pre>
[[Category:Custom Fields]]
===Values===
The '''Values''' field allows you define a default template including formatting, formulae and initial values.
'''Sample:'''
<pre>
<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>
</pre>
[[Category:Custom Fields]]
