Search found 7 matches
- Mon Jan 17, 2022 3:50 pm
- Forum: XLSSpreadSheet
- Topic: Spreadsheet component in Delphi 11
- Replies: 1
- Views: 2060
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...
- Tue Jan 04, 2022 1:47 pm
- Forum: XLSSpreadSheet
- Topic: Move sheet on screen
- Replies: 2
- Views: 2164
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...
- Sun Jan 02, 2022 4:36 pm
- Forum: XLSSpreadSheet
- Topic: Move sheet on screen
- Replies: 2
- Views: 2164
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...
- Fri Dec 10, 2021 4:27 pm
- Forum: XLSReadWritwII 6
- Topic: Lack of focus
- Replies: 3
- Views: 4144
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...
- Wed Nov 24, 2021 9:22 pm
- Forum: XLSReadWritwII 6
- Topic: Lack of focus
- Replies: 3
- Views: 4144
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...
- Mon Nov 22, 2021 6:42 pm
- Forum: XLSSpreadSheet
- Topic: Move focus to selected cell
- Replies: 9
- Views: 25373
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.
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.
- Mon Nov 22, 2021 6:28 pm
- Forum: XLSSpreadSheet
- Topic: XLSSpreadSheet Can it search in a sheet?
- Replies: 2
- Views: 6973
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;
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;