Unfreezing rows and columns, is scrolling sheet to a different row/column

Unfreezing rows and columns, is scrolling sheet to a different row/column

Posted by: viswanath.malepati on 6 February 2018, 7:34 am EST

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 6 February 2018, 7:34 am EST

  Hi,

  Lets say I have spread sheet where some rows frozen. Now When we were unfreezing them in V9 it was straight forward. But when we are doing the same in V11. sheet scrolling to a different row/column.

  in V9:
  
  sheet.setFrozenRowCount(0);
  
  sheet.setFrozenColumnCount(0);

  in V11:
  
  sheet.frozenRowCount(0);
  
  sheet.frozenColumnCount(0);

  How to fix this in V11?

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 7 February 2018, 5:52 am EST

  Hello,

  You can use the code as follows to unfreeze the rows/columns:

  activeSheet.frozenRowCount(“”);
  
  activeSheet.frozenColumnCount(“”);

  Thanks,
  
  Deepak Sharma

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 13 February 2018, 6:46 am EST

  Hi Deepak,

  I tried what you have mentioned above, but looks like it is not working.

  Please check the demo in attached HTML file, click on the “unfreeze” button at bottom and you will see that sheet is still scrolling.

  Note: Unfreeze is happening, problem is sheet is scrolling to the cell where freeze was applied.

  Thanks,
  
  Viswanath.

  unfreeze.zip

• 

  deepak.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 15 February 2018, 10:22 am EST

  Hi Viswanath,

  I am able to replicate this issue at my end. I have asked the development team to look into this issue further. The tracking id is 254524, I will let you know as soon as I get an update on this.

  Thanks,
  
  Deepak Sharma

• 

  reeva.dhingra

  

  • Post Options:
  • Link
    Copy

  Posted 13 June 2018, 5:52 am EST

  Hello,

  Your issue has been fixed in latest bi-weekly build which can be downloaded from this link:-
  
  http://cdn.grapecity.com/spreadjs/11.1.2/Files/SpreadJS.Release.11.1.2.zip

  Thanks,
  
  Reeva