I have one machine, a test machine, which for some reason is returning an incorrect value from the Cell.DisplayStringValue method.
Using an Excel 2007+ (xlsx) workbook, select a cell and go into Format Cell.
Under the Number, select Custom, and enter a value of 0#
Cell format: 0#
Place a value of 1 in the cell. It should display as 01
When reading the cell, using the DisplayStringValue method, this one machine returns 01. (note the period at the end).
Expected Value: 01
Returned Valued: 01.
Has anyone ever encountered this before? This seems to only happen on this one machine with versions 9.3.4+ (9.4).
I am working on building multiple test platforms to attempt to replicate the issue and narrow down the cause. Any help is appreciated.