Hi :) Yes, i think these guys are talking about data-storage and ignoring accountancy principles. Most places i have seen have different tabs for different months or for different quarters and that allows reports to show bank reconciliations, outstanding payments, prepayments, accruals for a set date without those figures then getting messed-up by subsequent postings.
It's just that we have had a lot of posts about databases recently which is an area we need to get more development work going on. Apols and regards from Tom :) --- On Fri, 3/2/12, Gordon Burgess-Parker <gbpli...@gmail.com> wrote: From: Gordon Burgess-Parker <gbpli...@gmail.com> Subject: Re: [libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk. To: users@global.libreoffice.org Date: Friday, 3 February, 2012, 19:02 On 03/02/2012 18:59, Gordon Burgess-Parker wrote: > On 03/02/2012 18:05, Stefan Weigel wrote: >> Hi, >> >> Am 03.02.2012 16:50, schrieb Andreas Säger: >> >>> Am 03.02.2012 16:05, Gordon Burgess-Parker wrote: >>>> I have a spreadsheet that is used for monthly and annual >>>> collection of >>>> data, with monthly tabs, Jan 2011, Feb 2011 etc. >>>> Is there a way to rename 2011 to 2012 in bulk, or do I have to do >>>> each >>>> one manually? >>> Splitting up equally structured data across many sheets is *always* >>> a huge mistake. Don't do that. >> Yes, can´t confirm this strong enough! >> >> Have a look into Calc Guide Chapter 8 >> (http://www.libreoffice.org/get-help/documentation/#cg), especially >> read the third rule on page 24. >> >> Cheers, >> Stefan >> >> > Yeah. OK. As someone who has been a Systems and Management Accountant (NOT a > pseudo-database administrator) for 30 years and has used spreadsheets at > advanced level with separate tabs for calendar-month data (as have all the > colleagues I have worked with over that period in many different > organisations) this is all very interesting but totally irrelevant to my > question. > And as an addendum, I have a similar sheet in Excel. I asked the same question in the MS Excel forum and was immediately given a macro by an Excel specialist to do this without any lecturing on my method of data collection... -- For unsubscribe instructions e-mail to: users+h...@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 -- For unsubscribe instructions e-mail to: users+h...@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