On Thu, 2020-09-17 at 16:26 +0100, Stuart Owen wrote: > original - > https://github.com/stuzart/poi-google-export-testcase/blob/master/src/test/resources/original-unpacked/xl/worksheets/sheet1.xml#L17 > > exported - > https://github.com/stuzart/poi-google-export-testcase/blob/master/src/test/resources/exported-unpacked/xl/worksheets/sheet1.xml#L1003 > > resaved - > https://github.com/stuzart/poi-google-export-testcase/blob/master/src/test/resources/resaved-unpacked/xl/worksheets/sheet1.xml#L1007
Stuart, maybe you would like to open a ticket in the POI's bug tracker with your finding. In the meantime, you could try to add the missing count="1" attribute by yourself? For example: 1) unzip the XLSX 2) find the xml node dataValidations, count the child elements and add the count="..." accordingly 3) zip into the XLSX file again If your files are small enough, than I would read the complete DOM of the XML. If your files are large, then maybe GREP/SED could be helpful. Maybe test your/our assumption first with a test case having count="3". When editing the XML manually and adding the count="..." attribute helps, it was definitely worth to file a ticket. Good luck and best regards Andreas
