Re: [libreoffice-users] Calc - Amortization

Hi :)
You are welcome :)  I wanted to try the template idea but i've never been much good with them and 
managed to stuff-up this one too.  I tend to find it easier to build it from scratch for myself 
because then when it goes wrong i sometimes have a vague idea what i did wrong and it's easier to 
quickly scroll through the cells checking that one doesn't suddenly leap out as being blatantly 
wrong.  

For dates you could try typing in 
January
February
and maybe do March too, just to give Calc an even bigger hint, and then select all the cells you 
just filled in with the date and use the little black square again to drag down and it 'should' 
pick-up the pattern and fill in the rest of the months.  

I put "should" in sarcastic quotes because in life in general i find there is often a huge 
disconnect between what "should be" and "what is" (in BattleStar Galactica they say "the truth on 
the ground" (ironically)).  Sometimes programs guess at the continuation really easily but that 
would usually be when you really wanted the 2 months to be cycled endlessly making it impossible to 
get jan, feb, jan, feb ... and then it learns that just in time for you to really need it to list 
all the months.  Still, it's worth a try because it really 'should' work the way you need and it's 
easy enough to try extending it for a few cells as a test-run.  Other good tools for this are 
copy&paste from the mouse's right-click menu or using the keyboard short-cuts 
Ctrl x = cut  (x looks a bit like scissors?)
Ctrl c = copy  (c stands for copy)
Ctrl v = paste (err, happens to be nearby)
or a combination of the different copy&paste methods.  

Regards from 
Tom :)  



________________________________
 From: John Jason Jordan <johnxj@comcast.net>
To: LibreOffice <users@global.libreoffice.org> 
Sent: Wednesday, 9 October 2013, 0:02
Subject: Re: [libreoffice-users] Calc - Amortization
 

On Tue, 8 Oct 2013 18:05:54 +0100 (BST)
Tom Davies <tomdavies04@yahoo.co.uk> dijo:

> Going with the line-by-line approach but with a fast twist.  

Thanks, that worked great - all except for the dates column. But I can
just enter the date manually for the first of each year and leave the
rest of the months blank - it's easy enough to count down from January
if I need a month in the middle.
-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted