QXlsx icon indicating copy to clipboard operation
QXlsx copied to clipboard

Cell is incorrectly interpreted as DateTime

Open celoewe1971 opened this issue 3 years ago • 0 comments

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 ?

screenshot test.xlsx ,

celoewe1971 avatar Nov 20 '21 05:11 celoewe1971