Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Get cell value bug #144

Closed
Tracked by #159
Asbjoedt opened this issue Aug 3, 2022 · 3 comments
Closed
Tracked by #159

Get cell value bug #144

Asbjoedt opened this issue Aug 3, 2022 · 3 comments

Comments

@Asbjoedt
Copy link

Asbjoedt commented Aug 3, 2022

This document:

https://github.com/OfficeDev/open-xml-docs/blob/live/docs/how-to-retrieve-the-values-of-cells-in-a-spreadsheet.md

Has this issue:

On this code:
if (theCell.InnerText.Length > 0)

It throws exception:
System.NullReferenceException: 'Object reference not set to an instance of an object.'

The exception happens when you want to find value of any cell in row A, if row A has been formatted to be a table, which means cells in row A will have name Column1, Column2 etc. and they will be filtering and sorting options.

@tomjebo
Copy link
Collaborator

tomjebo commented Aug 18, 2022

@Asbjoedt what version of the Open XML SDK are you using?

@mikeebowen
Copy link
Collaborator

@Asbjoedt , does #296 resolve this?

@Asbjoedt
Copy link
Author

@mikeebowen
Thanks for taking the time to fix this.
I won't be checking if the bug is fixed, I will trust you on this one.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants