Here is a scenario that I am trying to deal with in a Calc spreadsheet:
(1) Every year Bill and Nancy measure the weights and heights of four
(2) The four people being measured are Fred, Joe, Alice, and Beatrice.
Right now the measurements for two years, 2008 and 2009, have been entered
into this spreadsheet:
ODS file (https://min.us/muyVAlDHC)
As you can see, right now this information is organised in the spreadsheet
by multiple subheadings. The problem is that I am having a hard time getting
Calc to filter and sort this information. For example, I don't know how to
ask Calc to sort the rows by the height measured by Bill in 2009. The sort
function in the data menu seems to expect that there is only one heading,
and not multiple "layers" of headings arranged in rows.
Another issue is that this spreadsheet might become unwieldy when more
measurers (in addition to Bill and Nancy) start in, say, 2012, or when more
subjects are added after the first four.
I realise Calc can maintain multiple sheets in a file, and it also has some
basic database capabilities. Can anyone provide recommendations on how to
enhance my current sheet so that it is scalable and more easilty queried?
View this message in context:
Sent from the Users mailing list archive at Nabble.com.
For unsubscribe instructions e-mail to: firstname.lastname@example.org
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
- [libreoffice-users] Maintaining Calc spreadsheet w/ multiple headers/subheaders · avamk
Impressum (Legal Info)
: 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