Hello,
if you draw border an any side of cell, then you can't open format cell dialog in excel more.
I tested it with Excel Xp and Excel 2012.
You can test it with spready application or with the example from below.
How to test:
1.) Open test2.xls which created by the example program below in Excel.
2.) select one of the cells from first or second row (below or under the cell with line)
3.) now you can't open Cellformat dialog in excel.
Is this bug or my mistake?
program excelexport1;
uses sysutils, laz_fpspreadsheet,fpspreadsheet, fpsTypes;
var aWbk: TsWorkbook;
aWst: TsWorksheet;
r,c: integer;
s:string;
begin
aWbk := TsWorkbook.Create;
try
aWst := aWbk.AddWorksheet('Tabelle1');
for r:=0 to 4 do begin
for c:=0 to 3 do begin
aWst.WriteText(r,c,Format('%d:%d',[r,c]));
if r=1 then aWst.WriteBorders(r,c,[cbNorth]);
end;
end;
aWbk.WriteToFile(ExtractFilePath(ParamStr(0))+'test2.xls', sfExcel8, true);
finally
aWbk.Free;
end;
end.