Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 133
Default Ribbon in Excel 2007: positioning buttons using box controls

I'm trying to position 5 buttons in a group:
2 vertically on the left, 2 vertically on the right, and one below.

The code below places the last button on the far right and I'm
wondering what I can do to fix this. I realise that I can set the
boxStyle to horizontal and rearrange the buttons, but I'm trying to
keep them grouped in a logical fashion as above. If all else fails, I
will revert to this, but I would have thought there'd be a solution.
Any suggestions appreciated.

Thanks in advance

Paul Martin
Melbourne, Australia
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 133
Default Ribbon in Excel 2007: positioning buttons using box controls

I forgot to post my code:

<group id="Import" label="Import"

<box boxStyle="vertical" id="box1"
<button id="buttonL1" label="Left Top" onAction="DoSomething"/
<button id="buttonL2" label="Left Middle" onAction="DoSomething"/
</box

<box boxStyle="vertical" id="box2"
<button id="buttonR1" label="Right Top" onAction="DoSomethingy"/
<button id="buttonR2" label="Right Middle" onAction="DoSomething"/
</box

<button id="buttonB" label="Bottom" onAction="DoSomething"/

</group
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,489
Default Ribbon in Excel 2007: positioning buttons using box controls

Hi,

This forces the middle button to the third row. Remove label items if you
want to raise the middle button.

<!--RibbonX Visual Designer 1.7 for Microsoft Excel. XML Code produced on
2009/12/21--
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
<ribbon
<tabs
<tab idMso="TabHome"
<group
id="Group1"
label="Group1"
<box
boxStyle="vertical"
id="Box1"
<button
id="Button1"
label="Top Left"/
<button
id="Button2"
label="Bottom Left"/
<box
boxStyle="vertical"
id="Box2"
<labelControl
id="Labelcontrol1"
label="Labelcontrol1"
showLabel="false"/
<labelControl
id="Labelcontrol2"
label="Labelcontrol2"
showLabel="false"/
<button
id="Button3"
label="Middle"/
</box
<box
boxStyle="vertical"
id="Box3"
<button
id="Button4"
label="Top Right"/
<button
id="Button5"
label="Bottom Right"/
</box
</box
</group
</tab
</tabs
</ribbon
</customUI

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Paul Martin" wrote in message
...
I'm trying to position 5 buttons in a group:
2 vertically on the left, 2 vertically on the right, and one below.

The code below places the last button on the far right and I'm
wondering what I can do to fix this. I realise that I can set the
boxStyle to horizontal and rearrange the buttons, but I'm trying to
keep them grouped in a logical fashion as above. If all else fails, I
will revert to this, but I would have thought there'd be a solution.
Any suggestions appreciated.

Thanks in advance

Paul Martin
Melbourne, Australia


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 133
Default Ribbon in Excel 2007: positioning buttons using box controls

Thanks Andy, but that doesn't quite solve the problem. Or, it solves
one but creates another, because it spreads the width of the group by
inserted a middle column. Effectively, that XML creates 3 columns,
each 3 rows. What I want is 2 columns that are each 2 rows, with a
single row (but 2 columns wide) underneath in the third row.

You did get me thinking about boxes and I thought the code below would
solve the problem, but it doesn't. It still places the final button
into a third column. What this code attempts is to put the two
vertical boxes into a horizontal box, with a button below that (and
putting the button into a box does nothing, as you'd expect).

Any other suggestions?

Paul

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/
customui"
<ribbon
<tabs
<tab idMso="TabHome"
<group id="grp1" label="Test"

<box boxStyle="vertical" id="box1"
<box id="box2"
<box boxStyle="vertical" id="box3"
<button id="btn1" label="Top L"/
<button id="btn2" label="Mid L"/
</box

<box boxStyle="vertical" id="box4"
<button id="btn3" label="Top R"/
<button id="btn4" label="Mid R"/
</box
</box

<button id="btn5" label="Bottom"/
</box

</group
</tab
</tabs
</ribbon
</customUI
  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 133
Default Ribbon in Excel 2007: positioning buttons using box controls

As an aside, I've been playing around with Button Groups and Buttons.
Inserting 3 Button Groups "sort of" addresses the problem by placing
the buttons in roughly the configuration I'm after. But there's two
drawbacks:
1). The RHS buttons on the top and middle rows are not left justified.
2). The buttons appear with the button image.

1) could be fixed by buffering the LHS with spaces. Not ideal, but it
would do the trick.
2) doesn't seem to have any workaround.

All-in-all, this is not an adequate solution, so... I'm still looking.


  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,489
Default Ribbon in Excel 2007: positioning buttons using box controls

Try this, still a work around.

3 horizontal boxes within a vertical box.
Rather than padding the buttons with leading spaces I used a label control
to pad the area between the buttons for the top and middle section.
For the Bottom section the labels pad around the button to center it.

<!--RibbonX Visual Designer 1.7 for Microsoft Excel. XML Code produced on
2009/12/23--
<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"
<ribbon
<tabs
<tab
id="Tab1"
label="Tab1"
<group
id="Group1"
label="Group1"
<box
boxStyle="vertical"
id="Box1a"
<box
boxStyle="horizontal"
id="Box2a"
<button
id="Button1"
label="Top Left"/
<labelControl
id="Labelcontrol1"
label=" "/
<button
id="Button2"
label="Top Right"/
</box
<box
boxStyle="horizontal"
id="Box3a"
<button
id="Button3"
label="Middle Left"/
<labelControl
id="Labelcontrol2"
label=" "/
<button
id="Button4"
label="Middle Right"/
</box
<box
boxStyle="horizontal"
id="Box4a"
<labelControl
id="Labelcontrol3"
label=" "/
<button
id="Button5"
label="Button Across Bottom "/
<labelControl
id="Labelcontrol4"
label=" "/
</box
</box
</group
</tab
</tabs
</ribbon
</customUI

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Paul Martin" wrote in message
...
As an aside, I've been playing around with Button Groups and Buttons.
Inserting 3 Button Groups "sort of" addresses the problem by placing
the buttons in roughly the configuration I'm after. But there's two
drawbacks:
1). The RHS buttons on the top and middle rows are not left justified.
2). The buttons appear with the button image.

1) could be fixed by buffering the LHS with spaces. Not ideal, but it
would do the trick.
2) doesn't seem to have any workaround.

All-in-all, this is not an adequate solution, so... I'm still looking.


  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 133
Default Ribbon in Excel 2007: positioning buttons using box controls

Thanks, Andy (and happy new year - I just got back from my holidays).
I think your suggestion might suit some who come looking for a similar
solution, but it's a bit messy for me because:
1). The padding can emulate left justification for the RHS buttons but
is fiddly
2). I wanted to group certain buttons together, which this doesn't do.

In the end, it's easier just to add the buttons without any boxes so
that the first two are vertically adjacent, the bottom button is below
that and then the next two buttons are automatically in the next
column, also vertically adjacent. It seems a pity that there's not
better control over the placement of the buttons.

Thanks again

Paul
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not all Ribbon Buttons are available in Excel 2007 Bill Excel Discussion (Misc queries) 4 May 14th 09 03:47 PM
How to get Ribbon Controls on Context menu in Office Excel 2007 sang Excel Programming 1 January 28th 09 08:23 PM
QAT Buttons and Ribbon Issues in Excel 2007 Ailish Excel Discussion (Misc queries) 1 May 9th 08 06:02 PM
How can I create custom controls on the ribbon in Excel 2007? XP Excel Programming 1 March 31st 08 07:15 PM
Excel 2007 Ribbon Check custom buttons Alice[_7_] Excel Programming 6 April 22nd 07 01:58 PM


All times are GMT +1. The time now is 03:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"