wp, I came across the following problem:
var
WB : TsWorkbook;
WS, WS2 : TsWorksheet;
begin
WB := TsWorkbook.Create;
WB.Options := [boReadFormulas, boCalcBeforeSaving, boAutoCalc];
WS := WB.AddWorksheet('test');
WS.WriteNumber(5, 0, 10);
WS.WriteFormula(0, 0,'A6');
writeln('before ',WS.ReadAsNumber(0, 0));
WS2 := WB.AddWorksheet('test2');
WS2.WriteNumber(5, 0, 10);
WS2.WriteFormula(0, 0,'A6');
WS2.InsertRow(2);
writeln('after ',WS.ReadAsNumber(0, 0), ' ', WS2.ReadAsNumber(0, 0));
WB.WriteToFile('test.ods', true);
WB.Free;
readln;
end.
When I insert a row in WS2 it changes the formulas in other Worksheets too. It can also be seen in the dump.
Is it a bug, or I do something wrong?