Unable to edit all the cells

Unable to edit all the cells

Posted by: khoapcse90038 on 1 February 2023, 7:27 pm EST

• 

  khoapcse90038

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 1 February 2023, 7:27 pm EST - Updated 1 February 2023, 7:54 pm EST

  Hi teams,
  
  I have an excel file template that contains data with 7 column from A to G and 8 rows in attachment file.

  In practice, cells which had content on upload can only be edited, other cells are locked. I want all the cells available for the user to edit, it should be like a normal excel file.

  I found some solution with setRowCount & setColCount. But I must be give exact number to active row or column in excel file. If i set the maximum number to active all row & column. It is not possible to scroll.
  
  Please help me.
  
  Thanks

  

  1920×1053 81.8 KB

  EditAllCell.zip

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 1 February 2023, 9:57 pm EST

  Hello Khao,

  As per our understanding, you are using GcExcel to fill the data in excel using template functionality. And when opening the file in the SpreadJS designer, only filled rows and columns are visible. This is because of the row count and column count properties and as MS Excel does not have such properties so it displays all rows and columns whereas SpreadJS designer does not.

  We have also seen that even after setting the RowCount and ColumnCount explicitly, the output is the same and before reporting this to the development team we would like to confirm if we are on the same page or if is there any other understanding.

  Also, let us know what you mean by the following statement:
  
  >>But I must be give exact number to active row or column in excel file. If i set the maximum number to active all row & column. It is not possible to scroll.

  Regards,
  
  Prabhat Sharma.

• 

  khoapcse90038

  • Post Options:
  • Link
    Copy

  Posted 12 February 2023, 7:46 pm EST

  Thanks for your reply.
  
  We’re using solution in this topic
  
  https://www.grapecity.com/forums/spreadjs/total-rows-columns-dynamically-adjusting.