Reg: Opening Sheet Settings Window

Posted by: kiran-ch on 8 September 2017, 2:58 pm EST

  • Posted 8 September 2017, 2:58 pm EST

    Hi,

     

    I am using Spread.Net along with WindowsFormsApplication and I would like to allow the user to change the settings of Spread Sheet through Sheet settings window which I found in Spread Designer.

    That I want to open through code. Can I open that sheet Settings Dialog Box or Do I prepare separately? 

    I am sending a screen shot of that sheet settings dialog box. 

     

    Thanks in advance..

     

    Regards,

    Kiran 



  • Replied 8 September 2017, 2:58 pm EST

    If you have the Spread6.Net Pro package or the trial version you can expose the Spread Designer to your users If you have a form with a Spread control on it, you simply add a FpSpreadDesigner component to your form from the toolbox and you can bring it up on a button click with a line like this

    FpSpreadDesigner1.Show(FpSpread1);

  • Replied 8 September 2017, 2:58 pm EST

    Hi paul1960 

    Thank you for your reply..

     

    But my requirement is not that..only opening that sheet settings dialog box.. I don't want the user to open entire Spread Designer..

     Can any one suggest me...

    Regards,

    Kiran 

  • Replied 8 September 2017, 2:58 pm EST

    Hello,

    The sheet settings dialog that you are referring to is available only in the Spread designer and is not explicitly available. If you want to use the same you would need to access the same using the Spread designer as suggested above.

    Hope it will help you. Please let me know if you have any queries further.

    Thanks,

    Manpreet Kaur

  • Replied 8 September 2017, 2:58 pm EST

    Hello,

    I wrote the below statements to open SheetSettings dialog box, but I am unable to apply the settings which I made in the dialog box.

    Can any one help me regarding this?

    Thanks in advance...

     

    Code:

     

    FarPoint.Win.Spread.Design.DesignerMain designerMain = new FarPoint.Win.Spread.Design.DesignerMain();

                designerMain.activeSheet = fpSpread1.ActiveSheet;

                FarPoint.Win.Spread.Design.SheetSettingsDlgV3 sheetSettings = new FarPoint.Win.Spread.Design.SheetSettingsDlgV3(designerMain);

                sheetSettings.ShowDialog(); 

     

    -

    Kiran 

  • Replied 8 September 2017, 2:58 pm EST

    Hello,

    I was able to replicate the issue at my end and it seems to be a bug. I have reported the same to the development team and the bug number for the same is #99926075 . It would be fixed in the next maintenance release.

    Thanks,

    Manpreet Kaur

Need extra support?

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

Learn More

Forum Channels