Is there a way to change the cursor for the cell area of the UltraSpreadsheet control?
I have tried to set ultraSpreadsheet1.UseWaitCursor = true, but it has no effect on cursor displayed above the cells, it remains as standard Excel cross.
ultraSpreadsheet1.UseWaitCursor = true
What I'd like to achieve is a kind of standard thing: when application is busy - disable any user input and show hourglass cursor.
Regards,
Oleg
Hello Oleg,
Thank you for contacting Infragistics!
How are you determining that it is busy for when you want to change cursor?Have you tried setting the Cursor itself:www.infragistics.com/.../infragistics.win.ultrawinspreadsheet~infragistics.win.ultrawinspreadsheet.ultraspreadsheet~cursor
Yes, I have tried to set Cursor = Cursors.WaitCursor as well, it gives same result as UseWaitCursor = true.It affects only some small areas around worksheet cells.
I'm not trying to determine that application is busy, I just want to do something like this:
ultraSpreadsheet.UseWaitCursor = true; try { //some long operation } finally { ultraSpreadsheet.UseWaitCursor = false; }
Thank you for the update. You can achieve this by setting a CursorFilter:
https://es.infragistics.com/help/winforms/win-cursor-filter
UltraWinSpreadsheet.zip
Thank You! CursorFilter do the trick!But only when UltraSpreadsheet.Enabled = true.When control is disabled, BeforeSetCursor(..) method is not triggered and it still shows default cursor.
I used Enabled property to prevent any user input, but I think the same might be achieved with workbook and/or worksheet protection, am I right?
Thank you for the update. Setting the protection on the worksheet would prevent editing.