how can i change title of column from "A,B.C,.." to "1,2,3..." of
FPSpreadsheet?
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
wylton · 2018-04-12 18:59

sometime i need "1,2,3.." for work..

----------------------------------------------------------------------
Handoko · 2018-04-12 19:12

As far as I know we cannot change the title of column in Excel nor
LibreOffice Calc so the same is in FPSpreadsheet. Maybe you can use
TStringGrid.

----------------------------------------------------------------------
wp · 2018-04-12 20:10

In r6302 of fpspreadsheet you can write handlers for the WorksheetGrid
events OnGetRowHeaderText and OnGetColHeaderText to override the row
and column headers. Example:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i procedure
TForm1.sWorksheetGrid1GetColHeaderText(Sender: TObject;  AIndex:
Integer; var AText: String);begin  AText := 'Col ' +
IntToStr(AIndex);end; procedure
TForm1.sWorksheetGrid1GetRowHeaderText(Sender: TObject;  AIndex:
Integer; var AText: String);begin  AText := 'Row ' +
IntToStr(AIndex);end;
Finally one thing which fpspreadsheet can do, but Excel and Calc
cannot!

----------------------------------------------------------------------
fmolina · 2018-05-27 03:27

Hi,

I cannot find these events in the last released version. Are they in
trunk? Do they work reliably?

Regards

----------------------------------------------------------------------
wp · 2018-05-27 08:16

They are in trunk, not yet released.

Reliably? Whatever can go wrong will go wrong. So, if you want an
exact answer: "no". But to the best of my knowledge: "yes".

----------------------------------------------------------------------
fmolina · 2018-05-28 02:24

OK, OK, I am aware or Murphy's law. "The best of my knowledge" is what
I expected.

----------------------------------------------------------------------
wp · 2018-06-02 16:38

"Best of my knowledge" was not enough... Recent versions of Laz trunk
did not display the column headers any more due to a change in the LCL
grids which required an adaption of the TsWorksheetGrid. Should work
again now.