Search found 7 matches

by hugvis
Mon Jan 17, 2022 3:50 pm
Forum: XLSSpreadSheet
Topic: Spreadsheet component in Delphi 11
Replies: 1
Views: 767

Spreadsheet component in Delphi 11

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 di...
by hugvis
Tue Jan 04, 2022 1:47 pm
Forum: XLSSpreadSheet
Topic: Move sheet on screen
Replies: 2
Views: 675

Re: Move sheet on screen

Ok. Thank you Lars. This worked, but it moved C,R location on all sheet in same workbook. But still in question how to do this on many sheets, one by one with different C,R for each sheet ?? Also i want you to confirm right import of the package you bought from you. Allow me to send screenshot in em...
by hugvis
Sun Jan 02, 2022 4:36 pm
Forum: XLSSpreadSheet
Topic: Move sheet on screen
Replies: 2
Views: 675

Move sheet on screen

Hello Lars. Regard: Delpi 10.3 and your component version: 6.01.07 Over the xmas iv'e been trying to figure out how to by code, move sheet on screen to location in sheet 0, col 14 and row 150 using this code: XLSGrid1.XLS[0].SelectedAreas.CursorCell( 14, 150 ); XLSGrid1.Invalidate; or this: XLSGrid1...
by hugvis
Fri Dec 10, 2021 4:27 pm
Forum: XLSReadWritwII 6
Topic: Lack of focus
Replies: 3
Views: 2424

Re: Lack of focus

Hi Let me explain this little better. Suppose I look for a specific value found in a cell, say column 63 and line 234. The table does not move on the screen even though the value is found and i'm ok with that, but how can I program to move the table on the screen so the cell with founded value is in...
by hugvis
Wed Nov 24, 2021 9:22 pm
Forum: XLSReadWritwII 6
Topic: Lack of focus
Replies: 3
Views: 2424

Lack of focus

Hello Lars I'm having a lot of trouble using your XLS package in Delphi 10.3.3 Probably most of all because there are no instructions or a lack of examples. There is also a lot of outdated problems and solutions on web that are not relevant today and outdated solution. I now have an Excel document t...
by hugvis
Mon Nov 22, 2021 6:42 pm
Forum: XLSSpreadSheet
Topic: Move focus to selected cell
Replies: 9
Views: 21861

Re: Move focus to selected cell

Hi
Anything descriped here does not works here in Delphi 10.3.3
How is possible to move visually the focus and corresponding frame to a given cell and move worksheet in sight if it outsite visible area ?
Rg.
by hugvis
Mon Nov 22, 2021 6:28 pm
Forum: XLSSpreadSheet
Topic: XLSSpreadSheet Can it search in a sheet?
Replies: 2
Views: 5510

Re: XLSSpreadSheet Can it search in a sheet?

Hi
This is outdated. How is this done in Delphi 10.3.3 ?

FXSS.XLSSheet.BeginFindText;

while FXSS.XLSSheet.FindText('MyFindText') do begin
FXSS.XLSSheet.GetFindData(Col,Row,TextPos,Text);

ShowMessage('Found at ' + ColRowToRefStr(Col,Row) + ': ' + Text);
end;