Yousaf wrote:
> How can i get MS Excel like formulas in Java Script
> so that my webpage controls get updated when their
> value changes based on the formula specified.
You could use Excel's formula notation in the base code and the
calculations auto-update:
<object classid="CLSID:0002E510-0000-0000-C000-000000000046"
id="obj">
<param name="HTMLData" value="<table>
<tr>
<td>26</td>
<td>4</td>
<td>6</td>
<td>=(A1+B1)/C1</td>
</tr>
</table>">
</object>
To update a formula, here e.g. from '(A1+B1)/C1' to 'A1-B1':
<script type="text/javascript">
obj.HTMLData =
'<table><tr><td>26</td><td>4</td><td>6</td><td>=A1-B1</td></tr></
table>'
</script>
Hope this helps,
--
Bart
|