On Windows platforms, there’s even a button to generate printable story index cards from the backlog items.
However as a Mac (MS office for Mac) user and Linux (OpenOffice/LibreOffice) user I found that the macros simply didn’t work for me, even after a bit of hacking. OpenOffice’s VBA implementation has some interesting incompatibilities with the Microsoft equivalent – and Microsoft, in their infinite wisdom, have removed the VBA support from MS Excel for Mac – and so are pushing me firmly towards an OSS solution.
I also faced an additional challenge: As well as index cards, I also the need to generate a readable PDF version of the document (using data read from the spreadsheet) and the ability to generate a mediawiki page (again using data read from the spreadsheet).
I want a solution that will work both on Linux (ubuntu) and Mac OSX (though the solution I came up with probably ought to work on Windows too).
/---> index cards Spreadsheet ---> \---> mediawiki page \---> PDF document
I wasn’t that attached to having a one-click solution from within the spreadsheet itself – and instead decided to consider writing a set of tools that simply read the data from the master copy in the spreadsheet and transform that into the desired forms.
The first step is to extract data pertaining to the backlog from the spreadsheet.
Subsequently, we will see how this data can then be automatically transformed into a mediawiki page, a pdf file and printable story cards.