Why CellReference is null?

Tiger Chen 1 Reputation point


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?


Office Open Specifications
Office Open Specifications
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Open Specifications: Technical documents for protocols, computer languages, standards support, and data portability. The goal with Open Specifications is to help developers open new opportunities to interoperate with Windows, SQL, Office, and SharePoint.
93 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Mike Bowen 936 Reputation points Microsoft Employee

    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

  2. Tiger Chen 1 Reputation point

    thank you!