Am 03.02.2012 21:18, Dan Lewis wrote:
Might there be another method? I just unzipped a Calc spreadsheet.
Then I looked at the Context.xml. I found:
"
Well, for someone who loves when others write free code, using a text
editor is totally inacceptable.
A double-click on the sheet tab is t
On Fri, 2012-02-03 at 20:45 +0100, Andreas Säger wrote:
> Am 03.02.2012 20:27, Tom wrote:
> > Hi :)
> > So really all you need is a translation of the Excel macro below. Calc uses
> > a completely different language, or at least different enough that the below
> > coding wont work.
> > Regards fro
Am 03.02.2012 20:27, Tom wrote:
Hi :)
So really all you need is a translation of the Excel macro below. Calc uses
a completely different language, or at least different enough that the below
coding wont work.
Regards from
Tom :)
Meanwhile you should know that the language is more or less the
Hi :)
If one or 2 individuals can't do a neat macro they don't need to but other
people have been know to generously show they can do neat little bits for
people.
Regards from
Tom :)
--
View this message in context:
http://nabble.documentfoundation.org/Renaming-Tabs-in-a-spreadsheet-in-bulk-tp371
Am 03.02.2012 17:06, Gordon Burgess-Parker wrote:
But it fell over on the bolded portion. I'm not a macro person and this
was copied from one in Excel that worked OK.
Anyone tell me what I need to replace the bolded bit with?
Please, do us all a favour and run Excel.
--
For unsubscribe instr
On 03/02/2012 19:25, Andreas Säger wrote:
Am 03.02.2012 20:02, Gordon Burgess-Parker wrote:
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
Hi :)
So really all you need is a translation of the Excel macro below. Calc uses
a completely different language, or at least different enough that the below
coding wont work.
Regards from
Tom :)
Gordon Burgess-Parker wrote
>
> I tried adding this Macro:
>
> Sub Rename_Tabs()
> Dim x As L
On 03/02/2012 19:25, Andreas Säger wrote:
Am 03.02.2012 20:02, Gordon Burgess-Parker wrote:
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
Am 03.02.2012 20:02, Gordon Burgess-Parker wrote:
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...
This is not a re
On 03/02/2012 19:12, Tom Davies wrote:
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 pa
wrote:
From: Gordon Burgess-Parker
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,
>&g
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 20
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
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 d
Dne 3.2.2012 16:50, Andreas Säger napsal(a):
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 manual
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 ac
16 matches
Mail list logo