Qxlnt icon indicating copy to clipboard operation
Qxlnt copied to clipboard

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

Open BenoitFalys opened this issue 4 years ago • 1 comments

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

image

BenoitFalys avatar Jan 14 '21 07:01 BenoitFalys

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.

j2doll avatar Jan 17 '21 13:01 j2doll