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 :
-
Change this default of 50x10 to some custom size of my own.
-
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?
-
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.