Hi I've asked on the OpenXml Sdk forum but that place seems about as active... not very active.
I'm doing some server side excel output using the OpenXML Sdk v2 ctp. Has anyone here had any experience using this - mpre specifically:
Is there a way to add subtotals to data in a spreadsheet using the SDK? or do i need to manually iterate over the data adding the OutlineLevel property?
rows.Add(new Row(cells.ToArray()) { RowIndex = (UInt32Value)Convert.ToUInt32(idx), Spans = new ListValue() { InnerText = "1:2" }, OutlineLevel = (ByteValue)groupLevelCount });
this would be a real PITA if I have to do it manually as there I need to do multi level grouping and sorting :s
-- Cheers,
w://