On 11/08/2012 06:45 AM, Paul Stear wrote:
I have the same spreadsheet set I use each year.
The new spreadsheet for 2013 will need to reference fields in the 2012
spreadsheet.
='file:///home/fred/Generation Readings-2012.ods'#$Jan.A68
The 2012 spreadsheet is referenced to 'file:///home/fred/Generation
Readings-2011.ods'#$Jan.A68
For the past few years I have manually changed the Readings-2012 in every
instance (well over 100)
I would like to be able to construct the spreadsheets with a method to change
the current year, eg 2013 minus 1 to give 2012 inserted so that the ref in the
2013 spreadsheet reads;-
='file:///home/fred/Generation Readings-2012.ods'#$Jan.A68
Is this possible?
Thanks for any help
regards
Paul
I don't know if you attached a file with your email or not. If you
did, it was stripped by the mailing list. So, in other words, no one on
the list can access a file to see what you describe in a Calc file.
Since I'm into databases, I'm wondering if your data would be
better served creating a database to hold it. Not knowing how many sheet
your file contains nor what the columns are and what format each column
use. (I'm guessing that you use one sheet per year.) So, it would be
impossible to make any detailed comments.
From personal experience, a database would require less time to
maintain than your present speadsheet. With a little bit of work, all
your data could be entered into a database.
Could we have more information, please?
--Dan
--
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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.