resize child column

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

  • Posted 8 September 2017, 1:32 pm EST


    (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 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 size=2><FONT size=2><FONT size=2>Thks

  • 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