Re: [libreoffice-users] Labeling in Calc

2012-07-20 Thread Andrew Brager

Nevermind, I figured it out.

In case anyone else has a similar desire and wants to know...  I simply 
select all the rows I want to belong to a group, add a border around it 
all, and insert a row above the box I just made. The inserted box 
contains the label I want; I make sure to turn off word wrapping for 
that one cell.



On 7/20/2012 12:57 PM, Andrew Brager wrote:
Using Calc, I need a way to specify that a group of rows all belong 
together/have the same title.


For example.  Say I have a bank that has multiple branches.  Each 
branch has it's own name like "southwest branch", but they're all part 
of the same bank - Bank of America perhaps.  Each branch has it's own 
row containing branch name, address, phone, etc. but I need a way to 
tie them all together as being Bank of America, ideally without 
creating a column that is repeated for all rows.


That way, as I'm scanning down the page, I can choose a particular 
bank and then select a specific branch of that bank.


I've tried using the Group function which I kind of like, however 
there's no way I can find to label the group itself with the bank 
name.  I have to open each group and _still _don't necessarily know 
which bank it is.


I've got a picture in my head that looks like a box which contains all 
the rows, and the box itself has a caption with the bank name. I'm 
open to any solution especially a better one.


Using a database is not an option.

Thank you in advance




--
Andrew Brager
Green Gold Real Estate
1331 Cottonwood Rd
Bakersfield, CA 93307
661 412 3304


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



[libreoffice-users] Labeling in Calc

2012-07-20 Thread Andrew Brager
Using Calc, I need a way to specify that a group of rows all belong 
together/have the same title.


For example.  Say I have a bank that has multiple branches.  Each branch 
has it's own name like "southwest branch", but they're all part of the 
same bank - Bank of America perhaps.  Each branch has it's own row 
containing branch name, address, phone, etc. but I need a way to tie 
them all together as being Bank of America, ideally without creating a 
column that is repeated for all rows.


That way, as I'm scanning down the page, I can choose a particular bank 
and then select a specific branch of that bank.


I've tried using the Group function which I kind of like, however 
there's no way I can find to label the group itself with the bank name.  
I have to open each group and _still _don't necessarily know which bank 
it is.


I've got a picture in my head that looks like a box which contains all 
the rows, and the box itself has a caption with the bank name. I'm open 
to any solution especially a better one.


Using a database is not an option.

Thank you in advance

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