resize child column

Posted by: sgmicro on 8 September 2017, 1:32 pm EST

  • Posted 8 September 2017, 1:32 pm EST

    Hello,


    (Before i ask my question, I saw lot of post on this subject but they don't help me...)


     I'm trying to resize column in childView (hierarchical mode) but it doesn't work...
    I've wrote :  "<FONT size=2>grdCycle.Sheets[0].GetChildView(i, 0).Columns[3</FONT><FONT size=2>].Width = 800;" but child column is not resize...
    I put "<FONT size=2>grdCycle.ActiveSheet.DataAutoSizeColumns = </FONT><FONT color=#0000ff size=2><FONT color=#0000ff size=2>false</FONT></FONT><FONT size=2>;" but it's the same thing...

    </FONT></FONT>

    <FONT size=2>Remarks :
    - Resize f</FONT><FONT size=2>or the spread's column it's ok ("<FONT size=2><FONT size=2>grdCycle.ActiveSheet.Columns[2].W</FONT><FONT size=2>idth = 80;")
    - I could modify other porperty of child and it's ok (ex : "<FONT size=2>grdCycle.Sheets[0].GetChildView(i, 0).Columns[3</FONT><FONT size=2>].HorizontalAlignment = </FONT><FONT color=#2b91af size=2><FONT color=#2b91af size=2>CellHorizontalAlignment</FONT></FONT><FONT size=2>.Right;")

    </FONT></FONT></FONT></FONT>

    <FONT size=2><FONT size=2><FONT size=2>Thks

    </FONT></FONT></FONT>
  • Replied 8 September 2017, 1:32 pm EST

    You need to set DataAutoSizeColumns on the child, not the parent.
  • Replied 8 September 2017, 1:32 pm EST

    so simple... big thanks


     

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels