Disable column select on click of column header

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

  • 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
  • Replied 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
  • Replied 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
  • Replied 26 April 2021, 4:20 pm EST


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

    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
  • Replied 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels