Get information of top-left corner

Get information of top-left corner

Posted by: ngocnguyen09910060 on 25 April 2023, 2:45 am EST

• 

  ngocnguyen09910060

  • Post Options:
  • Link
    Copy

  Posted 25 April 2023, 2:45 am EST

  Hi teams,

  I understand that SpreadJS has an area that is called:

  GC.Spread.Sheets.SheetArea.corner

  I want to get some basic information of this area, such as width, height, background color,…
  
  After that, i want to custom this area, such as:

  1. Change background color.
  2. Display a checkbox or customize cell type on this area.
     
     Please tell me how can i do it.
• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 26 April 2023, 6:40 am EST

  Hello,

  You can use sheet.getColumnWidth() and sheet.getRowHeight() methods to get the width and height of the corner and passing the sheetArea as GC.Spread.Sheets.SheetArea.corner

  You can change the background color of corner with css class. Some of the css classes that can be utilized to customize the corner are mentioned below:

  .gc-corner-hover { } 
  .gc-corner-selected { } 
  .gc-corner-normal { }
   .gc-corner-triangle-normal { }
   .gc-corner-triangle-hover { } 
  .gc-corner-triangle-selected { }

  Please note that you can not set a custom cell type to corner area of the sheet. This is by design. However, you can override the paint() method of Corner cell type class to draw the content that you want.

  Please refer to the attached sample which demonstrates how you can customize corner cell style and paint content manually.

  Sample: https://jscodemine.grapecity.com/share/oF7QMw15FU2jK27jPOWMzA/?defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fsrc%2Fapp.js"%2C"%2Fsrc%2Fstyle.css"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Please let us know if you still face any issues.

  Doc references:

  sheet.getColumnWidth():https://www.grapecity.com/spreadjs/api/v15/classes/GC.Spread.Sheets.Worksheet#getcolumnwidth

  sheet.getRowHeight():https://www.grapecity.com/spreadjs/api/v16/classes/GC.Spread.Sheets.Worksheet#getrowheight

  Corner class: https://www.grapecity.com/spreadjs/api/v16/classes/GC.Spread.Sheets.CellTypes.Corner

  Regards,

  Ankit