We are using Tiki12.
As in Excel worksheets, formulas can be replicated in next cells by simply dragging the small square icon at the bottom-left corner of a cell. The corresponding free cells (not locked by $) will change accordingly.
However, replicating formula cells across a column is NOT possible when there are locked cells of type $D2 or $D$3 used in the formula. For e.g. =$D$3*E3+C$4 will fail with errors.
In this case, you will need to copy & paste by hand the formula in each cell and change the numbering of the free cells (here E3 to E4, E5, and so on ...).
Check the update here: http://doc.tiki.org/Spreadsheet+Interface
Question: Is there a workaround to this issue? Please share.
If not, can this be posted as an improvement for future releases?
Thanks in advance!