onn
Show profile
Link to this post
Subject: Basic Excel/Calc-like functionality in tables
It would be extremely usefull to have basic spreadsheet functionality in dokuwiki tables.
By basic, I mean exactly such simple syntax as:
And... it would be a miracle plugin, if it could also do this:
...with the name (here: budget) based on the A1 (user can make it span along all table as header, ^header^^^^^).
Plugin will likely need some method to detect looped equations (like A1 "= A2" and then A2 "= A1") or to be just loop-proof (Time-of-Life limited recurrency).
...some AJAX-based "click-and-edit-table-cell" would be marvellous :> (joke!) (...or who knows?)
By basic, I mean exactly such simple syntax as:
= A1 // standard
= C9 / (A1 - A2 ) // standard
= SUM(B) // sum of all numbers in column B
= SUM(3) // sum of all numbers in row 3
= B#1 // like standard, but with backward row counting (this: last value from col. B)
= #B1 // like standard, but with backward column counting (this: second last value from row. 1)
= C9 / (A1 - A2 ) // standard
= SUM(B) // sum of all numbers in column B
= SUM(3) // sum of all numbers in row 3
= B#1 // like standard, but with backward row counting (this: last value from col. B)
= #B1 // like standard, but with backward column counting (this: second last value from row. 1)
And... it would be a miracle plugin, if it could also do this:
= budget.A4 - A1 // A4 from table 'budget' - A1 from this table (all on this page)
= budget.A4 - budgets:2008.budget.A4 // A4 from table 'budget' - A4 from table ''budget'' on ''budgets:2008''
= budget.A4 - budgets:2008.budget.A4 // A4 from table 'budget' - A4 from table ''budget'' on ''budgets:2008''
...with the name (here: budget) based on the A1 (user can make it span along all table as header, ^header^^^^^).
Plugin will likely need some method to detect looped equations (like A1 "= A2" and then A2 "= A1") or to be just loop-proof (Time-of-Life limited recurrency).
...some AJAX-based "click-and-edit-table-cell" would be marvellous :> (joke!) (...or who knows?)
This post was edited on 2009-04-24, 19:57 by