Spreadsheet component in Delphi 11

Questions and answers on how to use XLSSpreadSheet.
Post Reply
hugvis
Posts: 7
Joined: Mon Nov 22, 2021 6:23 pm

Spreadsheet component in Delphi 11

Post by hugvis »

Hi
It appear to be some bug in this component

If i move cursor by this code forward or by increasing row number, it's ok and work as it should except not with visible cursor pos col.
But if i want to move cursor backwards decreasing row number, it always go to first cursor location but cursor col displays correct.

I need workaround this or update.

Example:
XLSSS_dkUsers.SetCursorPos ( 0, 3 , 300 ); goes to correct row location but not right col location or first col "A"
XLSSS_dkUsers.SetCursorPos ( 0, 3 , 100 ); goes to row location 3, 300 but right col as most left
larsa
Site Admin
Posts: 926
Joined: Mon Jun 27, 2005 9:30 pm

Re: Spreadsheet component in Delphi 11

Post by larsa »

Hello

I can't see any problem. SetCursorPos scrolls the sheet so that the cursor becomes visible.
Lars Arvidsson, Axolot Data
Post Reply