Hi,
I've encountered an odd problem reading validations from an xlsx
spreadsheet uploaded to Google Drive, and then exported.
To cut a long story short, my particular use-case involves a pipeline of
creating an Excel spreadsheet, which is then shared and used via Google
Sheets to allow scienti
Stuart,
maybe you could provide the simpliest possible test case, e. g.
creating your form with only 2 columns and 1 row, add the validation
and then:
1) extract the XML after your created the template
2) extract the XML after you have exporting it from Google spreadsheets
3) extract the XML afte
Hi,
comments below ...
On 17/09/2020 11:48, Andreas Reichel wrote:
Stuart,
maybe you could provide the simpliest possible test case, e. g.
creating your form with only 2 columns and 1 row, add the validation
and then:
I found when creating a sheet as simple as you suggest, POI wasn't able
fin
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/re
On 17/09/2020 16:26, Stuart Owen wrote:
Hi,
comments below ...
On 17/09/2020 11:48, Andreas Reichel wrote:
Stuart,
maybe you could provide the simpliest possible test case, e. g.
creating your form with only 2 columns and 1 row, add the validation
and then:
I found when creating a sheet as
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-ex
Stuart,
On Thu, 2020-09-17 at 17:07 +0100, Stuart Owen wrote:
> > I'm not familiar with the format enough to know if this is legal or not.
>
> to add, I've tried validating the xml against its schema, and it appears
>
> to be legal.
I do not doubt that. I would suspect that POI is falsely exp