ssxml is removed after setting data source property

Posted by: dennis-daviskegel-net on 10 September 2017, 10:59 am EST

  • Posted 10 September 2017, 10:59 am EST

    I have this set in xaml
    DocumentUri="/Test;component/Spread Documents/spreadsheet1.ssxml"

    But when I set the data source property of the spread in code the designed ssxml is removed.
    How do I correct this?
  • Replied 10 September 2017, 10:59 am EST

    Hello,

    This is the design behaviour because either you set DocumentURI to load a spreadsheet file or you need to set DataSource of the same Spreadsheet. the one which is set later will take the effect.

    Hope it clarifies.

    Thanks,
    Reeva
  • Marked as Answer

    Replied 10 September 2017, 10:59 am EST

    Hi,

    You can set DataSource in a new sheet instead, and add it to the workbook, then reference those cells from some range in the ssxml sheet you designed in the designer. Hope that helps!

    Regards,
    -Sean
Need extra support?

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

Learn More

Forum Channels