Posted 11 March 2021, 4:24 am EST
Hello, I test the spreadsheet control actually and wonderng if there are following functionnalities:
A) having auto-calculated columns (Excel-like), like A, B, Total (=A+B)
- these columns could be readonly and the formula (=A+B) not editable by the user
B) When pasting a range of values to auto-add the rows, if the paste range exceeds the sheet size. Suppose my sheet has 5 rows, I am in the last row (A5) and I paste 3 more rows. Now the sheet size should be 8 rows.
- the column number should not auto-grow however, only rows