Why CellReference is null?

Tiger Chen 1 Reputation point
2022-12-05T10:32:44.863+00:00

267221-cellreference.png

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!

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.
127 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mike Bowen 1,516 Reputation points Microsoft Employee
    2022-12-05T20:42:56.553+00:00

    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

    0 comments
  2. Tiger Chen 1 Reputation point
    2022-12-06T23:31:25.55+00:00

    thank you！

    0 comments