Embed parts of Spread Designer into spread code

Embed parts of Spread Designer into spread code

Posted by: iggypop66 on 8 September 2017, 2:59 pm EST

• 

  iggypop66

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 2:59 pm EST

  I plan to write an application, where I want to let the user change eg the style of a cell. So instead of writing this code myself, I am curious whether there is a way to reuse spread designer dialogs...

  thanks!

• 

  manpreetkaur

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 2:59 pm EST

  Hello,

  I would like you to know that not all Spread designer dialogs are available to be called at runtime. However, in the FarPoint.Win.Spread.Design assembly, we have a static method in ExternalDialogs class called CellTypeEditor and BorderEditor. You should be able to call one of these methods passing in an instance of your Spread object to show the dialog:
  
  
  
     FarPoint.Win.Spread.Design.ExternalDialogs.CellTypeEditor(FpSpread1)

  Both these methods display BorderDialog and CellTypeEditor dialog, for all the remaining dialogs, you would need to call the Spread designer at runtime. Hope it will help you. Please let me know if you have any queries further.

  Thanks,

  Manpreet Kaur