web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Bug in 2013: Microsoft.Dynamics.Nav.OpenXml.Spreadsheet.CellData.HasValue - can't read mixture or bold and normal font

(0) ShareShare
ReportReport
Posted on by

I'd like to report a bug found in NAV 2013 version 7.00.33781.

Table 370, function Readsheet - "CellData.HasValue" will error with a meaningless (not telling you which cell is the problem) error if the cell it is reading has a mixture of normal and bold text.

The error is ".... Microsoft.Dynamics.Nav.OpenXML.Spreadsheet.CellData.HasValue failed this message: Object reference not set to an instance of an object".

How to duplicate the error.

Create a new Excel workbook - in cell A1 type:  "This is a mixture of normal and " <ctrl-b> "bold" <ctrl-b> " text" - save spreadsheet.

NAV: /Departments/Financial Management/General Ledger/G/L Budgets - Edit Budget - Import from Excel - select the workbook and sheet just saved - ok to start the import.

 

*This post is locked for comments

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans