QXlsx
QXlsx copied to clipboard
Cell is incorrectly interpreted as DateTime
Hi,
First of all: Great work 👍
Now to what I have found: In the attached test file, the two cells A2 and A3 are interpreted as DateTime. This is wrong. The values are clearly numbers. The reason is the custom formatting of the cell as you can see in the screenshot (german excel).
NumFormatParser::isDateTime(const QString &formatCode) causes the error. The formatCode is checked for 'd' and 'm' with regard to the date. Shouldn't false be returned if '#' is part of it ?