Flexcel grid scroll with vcl styles

FLX TMS FlexCel for VCL & FMX
1

Hello



I have a problem using flexcel grids vertical (up/down) scroll bar when I enable a vcl style.



If I leave it with default windows style it works fine but when I change
it to styled it wont move up or down by clicking or dragging, but the
mouse wheel still works.



Flexcel version 3.5

Delphi XE2 with update 2



Any thoughts?



Thanks 

2

Hi,

I can't see to reproduce this here. I have tried enabling vcl styles, and vertical scrollbar does work. Does it happen with any style or with some in particular?  Also, is this in win7 or xp?  I tried it here with win7 and delphi xe2 update 3. (I wonder if update 3 maybe fixed something?)

A last thing, if you use a regularv TStringGrid, does it show the same problem?  FlexCelGrid is a descendant from TCustomGrid (same as TStringGrid), and scrollbars aren't really drawn or managed by FlexCelGrid, they are managed by the TCustomGrid below. So I wonder if a StringGrid shouldn't show the same issue.
3

HI Adrian

Once again thanks for your quick response,  as usual the error was in my code, something to do with the wrong control tab, I am really sorry for wasting your time :(

With regards to no flexcel grid in fire monkey...
I guess I will have to use a string grid, in which case how do I manage multiple sheets?
- eg with flexcel grid I simply use the control tabs change event to switch sheets...


  Data.ApplySheet;
  FlexCelImport.ActiveSheet:= TabControl.TabIndex+1;
  Data.LoadSheet;



So how can I use the control tab to switch string grid data?
I have not looked into this at all yet, so may be you could kindly advise on how to use a multi-sheet XLS inside a string grid instead of a flexcel grid?

Thanks

4

Well, the main issue here is that FlexCel 3 doesn't support firemonkey, not only the grid, but also FlexCelImport/report, so sadly until we finally release FlexCel 5 which does have FM support.


But, you can look at the example API\20.Reading Files for an example on how to load an xls file into an stringgrid, wiht many tabs (it uses tabs at the bottom).

Regards,
   Adrian.