How to hide the frozenline?

How to hide the frozenline?

Posted by: david_liu on 8 September 2017, 1:10 am EST

• 

  david_liu

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 September 2017, 1:10 am EST

  Hi, I freeze the first row /column for my excel

                  sheet.frozenRowCount(1);
                  sheet.frozenColumnCount(1);
  

  but ,the frozen line looks a little abrup when the count of rows/column not big enough.
  
  how can I hide this line though sheet.options.frozenlineColor = “XYZ” or some other method?

  BTW, is there any method to freeze selected rows/columns instead of first N or last N rows/columns ?

  Thanks .

  

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 1:10 am EST

  Hello,

  Unfortunately, there is not an option to change the width of frozen line in order to hide it.

  But, we can change the color by sheet option frozenlineColor :-
  
  [csharp]sheet.options.frozenlineColor = “red”;[/csharp]

  However, if you want to remove frozen Column, you can set sheet.frozenColumnCount(0) but if you want to hide the line then there is no option to do the same.

  When the cells in sheet does not have border then we can set frozenlineColor the same as gridline.color which can hide the frozen line.

  Please make sure no border in all cell are there:-
  
  [csharp]sheet.options.frozenlineColor = sheet.options.gridline.color;[/csharp]

  Hope it helps.

  Thanks,
  
  Reeva

• 

  david_liu

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 1:10 am EST

  Thank you Reeva, set the forozenline color same with gridline looks much better.

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 1:10 am EST

  Hello David,

  We are glad to know that your issue has been resolved.

  Thanks,
  
  Reeva

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 24 January 2018, 4:00 pm EST

  Hi,

  I am using spread.js V9 and I am facing similar issue. It would be great if you guys can find a way to restrict width of frozen line to available columns and rows.

  Apart form that in spread.js v9, I don’t see any way to set color for frozen line. As “sheet.options” is not available.

  Please let us know how do we set frozen line color in v9 and also in v11.

  Note: In V9, there is a private variable sheet._frozenlineColor, and it works. But this is not exposed in v11.

  Thanks,
  
  Viswanath