Cell border bottom doesnt work for a particular row on which freeze is applied

Cell border bottom doesnt work for a particular row on which freeze is applied

Posted by: viswanath.malepati on 24 January 2018, 6:16 am EST

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 January 2018, 6:16 am EST

  Hi,

  I am doing following steps:

  1. Set freeze line color to “white”
  2. Trying to apply freeze on a row
  3. Apply border bottom to the row which we are freezing with a different color (say, “red”).

  Expected: See red border to row on which we apply freeze
  
  Actual: No border for the row

  Please see Fiddle: http://jsfiddle.net/vp1mps0y/

  How to fix this?

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 25 January 2018, 5:51 am EST

  Hi Vishwanath,

  The fiddle you’ve mentioned doesn’t show anything. It just shows a blank page with a Button. Kindly check if you’ve added the required references and update the fiddle.

  Thanks

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 30 January 2018, 9:40 am EST

  Sorry for that, please check this out: https://jsfiddle.net/viswanathm/Lf7z7dzL/

• 

  abdias.michael

  

  • Post Options:
  • Link
    Copy

  Posted 31 January 2018, 5:42 am EST

  Thanks for the updated fiddle. To display a red bottom border line on the frozen row, you need to set the frozenLineColor to transparent instead of white.

  sheet.setFrozenRowCount(1);
  
  sheet.frozenlineColor(“transparent”);
  
  sheet.getRow(0).borderBottom(new GcSpread.Sheets.LineBorder(“#FF0000”,1))

  Please see the updated fiddle: https://jsfiddle.net/Lf7z7dzL/3/

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy

  Posted 31 January 2018, 6:24 am EST

  Thanks