Incorrect, misplaced or missing cell values

EPPlusSoftware / EPPlus

EPPlus-Excel spreadsheets for .NET

https://epplussoftware.com

Other

1.8k stars 274 forks source link

Incorrect, misplaced or missing cell values #1530

Closed robincodex closed 3 months ago

robincodex commented 3 months ago

EPPlus usage

Personal use

Environment

Windows

Epplus version

7.2.1

Spreadsheet application

Microsoft365 Excel

Description

test.xlsx This file was exported by me from a cloud document, after reading the file the cell values are not correct, I tried to read the file using other libraries (e.g. NPOI) is normal values. I think there may be data formats that EEPLUS did not consider, resulting in incorrect cell values.

JanKallman commented 3 months ago

Yes, this is a bug. It seems to happen if you have a shared string item with rich text and an empty <rPr> element. I will provide a fix shortly.

JanKallman commented 3 months ago

Fixed in EPPlus 7.2.2

robincodex commented 3 months ago

Fixed in EPPlus 7.2.2

Great, thanks!