Sorry the (most probably) stupid question, I cannot find the right options to enable cells editing after a file have been loaded.
I have this minimal code, that works like a charm, but I'm unable to change the content *after* the file has been loaded.
procedure TForm1.OpenExcelFileClick(Sender: TObject);
begin
if OpenDialog1.Execute then
sWorksheetGrid1.LoadFromSpreadsheetFile(OpenDialog1.FileName);
end;
procedure TForm1.SaveAsClick(Sender: TObject);
begin
if SaveDialog1.Execute then
sWorksheetGrid1.SaveToSpreadsheetFile(SaveDialog1.FileName);
end;
I have managed to modify the content adding
a sCellEdit1: TsCellEdit;
and a
sWorkbookSource1: TsWorkbookSource;
to connect the sWorksheetGrid1 to sCellEdit1, and tried (again) to check/uncheck options/goEditing and AutoEdit, but to change a cell content I must enter the text in sCellEdit1 and press enter, which is strange, since it's required *only* after a file has been loaded.
Could someone drop me an hint ?
TIA, Carlo