Re: Perculiar problem reading validations from a XLSX exported from Google Sheets

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
>
>
>