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 <[email protected]> To: LibreOffice <[email protected]> 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 <[email protected]> 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: [email protected] 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
