Why CellReference is null?

Question

I created Excel file with some data. Why the CellReference is null while CellValue is something inputed?

I expect the CellReference is automatically created when Cell is created, right?

thanks!

Answer 1

Hi @Tiger Chen ,

The SDK is based on the Office XSDs from the underlying file format, and they show that it is valid for a cell to not have a CellReference attribute, so it is also valid in the OpenXML SDK. So, if you have a cell with a null CellReference then it must be added manually.

Best Regards,
Michael Bowen
Escalation Engineer - Microsoft Open Specifications

Answer 2

thank you！