Page 1 of 2 12 LastLast
Results 1 to 10 of 14

Thread: How can one resize the task list in a taskFormGroup in the Backstage?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    MrExcel MVP
    Int'l Moderator
    Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39° 17' 15" N, -94° 40' 26" W
    Posts
    9,999
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default How can one resize the task list in a taskFormGroup in the Backstage?

    Okay, I have scoured the internet and I have come up empty. I am simply stumped on this one. When creating a taskFormGroup in a tab in the backstage of the Office Fluent User Interface how can one shift the divider between the task objects and the groups that contain the various and sundry controls for each task item?


    The area for the tasks is too narrow, the problem is moderate in Excel 2010, but it is especially pronounced in Excel 2013. I can shift the divider between the firstColumn and secondColumn objects by changing the columnWidthPercent attribute of the tab object.


    Pictorially, here is what I'm talking about:

    Excel 2010 (columnWidthPercent="50")


    Excel 2013 (columnWidthPercent="50")


    Excel 2010 (columnWidthPercent="75")



    Excel 2013 (columnWidthPercent="75")






    The XML (snipped) that creates this looks like so:


    Code:
    ...
    <!-- Tab: Developer Tools -->
    		<tab	id="bstabDevTools"
    				insertAfterMso="TabPrint"
    				label="Developer Tools"
    				columnWidthPercent="75" >
    			<firstColumn>
    				<taskFormGroup id="tfgDevTools1">
    <!-- Cat: File & Path Ops -->
    					<category id="catFilePath" label="File and Path Operations">
    .
    .
    .
    <!-- Task: PathFinder -->
    						<task	id="tskPathFinder"
    								label="Choose Your Path"
    								description="Change the set of path maps on wksPaths."
    								image="ChoosePath64">
    							<group id="grpPathMapper" label="Map Sets Available">
    								<bottomItems>
    									<layoutContainer id="layctrPathSetsV" layoutChildren="vertical">
    <!-- PathSet: GabrAria -->				<layoutContainer id="layctrPathSetG_H" layoutChildren="horizontal">
    											<button
    												id="rxbtnGabrAriaPaths_ANN_ASSORT"
    												image="SquareGreen32"
    												label="GabrAria Path Set"
    												style="large"
    												tag="PathSet_GabrAria"
    												onAction="Shared_PickPathSet_Entry_ANN_ASSORT"/>
    											<layoutContainer id="layctrPathSetG_V" layoutChildren="vertical">
    												<labelControl id="lblPathSetG_Hdr" label="Change path set to GabrAria Maps" />
    												<layoutContainer id="layctrPathSetGSubHead1" layoutChildren="horizontal">
    													<imageControl id="imgBulletPSG001" image="LtGreenBullet_9pt"/>
    													<labelControl id="lblPathSetGSubHead1" label="Paths will be local hard drive."/>
    												</layoutContainer>
    												<layoutContainer id="layctrPathSetGSubHead2" layoutChildren="horizontal">
    													<imageControl id="imgBulletPSG002" image="LtGreenBullet_9pt"/>
    													<labelControl id="lblPathSetGSubHead2" label="Use this after having changed to client's path set and made a copy to send to the client."/>
    												</layoutContainer>
    											</layoutContainer>
    										</layoutContainer>
    ...

    I have looked up and down the heirarchy here for possible attributes that I might use here and all I see is this:


    tab - columnWidthPercent (doesn't work)
    firstColumn - has no attributes
    taskFormGroup - no attributes look like good candidates
    category - no attributes look like good candidates
    group - no attributes look like good candidates
    primaryItem - has no attributes
    topItems - has no attributes
    bottomItems - has no attributes
    layoutContainer - has an "expand" attribute; but if that works, I haven't figured out how it would fit into the XML.


    So... does anybody know how to move that blasted divider on the left side?
    Last edited by Greg Truby; Apr 17th, 2015 at 12:19 AM.
    Greg
    ………………………………………………
    Home: XL 2003, 2007, 2010, and 2013 on Windows 7
    Work: XL 2013, 2016 on Windows 10
    Please use CODE tags - especially for longer excerpts of code.

  2. #2
    MrExcel MVP
    Int'l Moderator
    Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39° 17' 15" N, -94° 40' 26" W
    Posts
    9,999
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How can one resize the task list in a taskFormGroup in the Backstage?

    Sorry - the MSDN reference on the backstage is here (don't know what happened to the URL I put in there):

    https://msdn.microsoft.com/en-us/lib...ildInformation
    Greg
    ………………………………………………
    Home: XL 2003, 2007, 2010, and 2013 on Windows 7
    Work: XL 2013, 2016 on Windows 10
    Please use CODE tags - especially for longer excerpts of code.

  3. #3
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,799
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: How can one resize the task list in a taskFormGroup in the Backstage?

    To save time, do you have a workbook we can look at?

    Have you tried the firstColumnMinWidth attribute for the tab?

  4. #4
    MrExcel MVP
    Int'l Moderator
    Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39° 17' 15" N, -94° 40' 26" W
    Posts
    9,999
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How can one resize the task list in a taskFormGroup in the Backstage?

    Hi Rory,


    Yes, I have played with the firstColumnMinWidth attribute for the tab object. It impacts the splitter between the first and second columns, not the splitter between the task items and the various children items.


    Not having a second column at all also has no impact on this splitter's position.


    What's really got me frustrated is this:





    You can see that the programmers at Microsoft have repositioned the splitter when they're creating taskFormGroups, so how did they do it? Their windows are wide enough.


    Is there a way to upload files here? If so, I'm not seeing it? If not, what's the best way to get a sample file to you?


    Thanks a bunch for looking at this. I really appreciate it.
    Greg
    ………………………………………………
    Home: XL 2003, 2007, 2010, and 2013 on Windows 7
    Work: XL 2013, 2016 on Windows 10
    Please use CODE tags - especially for longer excerpts of code.

  5. #5
    MrExcel MVP
    Moderator
    RoryA's Avatar
    Join Date
    May 2008
    Location
    UK
    Posts
    33,799
    Post Thanks / Like
    Mentioned
    48 Post(s)
    Tagged
    6 Thread(s)

    Default Re: How can one resize the task list in a taskFormGroup in the Backstage?

    If it's not confidential, you can put in OneDrive/Dropbox and post a link here. If it is, PM me and I'll send you an email address.

  6. #6
    MrExcel MVP
    Int'l Moderator
    Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39° 17' 15" N, -94° 40' 26" W
    Posts
    9,999
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How can one resize the task list in a taskFormGroup in the Backstage?

    Let me clean out a couple of things that might be confidential-ish and then I'll use OneDrive sharing.
    Greg
    ………………………………………………
    Home: XL 2003, 2007, 2010, and 2013 on Windows 7
    Work: XL 2013, 2016 on Windows 10
    Please use CODE tags - especially for longer excerpts of code.

  7. #7
    MrExcel MVP
    Int'l Moderator
    Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39° 17' 15" N, -94° 40' 26" W
    Posts
    9,999
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How can one resize the task list in a taskFormGroup in the Backstage?

    Rory (and anyone else that wants to play along) here is a link to a version of the file with the backstage XML shown.


    http://1drv.ms/1yAklQT


    Thank you to anyone that can help.
    Greg
    ………………………………………………
    Home: XL 2003, 2007, 2010, and 2013 on Windows 7
    Work: XL 2013, 2016 on Windows 10
    Please use CODE tags - especially for longer excerpts of code.

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How can one resize the task list in a taskFormGroup in the Backstage?

    Greg,

    I found two properties that might help: FirstColumnMaxWidth and FirstColumnMinWidth. Not sure if they will do, but it's worth a try. Found here and here
    Regards,

    Juan Pablo Gonzαlez
    http://www.juanpg.com

  9. #9
    MrExcel MVP
    Int'l Moderator
    Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39° 17' 15" N, -94° 40' 26" W
    Posts
    9,999
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How can one resize the task list in a taskFormGroup in the Backstage?

    Gracias, Juan Pablo. But, yeah, I have already played with both of those attributes for the task element and no joy. Thanks for the additional links, though. Always good to have another resource.
    Greg
    ………………………………………………
    Home: XL 2003, 2007, 2010, and 2013 on Windows 7
    Work: XL 2013, 2016 on Windows 10
    Please use CODE tags - especially for longer excerpts of code.

  10. #10
    MrExcel MVP
    Int'l Moderator
    Greg Truby's Avatar
    Join Date
    Jun 2002
    Location
    39° 17' 15" N, -94° 40' 26" W
    Posts
    9,999
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How can one resize the task list in a taskFormGroup in the Backstage?

    Okay, folks, here's what we've learned so far...


    Changing the column width attributes (columnWidthPercent, firstColumnMaxWidth, firstColumnMinWidth) in the task element gets you diddly squat on this. No help whatsoever.


    However, the taskFormGroup element has an allowedTaskSizes attribute. Initially setting this attribute to "large" — which was the size that Excel had been displaying, still got me bupkis. BUT changing the attribute to "small" did result in Excel 2013 resizing the column where the tasks were shown. Circling back and then changing the value of the allowedTaskSizes to "largeMediumSmall" changed the icons back to the large size while maintaining the new and improved column width. The column of tasks is still not as wide as I would like, but it's better than it was.


    If anyone knows of anything else to try, please post! A big «muito obrigado» to Robert Martim for his help on this.
    Last edited by Greg Truby; Apr 17th, 2015 at 06:55 PM.
    Greg
    ………………………………………………
    Home: XL 2003, 2007, 2010, and 2013 on Windows 7
    Work: XL 2013, 2016 on Windows 10
    Please use CODE tags - especially for longer excerpts of code.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •