Auto-calculated / readonly columns in spreadsheet

Auto-calculated / readonly columns in spreadsheet

Posted by: serge.dudnic on 10 March 2021, 7:24 pm EST

• 

  serge.dudnic

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 10 March 2021, 7:24 pm 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
• 

  serge.dudnic

  • Post Options:
  • Link
    Copy

  Posted 10 March 2021, 7:33 pm EST

  PS. talking about FlexGrid Spreadsheet for Asp.Net Core

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 11 March 2021, 8:53 pm EST

  Hi Serge,
  
  You may use our ComponentOne FlexSheet control to accomplish the above requirement. Please refer to the attached sample project for reference.

  Please post further queries related to ComponentOne product with Asp.Net Core on the following forum:
  
  https://www.grapecity.com/forums/mvc-edition

  Regards,
  
  Manish Gupta

  FlexSheet-Formula.zip