Jamin Roth

+1 OData has been great, but in order to meet new requirements we need aggregation or we'll have to implement something outside of OData.

I've been having the same problem. Here is a quick repro: var spreadsheet = SpreadsheetDocument.Open(filename, true); WorksheetPart worksheetpart = spreadsheet.WorkbookPart.WorksheetParts.First(); var sheetData = worksheetpart.Worksheet.GetFirstChild(); var firstRow = sheetData.Elements().FirstOrDefault(p => p.RowIndex.HasValue...

The work around I've been using is to remove the calculation chain and force excel to recalculate on load. eg: if (WorkbookPart.CalculationChainPart != null) { WorkbookPart.DeletePart(WorkbookPart.CalculationChainPart); } WorkbookPart.Workbook.CalculationProperties.ForceFullCalculation = true;...