Can't read some cells of the file when using load()

QtExcel / Qxlnt

Use xlnt in Qt 5 or 6. xlnt is cross-platform user-friendly xlsx library for C++1x.

https://qtexcel.github.io/Qxlnt/

MIT License

80 stars 23 forks source link

Can't read some cells of the file when using load() #9

Open BenoitFalys opened 3 years ago

BenoitFalys commented 3 years ago

Hi, I was getting errors when reading some files, so I tried the HelloQXlnt. It seems that there is a bug when trying to read copied function cells. I'm on Windows 10. This is the simple code I used and the Excel file : example.xlsx

j2doll commented 3 years ago

I found the error to occur in the following part:

<f ca="1">RAND()</f>

This seems to be the difference in how xlnt handles ecma376.