Friday, December 23, 2011

Open Office version of BoardOff

I've had a few emails from people asking if BoardOff will run on any of the free spreadsheet programs. I've had a bit of time on OpenOffice Calc but never for macro creation and so I did not realise that it actually implements a version visual basic for apps (VBA) called OpenOffice Basic which is very close to MS VBA.

I did a trial conversion over to openoffice and found that 2 key objects are implemented differently. The Range Object and the Application Object. The range object does have the row count property used in the SPLINE function in BoardOff but its a simple matter to fix that. Once that is done all the calculations work!!!!

There are a few things to iron out (charting on multiple axis screws up and the load,save, merge dialog boxes need to be convert to the Oo equivalents and the macro buttons need to be re-added).

I don't think this is a big job and so I will have a crack at it over the next week or so and see if I can't get an Oo version out there. This should make it possible to use BoardOff on Mac's and Linux machines as well.

I'm also toying with the idea of making a web-based version of board off to get a community of ideas and designs going online so we can compare and share designs. It would also create a change to make BoardOff more user friendly


No comments :

Post a Comment