Re: [libreoffice-users] Labeling in Calc

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