* John R. Sowden <[EMAIL PROTECTED]> [240306, 10:21]: > Two application questions using OOo 2.0.0, under Suse 9.3 > [...] > > 2) I have a ledger sheet with a balance column. I test to see if the 'item' > column is blank so I don't run the balance all the way town to row 500, or > whatever. If the item is blank, I make the balance cell blank. > > Problem: I want to put the last balance at the top of the page. How do I > reference the last cell to have data, which is the ending balance? > > Balance Column formula: =if(c5="";"";f4-d5+e5) > c5=item, d is debit, e is credit f is the balance column >
Hi John, have a look at this snippet: <http://codesnippets.services.openoffice.org/Calc/Calc.Erase_create_range_name.snip> may be it does what you're looking for. Regards, Ennio -- [Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?// Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (°|°) [Why use Win$ozz (I say) if ... "even a fool can do that. )=( Do something you aren't good at!" (as Henry Miller used to say) ] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
