I'm using the PHP library TinyButStrong with the plugin OpenTBS to merge existing Excel (or OpenOffice Calc) spreadsheets with data from a database.
This works fine, but I can't figure out how to define summaries for a column.
For example , I define cell A1 as the cell that merges with the data. After the merge, rows are inserted for A2, A3, etc.
The problem is that I don't know beforehand how many rows are going to be inserted, so it's not an option to leave 10 rows empty, and define A11 as the summary field, because it could also be 100 rows of data, and I want the summary directly below the last row of data.
Any ideas?