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.
--
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
