[Solved] How I can disable the select top-corner button in SpreadSheet

[Hippolythe]

Hello, 

I need to disable the button that selects the entire sheet in SpreadSheet. I tried to hide it with CSS but the button remains active.

 

I have highlighted in yellow the button I am talking about in the screenshot below.

Thanks.

[Hippolythe]

I succeeded by passing the Select event to null if I detect the click on the top-corner button.

function onSelect(e: any) {
    const selectedCellorRange = e.range._ref;

    if (selectedCellorRange.topLeft && selectedCellorRange.bottomRight) {
        const topLeft = selectedCellorRange.topLeft;
        const bottomRight = selectedCellorRange.bottomRight;

        if (bottomRight.row > 0 && bottomRight.col === totalColumns && topLeft.row === 0 && topLeft.col === 0) {
            selectedCellorRange.topLeft.row = null;
            selectedCellorRange.topLeft.col = null;
            selectedCellorRange.bottomRight.row = null;
            selectedCellorRange.bottomRight.col = null;
        }
    }
}

[Nikolay]

Hi Hippolythe,

Thank you for sharing the solution with the community. I believe this will be helpful to others facing the same scenario.

Regards,

Nikolay