After calling XSSFSheet.createTable using an AreaReference with a cell containing a line break in a column header, the generated Excel file is corrupted. Everything is described in detail here: https://stackoverflow.com/questions/63814180/apache-poi-createtable-generates-corrupted-file-when-a-headers-cell-contains-a
A quick check shows that XSSFDataValidation has code to do this encoding, and XSSFRichTextString has code to do the decoding Would it make sense to pull that out to a util method (XMLHelper? StringUtil? other?) for re-use, then call that for the Table header case too?
Hi Nick - sharing the code in a util makes sense
XMLHelper would probably be a good place
Added r1896246
and r1896247