I want Change the Width of Column. Which settings are restricted me to do that?

Posted by: n-s-saravanakumar2009 on 8 September 2017, 3:03 pm EST

  • Posted 8 September 2017, 3:03 pm EST



    I am using fp6 in oracle form 6i. 

    The below function returns first column's  width successfully.

    nColsize := FPSpreadADO_DSpreadSheet.colwidth(interface1,1) ;

     But when I tried set the Column width as double,

    nColsize := nColsize * 2;

     FPSpreadADO_DSpreadSheet.colwidth(interface1,1, nColsize) ;

    The above function does not change the width of that first column;

     Will you please tell me any body knows that which settings are to be tuned on/off to achieve the change of column width.


  • Replied 8 September 2017, 3:03 pm EST


    I see that  fpSpread1.ColWidth( ) method only takes two arguments the Column index and the width to set as.

    void CSpreadSheet::SetColWidth(long lCol, double value); 



  • Replied 8 September 2017, 3:03 pm EST


    Yes, U R correct. 

    But in Oracle Procedure "fpspread1".item is mentioned as oleobj.

    All Procedure(s) and Function(s) should have the first parameter of that Oleobj.

    In my example


    interface1  oleobj;


    interface1 := :item('block1.grid1').interface;  /* that is in my form grid1 is item as like in your example fpspread1 */




  • Replied 8 September 2017, 3:03 pm EST


    Please make sure that you are able to change the width of Spread at run time by dragging the column header grid line. Also make sure that the UnitType for Spread is set to Normal(0) and you are correctly getting the column width in 'nColsize' before setting the ColWidth.



Need extra support?

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

Learn More

Forum Channels