I have finally gotten around to publishing my income statement from check register for multiple activities in one account in an Open Document Spreadsheet (.ods). I have made a few improvements from the version I made in Excel, mostly around making the year of the income statement another factor in the equation so that you can record information for more than one year into the check register and pull each year separately by changing the date on the income statement. I tried to also integrate the pivot table version of the spreadsheet, but I have found that Open Office does not seem to have an equivalent to the getpivotdata() function. However, the array function seems to work with less latency in Open Office than it did in Excel, except when changing the year on the income statement.
Let me know if you have any comments, questions or suggestions!