Is there a way to know when a cell is part of a merged set of cells?
Also, can anyone point me to the documentation behind FPSpreadsheetchm help files are contained in the folder "docs" of your fpspreadsheet installation. The fpspreadsheet-api.chm is generated from the in-code comments, the fpspreadsheet-wiki.chm is a copy of the "historic" version of the related wiki articles matching your fpspreadsheet version. The most basic wiki article is http://wiki.lazarus.freepascal.org/FPSpreadsheet (valid for the current trunk version), it links to other related articles.
Could I have an old version of FPSpreadsheet, I've got installed from Online Package Manager V1.8.2.0
Workbook is of type TsWorkbookSource which is what I'd expect, but what is Worksheet if its not the WorkbookGrid? Where is it on the form and how does it relate to the Grid?No. A workbook is a collection of worksheets, and a worksheet is a collection of cells - these are nonvisual data structures. The WorksheetGrid is something like a StringGrid and displays data stored in a worksheet. In the same sense that a TListbox displays data stored in a stringlist.
I've been through the tutorial again, but can't seem to get things straight in my head, any guidance would be appreciate to get me going on the right track.In addition to the tutorial, also look at http://wiki.lazarus.freepascal.org/FPSpreadsheet which focuses on the "data-container side" with worksheet and workbook
BTW I can't find any help files in the Lazarus install directory, where should I be looking, and when I press the context sensitive help (F1) it says that it can't find any help - does this sound like something has not installed properly?No, there is no context-sensitive help, i.e. F1 does not work. But there are chm files in the folder "docs" of the fpspreadsheet installation which you must open by double-clicking. As I wrote earlier these are copies of the "historic" online version and fit to the version you installed; this is because the online version is continuously changing and may describe features which are not yet in your installed version (but only very rarely - and version 1.8.4 is almost the same as the development version).
it appears that Gird column A is 1 where as Workbook.Worksheet column A is 0 - and same for rows.Yes, this is certainly a major annoyance to a new user: worksheet indexes start at 0, i.e. cell "A1" is row=0, col=0, and worksheet methods expect the indexes in exactly this order - row first, column last. In the grid, indexes start at 0 too, but the 0th column/row are usually occupied by the fixed cols/rows, and the first data cell is at column=1 and row=1! And to confuse you even more, the grid expects indexes in the order column first, row last, i.e. the exact opposite of the worksheet. This is due to historic reasons and cannot be changed any more without breaking user code. So, please be careful.