Disable column select on click of column header

Disable column select on click of column header

Posted by: rehman.khaleelur on 25 April 2021, 10:56 am EST

• 

  rehman.khaleelur

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 25 April 2021, 10:56 am EST

  On clicking the column header the entire column gets selected and highlighted with a green color. Can you please help disable that functionality.

  Thanks

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 26 April 2021, 2:18 am EST

  Hi,

  We were unable to achieve the required functionality using the current public API hence we have escalated this issue to the concerned team for further investigation. We will update you once we get any information. The internal ID for this issue will be SJS-8583,

  Regards
  
  Avinash

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 26 April 2021, 3:59 pm EST

  Hi,

  The Devs are curious about the use case. Could you please explain more about the use case? so that the dev could have a better understanding of the issue and assist you accordingly.

  Regards
  
  Avinash

• 

  rehman.khaleelur

  • Post Options:
  • Link
    Copy

  Posted 26 April 2021, 4:20 pm EST - Updated 3 October 2022, 12:51 am EST

  Yeah sure, I have attached the screenshot of the scenario in the below link pls check it.
  
  

  

  1280×720 116 KB

  
  
  In the scenario, on clicking the header cell B, all the rows in B are highlighted with the green color focus border, can you help out with a way to disable it. On clicking the column header, it should not highlight the entire column is the requirement.

  Thanks

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 2 May 2021, 7:55 pm EST

  Hi,

  The team informed us that you may create a custom header for the required functionality. Please refer to the following demo.

  custom header Demo: https://www.grapecity.com/spreadjs/demos/features/cells/cell-types/custom-header#demo_source_name

  Further, for disabling the selection for all columnheader click, you may override getHitInfo method. Please refer to the following code snippet and let us know if you face any issues.

  
  GC.Spread.Sheets.CellTypes.ColumnHeader.prototype.getHitInfo = function (
    x,
    y,
    cellStyle,
    cellRect,
    context
  ) {
    if (context) {
      return {
        x: x,
        y: y,
        row: context.row,
        col: context.col,
        cellRect: cellRect,
        cellStyle: cellStyle,
        sheetArea: context.sheetArea,
        isReservedLocation: true,
        sheet: context.sheet
      };
    }
    return null;
  };
  
  

  Regards
  
  Avinash