Features / Usability

Features / Usability

Spreadsheets: Replicating formulas with locked cells

posts: 32

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!