-2146827284 Error in the Conditionally Formatted Spreadsheet Shipping Example.

Updated Aug 6, 2019

Reported In

Software

  • LabVIEW Report Generation Toolkit

Issue Details

I am creating an Excel report using the LabVIEW Report Generation Toolkit. I tried to run the Excel Report - Conditionally Formatted Spreadsheet.vi because I want to use different color for each cell using conditional format in my report. However, when I run it without any changes, the following error occurs. I have a Korean version of Microsoft Office installed on my PC.

Error -2146827284 occurred at Exception occurred in Microsoft Excel - Unable to set the NumberFormat property of the Range class. Help Path is xlmain11.chm and context 0 in NI_Excel.lvclass:Excel Set Cell Format.vi->Excel Report - Conditionally Formatted Spreadsheet.vi

This error code is undefined. Undefined errors might occur for a number of reasons. For example, no one has provided a description for the code, or you might have wired a number that is not an error code to the error code input.

Additionally, undefined error codes might occur because the error relates to a third-party object, such as the operating system or ActiveX. For these third-party errors, you might be able to obtain a description of the error by searching the Web for the error code (-2146827284) or for its hexadecimal representation (0x800A03EC).

Solution

This problem occurs when Microsoft Excel does not recognize the number format input in Excel Set Cell Format.vi.
Typically, shipping examples are validated against the English version. Therefore, this error may occur if MS Office is not the English version.

To resolve this problem, change the value of the number format input for your language. If you want to know the exact form of each language, see Review guidelines for customizing a number format. You can change the language setting on this page to see it in your preferred language.

Related Links

External Link: Number Format Codes

Other Support Options

Ask the NI Community

Collaborate with other users in our discussion forums



Request Support from an Engineer

A valid service agreement or active software subscription may be required, and support options vary by country.