Hello,
When we are using the SUBTOTAL function on a cell and try to query the value of the cell, it returns '#NAME?' and cannot retrieve the value.
Here is the test that goes along with the attached Sheet.
[Test]
public void Value_SubtotalCell_ReturnsValue()
{
var workbook = new Workbook();
workbook.Open("SubtotalFunction.xls", FileFormatType.Default);
workbook.CalculateFormula();
var worksheet = workbook.Worksheets[0];
var cell = worksheet.Cells[0, 0];
Assert.IsNotNull(cell);
Assert.IsTrue(cell.StringValue.Equals("10"));
}
Thanks,
Michael