How to change default row and column count of a C1FlexSheet

How to change default row and column count of a C1FlexSheet

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

• 

  anildabral3k

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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.

• 

  Ruchir.Agarwal

  

  • Post Options:
  • Link
    Copy

  Posted 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