Auto-calculated / readonly columns in spreadsheet

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

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

    PS. talking about FlexGrid Spreadsheet for Asp.Net Core
  • Marked as Answer

    Replied 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
Need extra support?

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

Learn More

Forum Channels