why the left column of taskgroup is reduced in customui backstage with excel 2013

patrick verne 0 Reputation points
2024-07-01T13:55:40.4033333+00:00

Hello everyoneI have a problem in excel 2013 with my additional menu in the bakstage (CustomUI)the left column is not resized

customUI>
<backstage>
<tab id="tabb202401" label="mes tutos sur youtube" firstColumnMinWidth="600">
<firstColumn>
<taskFormGroup id="grtask1">
<category id="truc">
<task id="ButtonTask1" label="Task" imageMso="HappyFace">
<group id="MyTestGroup1" label="Test Group 1">
<topItems>
<labelControl id="Label1" label="Information about this button."/>
<button id="Button1" style="large" label="Click me" imageMso="HappyFace" isDefinitive="true" onAction="TestMe"/>
<labelControl id="Label2" label="Information about this button."/>
<button id="Button2" label="Click me" imageMso="HappyFace" isDefinitive="true" onAction="TestMe2"/>
</topItems>
</group>
</task>
<task id="ButtonTask2" label="Task2" imageMso="HappyFace">
<group id="MyTestGroup2" label="Test Group 2">
<topItems>
<labelControl id="Label3" label="Information about this button."/>
<button id="Button3" style="large" label="Click me" imageMso="HappyFace" isDefinitive="true" onAction="TestMe"/>
<labelControl id="Label4" label="Information about this button."/>
<button id="Button4" label="Click me" imageMso="HappyFace" isDefinitive="true" onAction="TestMe2"/>
</topItems>
</group>
</task>
</category>
</taskFormGroup>
</firstColumn>
</tab>
</backstage>
</customUI>

this is an capture of problem

User's image

If anyone has an idea I'm interested

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,174 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,966 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,725 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Tulinawe Ismail 0 Reputation points
    2024-07-03T19:29:45.81+00:00

    Hello, you may need to change the firstColums's min width and the secondColums' width attributes in your xml file while also considering the tab's percentage width.

    I has the same prolem but, this site will cover all your needs in the Custom UI including the examples of the callback functions

    https://www.accessribbon.de/en/?Access_-Ribbons:Ribbon_XML_Controls:Backstage-_Tab

    https://www.accessribbon.de/en/?Access_-_Ribbons:Ribbon_XML_Controls:Backstage

    0 comments No comments

  2. patrick verne 0 Reputation points
    2024-07-06T00:33:43.4866667+00:00

    Hello everyone by fumbling around I ended up finding my solution in fact it was necessary to use both firstcolumnminwidth and fistcolumnmaxwidth

    `<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui"> <backstage> <tab id="tabb202401" firstColumnMinWidth="800" firstColumnMaxWidth="800" label="mes tutos sur youtube" > <firstColumn> <taskFormGroup id="grtask1"> <category id="truc"> <task id="ButtonTask1" label="Task" imageMso="HappyFace"> <group id="MyTestGroup1" label="Test Group 1"> <topItems> <labelControl id="Label1" label="Information about this button."/> <button id="Button1" style="large" label="Click me" imageMso="HappyFace" isDefinitive="true" onAction="TestMe"/> <labelControl id="Label2" label="Information about this button."/> <button id="Button2" label="Click me" imageMso="HappyFace" isDefinitive="true" onAction="TestMe2"/> </topItems> </group> </task>

    			<task id="ButtonTask2" label="Task2" imageMso="HappyFace">		
                            <group id="MyTestGroup2" label="Test Group 2">		
                                <topItems>		
                                    <labelControl id="Label3" label="Information about this button."/>		
                                    <button id="Button3" style="large" label="Click me" imageMso="HappyFace" isDefinitive="true" onAction="TestMe"/>		
                                 <labelControl id="Label4" label="Information about this button."/>		
                                    <button id="Button4" label="Click me" imageMso="HappyFace" isDefinitive="true" onAction="TestMe2"/>		
                                </topItems>		
                            </group>		
                        </task>	
    
    		 </category>		
                </taskFormGroup>		
            </firstColumn>		
        </tab>		
    </backstage>		
    

    </customUI> ` merci à tous

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.