The row() formula does not work correctly.
If there are no arguments inside the formula, then it returns the number of the line in which it is written. Now if the line is empty, the calculation is not performed.
procedure fpsROW(var Result: TsExpressionResult;
const Args: TsExprParameterArray);
{ ROW( [reference] )
Returns the row number of a cell reference (starting at 1!)
"reference" is a reference to a cell or range of cells.
If omitted, it is assumed that the reference is the cell address in which the
ROW function has been entered in. }
begin
Result := ErrorResult(errArgError);
if Length(Args) = 0 then
exit; // We don't know here which cell contains the formula.
case Args[0].ResultType of
rtCell : Result := IntegerResult(Args[0].ResRow + 1);
rtCellRange: Result := IntegerResult(Args[0].ResCellRange.Row1 + 1);
else Result := ErrorResult(errWrongType);
end;
end;
if Length(Args) = 0 then
exit; // We don't know here which cell contains the formula.
If you don't know that row() and column() behave differently in libraries, this can cause errors during operation.
If the value obtained when applying the formula row() is included in min(), then the calculation causes the program to freeze.
Formula column() same error
I am attaching an example file
my code:
b.Options := [boReadFormulas];
b.ReadFromFile('d:\test1\row.xlsx', sfOOXML);
sh := b.GetFirstWorksheet;
b.CalcFormulas; // << freeze
b.WriteToFile('d:\test1\444111111.xlsx', sfOOXML, true);
Description of the formula:
https://support.microsoft.com/en-us/office/row-function-3a63b74a-c4d0-4093-b49a-e76eb49a6d8d
Recent
