(Version 3)
I have noticed that when I change a cell border, the TFlexCelGrid shows a single line border, and the resulting Excel spreadsheet shows the actual TFlxBorderStyle that I set.
For the TFlexCelGrid in version 6, will this show the actual border type?
I haven't added a border ColorIndex yet. Will that show a color in version 3?
Thanks!
Hi,
Border colors show in FlexCelGrid, but border styles don't. This is mainly a limitation of TCustomGrid from were we derive, the CellPaint event doesn't allow you do paint outside the cell.
FlexCel 6 doesn't have a TFlexCelGrid, this is a FlexCel 3 only component. You can use FlexCelGrid with the FlexCel 6 engine by using TXlsxAdapter, so you get recalculation and a lot of other stuff like xlsx support, but it still is the same v3 FlexCelGrid.
We are looking into doing a TFlexCelSpreadsheet for this year for v6, and if we do it it will most likely support all border styles since it won't derive from TCustomGrid. The FlexCel 6 renderer (used to print, preview, export to pdf, etc) already support border styles too.
OK. Thank you for the information.