Auto-calculated / readonly columns in spreadsheet

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

    • Post Options:
    • Link

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

    PS. talking about FlexGrid Spreadsheet for Asp.Net Core

  • 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:


    Manish Gupta

Need extra support?

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

Learn More

Forum Channels