Question

A TWikiApplication providing a useful MashUp of the SpreadSheetPlugin, CommentPlugin and the EditTablePlugin. Useful for keeping a checkbook style account balance.

See working example at Codev.AccountLedgerApp.

-- KeithHelfrich - 11 Dec 2006

Answer

If you answer a question - or someone answered one of your questions - please remember to edit the page and set the status to answered. The status selector is below the edit box.

Hi, I have fixed your table above. If you have empty cells or cells contains "0" only, you have to use the $VALUE() method from SpreadSheetPlugin to get the representing number value from a string. Hope that answers your question

-- ThomasFreudenberg - 12 Dec 2006

Additional comments:

• When you use an EditTablePlugin table, use label type for the column with the CALC.
• To type less, you can define a BALANCE topic preferences setting containing the formula, and use it in the table cell, such as | %CALC{ %BALANCE% }% |

-- PeterThoeny - 12 Dec 2006

Thanks guys. This is working correctly in my own twiki on CairoRelease. But for some reason when I drop the same code here into twiki.org, the label does not insert correctly into the balance field when adding a new row.

To duplicate the problem, add a row to the #Example above.

-- KeithHelfrich - 12 Dec 2006

I fixed the example. As (somewhat) documented in EditTablePlugin, you need to escape the variables in the format parameter, e.g.: $percntCALC{ $percntBALANCE$percnt }$percnt

-- PeterThoeny - 12 Dec 2006

Ah, now I'm remembering my comment from 20 Nov 2006 in EliminateNeedForEscapes Thanks so much peter. The escaped version also works in CairoRelease, so this is what we'll stick with. I'll move this topic to the Codev web for greater visibility - in case it could be improved upon.

-- KeithHelfrich - 12 Dec 2006

This mashup could be improved with a custom CommentPlugin template to easily add a table row. See example at EditActionItems.

-- PeterThoeny - 31 Dec 2007

Ähm, this already has been implemented as custom CommentPlugin template months ago.

-- FranzJosefGigler - 01 Jan 2008

Where? I only see an "add line item" button that edits the table. What I was suggesting is to add a custom input form to add an item in one step.

-- PeterThoeny - 01 Jan 2008

You mean like in Codev.AccountLedgerApp ?

-- FranzJosefGigler - 01 Jan 2008

I removed outdated example on this page; added pointer to example in Codev web.

-- PeterThoeny - 01 Jan 2008