Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index

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 

For dates you could try typing in 
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 <>
To: LibreOffice <> 
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 <> 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:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.