Re: [libreoffice-users] Re: Renaming Tabs in a spreadsheet in bulk.

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 <gbplinux@gmail.com> wrote:

From: Gordon Burgess-Parker <gbplinux@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+help@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+help@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