On 17/09/2020 16:42, Andreas Reichel wrote:
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.
Yep, OK. I will try this tomorrow and add the information to a ticket.
many thanks,
Stuart
Good luck and best regards
Andreas
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
