Grid Layout and data binding

Posted by: michal-fp on 8 September 2017, 1:42 pm EST

  • Posted 8 September 2017, 1:42 pm EST


    I want  to save grid layout for spread and then fill the grid with the function :

    I’m using the open and save layouts function for this but I found that those functions save the layout with the data  so when I fill the grid (with filling functions )and then set the new layout the data is changed. what I want to do is to load the layout only (for formulas color ext. ) and then fill the data to the grid with data  member property so the grid will contain the data and the original layout (for formulas color ext.)

    Do you have another function for this (to save only the layout)




  • Replied 8 September 2017, 1:42 pm EST


    There is not a direct method for serializing the Spread this way. You can write your own serialization to serialize only the parts you want. But, it may be easier just ot remove the data from the Spread before calling the Save method. If you are bound, you can do this by setting the DataSource property to Nothing (null in C#). If you are not bound, you can use the ClearData method to remove the data before saving.

Need extra support?

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

Learn More

Forum Channels