Reading Data from a calculated Cell return Incorrect value

paulyoder / LinqToExcel

Use LINQ to retrieve data from spreadsheets and csv files

MIT License

1.06k stars 299 forks source link

Reading Data from a calculated Cell return Incorrect value #138

Open ChristianVega5421 opened 6 years ago

ChristianVega5421 commented 6 years ago

Hi,

I am trying to read the data from a sheet that has some calculated data, but when I parse them into an entity starts the weird thing, for example if it is a substraction from 2 dates it get an incorrect value (i have 80 and return 78 and the same thing with all the calculated values) i think this happens just with dates. If anyone can confirm me this and what is the solution would be appreciated.

Thanks

mrworkman commented 6 years ago

I'm not sure how the database engine that reads the excel files handles formulas/date-math. I will try to look into this if I can reproduce the problem.