How to change default row and column count of a C1FlexSheet

Posted by: anildabral3k on 4 September 2019, 4:06 pm EST

  • Posted 4 September 2019, 4:06 pm EST

    Hi,
    I created an instance of C1FlexSheet, which gave me 50 rows and 10 columns(A to J). I want to achieve following :
    1. Change this default of 50x10 to some custom size of my own.

    2. If I copy data from an Excel sheet, size say 70x20 and paste it in the C1FlexSheet, I only get data in 50x10 and remaining Excel data is lost. Can we set some property(or do something) so that data is not lost and rather C1FlexSheet resizes to the size of data being pasted?

    3. While manually entering the data, in the C1FlexSheet if we reach the default boundary (50x10) then how can I add more blank rows and columns on the fly, like, maybe pressing a TAB key or some other way?

    Thanks.
  • Marked as Answer

    Replied 8 September 2019, 8:49 pm EST

    Hello,

    Your concern has been addressed in the other forum case you created: https://www.grapecity.com/forums/wpf-edition/how-to-change-default-row-_1.
    So, we are closing this case as duplicate.

    ~Ruchir
Need extra support?

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

Learn More

Forum Channels