Forum > FPSpreadsheet

[SOLVED] WorkSheetGrid, merged cells and picklist

(1/1)

morknot:
I have a WorkSheetGrid which has a number of merged cells. I would like to use a Picklist on some merged cells and for the picklist to span the merged cells. The Picklist itself is only visible in the first cell of the merged group because the SelectEditor 'acol' value is always the first cell column. Therefore the values are truncated and not readable.

Is it possible to have a Picklist which visually spans merged cells?

Thanks!

wp:
I don't know how you activate the picklist editor and thus cannot give a specific answer. Obviously your code does not extend the cell rect to cover the range of the merged cells. Please study the code of TsCustomWorksheetGrid.DoEditorShow in fpspreadsheetgrid; it shows how to measure the extent of the merged cells. Use this in Editor.SetBounds to define the size of the cell editor in this particular cell.

paweld:
Attached is a modified example of fpsgrid - a new event added: WorksheetGridSelectEditor.

morknot:
Thank you wp and paweld for your solutions. I now have picklists which span merged cells!

Regards

Navigation

[0] Message Index