resize child column

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

  • Posted 8 September 2017, 1:32 pm EST

    <P>(Before i ask my question, I saw lot of post on this subject but they don't help me...)</P>
    <P> I'm trying to resize column in childView (hierarchical mode) but it doesn't work... <BR>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...<BR>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...</P></FONT></FONT>
    <P><FONT size=2>Remarks : <BR>- 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;")<BR>- 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;")</P></FONT></FONT></FONT></FONT>
    <P><FONT size=2><FONT size=2><FONT size=2>Thks</P></FONT></FONT></FONT>
  • Replied 8 September 2017, 1:32 pm EST

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

    <P>so simple... big thanks</P>
    <P> </P>
Need extra support?

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

Learn More

Forum Channels