Using the TFlexCelPreviewer showing a multipage excel file is there any way to jump or scroll to a cell on a page which is not in view? The best I could find was ScrollBy() but that is treating it purely as an image which is incorrect.
Sorry for the delay: I've been investigating if there was a simple way to do that but sadly there isn't: It will need a bit of refactoring to make those properties available. So at least by the moment no, there is no simple way to do that.
On a longer answer, we are about to do a big refactoring of FlexCelPreview for v7 (which should be coming by the end of 2015). While the current one works well and it is very similar to Excel, it was designed in 2003 and could get some improvements. Among those, we are thinking in adding:
1)A vectorial display. Currently TFlexCelPreview uses cached bitmaps for the pages, and this was fine in 2003 when all monitors were 96dpi, and also computers were slower. Today, we have resolutions of more than 300 dpi, and sometimes in a phone which doesn't have much memory. While you can change the resolution of the bitmaps FlexCelPreview uses, using a very high dpi will consume a lot of memory
2)Ability to search or replace from the preview. This will include the ability to "go to a cell" and of higlighting stuff.
3)Ability to select and copy text.
Well, those are the plans. They aren't confirmed and we might change them, but it is most likely that you will be seeing this in FlexCel 7. And with it a TFlexCelSpreadsheet component too.
Thanks for the reply. OK on the no jump/scroll to a cell capability, I can live with that. I had tried a few workarounds but without any success. Thanks for taking the time to look at the problem.
The new version sounds very interesting, I'm looking forward to seeing it when it is ready.