search

unvell / ReoGrid

Fast and powerful .NET spreadsheet component, support data format, freeze, outline, formula calculation, chart, script execution and etc. Compatible with Excel 2007 (.xlsx) format and working on .NET 3.5 (or client profile), WPF and Android platform.
https://reogrid.net
MIT License
1.33k stars 396 forks source link

Read Excel Formula Mistake #21

Open Navasender opened 7 years ago

Navasender commented 7 years ago

Hi, I have written a little code in VB NET to read the cells data from an excel file where there is some formulas. However, the read result is different from the value that is in the original excel sheet and I don't know why. In the column O2 to O7 of the excel file the value is "Case01", Case04", "Case03", "Case07", Case08" but the values that the program read are: "Case01","Case04","Case08","Case08","Case08". (I attach the screen image of the excel file and the program, the code in a txt file and the excel file). Could you help me to discover where is my mistake? Thank you

Form1.vb.txt

Data01.xlsx imagen

imagen

jingwood commented 7 years ago

Seems the <> operator doesn't work like Excel when compare number and string. Can someone fix this?