Order of columns/rows

[TomWhitson]

Hi,

Thanks for the development. I have a query regarding the order of columns and rows as I have a scenario whereby a table cell which is dependant on another is not calculating until I perform a second calculate.

Lets say I have a table as below. On the first pass data-cell A1 will be empty, then calling calculate will update it with the correct value.

Changing the order so that the cell is in bottom right instead of top left "fixes" the issue by forcing it to be the last thing calculated. Do we have any functionality to cope with this scenario since I cannot move the order of my cells and calling calculate again will not be good for performance.

<table id="sheet1" style="width:100%;">
    <thead>
        <tr></tr>
        <tr>
            <th>A</th>
            <th>B</th>
            <th>C</th>
        </tr>
    </thead>
    <tbody>
        <tr>
            <td data-cell="a1" data-formula="a2+a3+a4"></td>
            <td data-cell="b1"></td>
            <td data-cell="c1"></td>
        </tr>
        <tr>
            <td data-cell="a2" data-formula="b2*c2"></td>
            <td data-cell="b2">4.23</td>
            <td data-cell="c2">150</td>
        </tr>
        <tr>
            <td data-cell="a3" data-formula="b3*c3"></td>
            <td data-cell="b3">2.23</td>
            <td data-cell="c3">100</td>
        </tr>
        <tr>
            <td data-cell="a4" data-formula="b4*c4"></td>
            <td data-cell="b4">1.23</td>
            <td data-cell="c4">250</td>
        </tr>
    </tbody>
</table>