Apache POI: Data is not visible in XLSX after updating POI version from 3.10 to 5.2.2

159 Views Asked by At

I was updating POI library from 3.10 to 5.2.2 after reported vulnerabilities in previous version.

I updated all the functions, classes according to the documentation and after all the changes .xlsx file also got generated but it's content is not visible in MS excel, how ever it is visible in some of the online editors and in openOffice I have to select default format to get the content visible.

Observations:

  1. All the values are treated as formula in excel because there is '(apostrophe) in each value, hence not visible.

  2. in OpenOffice values are visible, and in formula bar(with the apostrophe)enter image description here.

0

There are 0 best solutions below