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

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