OpenXML SDK: How do I find the formula in a CellFormula where the type is "dataTable"?

Question

I'm writing an application in C# to read formulas from various cells in an Excel spreadsheet, and one section is giving me trouble. In Excel, it displays the formula as "{=TABLE(,B5)}" for all cells in this range.

I stepped through my C# application to see what the properties are, but there's no actual formula listed anywhere I can find (the CellFormula is an empty string). The InnerXml/OuterXml indicates a CellFormula, I tried reading through the SDK documentation for them, but it is confusing and vague when it comes to "dataTable" types.

Supposedly the relevant information is in the top-left corner of the dataTable section, which is cell D15. This is how the OuterXml looks:

<x:c r="D15" s="377" xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><x:f t="dataTable" ref="D15:G35" dt2D="0" dtr="0" r1="B5" ca="1" /><x:v>3.0000000000000001</x:v></x:c>

Where is the formula? How does Excel know what to calculate in this range D15:G35?

Answer 1

Chris posted the question here https://github.com/dotnet/Open-XML-SDK/discussions/1427, if anyone else interested the similar topic can follow the link to GitHub.