As an experiment I implemented spreadsheet functionality on a wiki
whereby the calculation is carried out by OpenOffice/Calc:
How does it works?
1. The wiki parser checks for tables like
{| <Calc>
|= 90+12*sin(0.5)
|-
|=A1*A1
|-
|=sum(A1:A2)
|}
2. This table is converted into a html table using the function
dotablestuff.
3. The html table is stored into a special directory.
4. Now the wiki waits.
5. An OpenOffice vb-script checks every second for a table in said
directory.
6. The table is imported into a spreadsheet and the calculation is
automatically done.
7. The vb-script exports a html table.
8. The wiki parser opens the html table and the {| <Calc> ... -table
is replaced by the html table served by OpenOffice/Calc
Having this done it would also be possible to use all the other features
of OpenOffice/Calc like sorting, goal seek, filter, ...
Greetings M. Arndt
Show replies by date