Codejock Forums Homepage
Forum Home Forum Home > Codejock Products > ActiveX COM > Command Bars
  New Posts New Posts RSS Feed - Excel 2007 Number Format Combo box
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Excel 2007 Number Format Combo box

 Post Reply Post Reply
Author
Message
indices View Drop Down
Groupie
Groupie


Joined: 21 September 2007
Location: India
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote indices Quote  Post ReplyReply Direct Link To This Post Topic: Excel 2007 Number Format Combo box
    Posted: 05 October 2007 at 4:26pm
How can I recreate the Excel 2007 Number format combo box which displays icons and additional description when the user clicks on the drop down?
 
Thanks.
Back to Top
indices View Drop Down
Groupie
Groupie


Joined: 21 September 2007
Location: India
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote indices Quote  Post ReplyReply Direct Link To This Post Posted: 18 October 2007 at 3:03pm
For the record I managed to fake this by a custom size icon and writting the caption onto it at runtime.
Back to Top
Oleg View Drop Down
Admin Group
Admin Group


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 11234
Post Options Post Options   Thanks (0) Thanks(0)   Quote Oleg Quote  Post ReplyReply Direct Link To This Post Posted: 19 October 2007 at 1:09am
Hi,
 
For next release we added support of xtpButtonIconAndCaption for gallery control.
Oleg, Support Team
CODEJOCK SOFTWARE SOLUTIONS
Back to Top
indices View Drop Down
Groupie
Groupie


Joined: 21 September 2007
Location: India
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote indices Quote  Post ReplyReply Direct Link To This Post Posted: 19 October 2007 at 9:11am

Hi Oleg,

I upgraded to 11.2.0 which had the new ListIconID property for combo box. But it doesn't seem to work as expected.

Const ID_AUDIO_TYPE_WAV=3000
Const ID_AUDIO_TYPE_MP3=3001
Const ID_AUDIO_TYPE_WMA=3002
Const ID_AUDIO_TYPE=2999

Dim oCb As XtremeCommandBars.CommandBarComboBox
   
Set oCb = GroupEncode.Add(XtremeCommandBars.XTPControlType.xtpControlComboBox, ID_AUDIO_TYPE, "")
    With oCb
        .ListIconId = ID_AUDIO_TYPE_WAV
        .AddItem "Encode As WAV"
        .AddItem "Encode As MP3"
        .AddItem "Encode As WMA"
        .ListIndex = 1
        .Style = xtpButtonIconAndCaption
        .Width = 150
    End With
 
 
The Commandbar is associated with an imagemanager control containing icons for the respective IDs.
 
At runtime, the icon appears only on the last item in the dropdown and also it displays the wrong icon. It displays the icon for the 1st item for the last item.
 
Here is the runtime snapshot.
http://img141.imageshack.us/img141/5510/runtimeht6.jpg
 
What am I doing wrong?
Thanks
 
 
Back to Top
Oleg View Drop Down
Admin Group
Admin Group


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 11234
Post Options Post Options   Thanks (0) Thanks(0)   Quote Oleg Quote  Post ReplyReply Direct Link To This Post Posted: 19 October 2007 at 3:25pm
Hi,
ListIconID specify base id - for first item. So obviously you have icon for ID_AUDIO_TYPE_WMA id but not for ID_AUDIO_TYPE_WAV and ID_AUDIO_TYPE_MP3
Oleg, Support Team
CODEJOCK SOFTWARE SOLUTIONS
Back to Top
indices View Drop Down
Groupie
Groupie


Joined: 21 September 2007
Location: India
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote indices Quote  Post ReplyReply Direct Link To This Post Posted: 20 October 2007 at 8:10am

One further clarification, the release notes for 11.2.0 has:

5 New feature CommandBarComboBox::ThemedItems propety added, Added support of Office2007 items style

Is it the same style as the one obtained using the code above or is it something more? It is possible to force a line break for a item caption? 

Thanks.
Back to Top
Oleg View Drop Down
Admin Group
Admin Group


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 11234
Post Options Post Options   Thanks (0) Thanks(0)   Quote Oleg Quote  Post ReplyReply Direct Link To This Post Posted: 22 October 2007 at 2:31am
Hi,
Yes this is Office2007 style in screenshot.
Oleg, Support Team
CODEJOCK SOFTWARE SOLUTIONS
Back to Top
indices View Drop Down
Groupie
Groupie


Joined: 21 September 2007
Location: India
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote indices Quote  Post ReplyReply Direct Link To This Post Posted: 24 October 2007 at 7:41pm
>For next release we added support of xtpButtonIconAndCaption for gallery control.
 
Is this going to be in 11.2.1?
Will it be possible to create a gallery like this image?
http://img99.imageshack.us/img99/3229/listmt2.png
Back to Top
Oleg View Drop Down
Admin Group
Admin Group


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 11234
Post Options Post Options   Thanks (0) Thanks(0)   Quote Oleg Quote  Post ReplyReply Direct Link To This Post Posted: 25 October 2007 at 1:40am
Yes, will be possible. You can download preview version from beta.codejock.com
Oleg, Support Team
CODEJOCK SOFTWARE SOLUTIONS
Back to Top
indices View Drop Down
Groupie
Groupie


Joined: 21 September 2007
Location: India
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote indices Quote  Post ReplyReply Direct Link To This Post Posted: 26 October 2007 at 3:22pm
Thank you. Looking forward to it.
Back to Top
indices View Drop Down
Groupie
Groupie


Joined: 21 September 2007
Location: India
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote indices Quote  Post ReplyReply Direct Link To This Post Posted: 26 October 2007 at 6:39pm

I am using the beta build to test:

Dim GallerySlide As CommandBarGallery

Set Popup = CommandBars.Add("Thumbnails", xtpBarPopup)
Set GallerySlide = Popup.Controls.Add(xtpControlGallery, ID_SLIDE_LIST, "")
With GallerySlide
           .Style = xtpButtonIconAndCaption
            .Width = 480
            .Height = 420
End With
 
This is still drawing a gallery with icons and the caption as tooltip. What did i do wrong?
 
Thanks
 
Back to Top
indices View Drop Down
Groupie
Groupie


Joined: 21 September 2007
Location: India
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote indices Quote  Post ReplyReply Direct Link To This Post Posted: 27 October 2007 at 9:57am
Nevermind. I needed to add sufficient width to the gallery item to make the caption appear. 
 
This works great.
Back to Top
indices View Drop Down
Groupie
Groupie


Joined: 21 September 2007
Location: India
Status: Offline
Points: 44
Post Options Post Options   Thanks (0) Thanks(0)   Quote indices Quote  Post ReplyReply Direct Link To This Post Posted: 27 October 2007 at 10:03am

Is it possible to wrap the caption or have a multi-line caption for this style?

Back to Top
Oleg View Drop Down
Admin Group
Admin Group


Joined: 21 May 2003
Location: United States
Status: Offline
Points: 11234
Post Options Post Options   Thanks (0) Thanks(0)   Quote Oleg Quote  Post ReplyReply Direct Link To This Post Posted: 29 October 2007 at 3:00am
No :(
Think we will add xtpButtonCaptionAndDescription support also.
Oleg, Support Team
CODEJOCK SOFTWARE SOLUTIONS
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.172 seconds.