Spreadsheets: Replicating formulas with locked cells
Hello all,
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!
;){kind=link}
;){kind=link}