X14 Data validation reference sequence only keep first cell

[Aeradriel]

Hello,

Using an excel file with x14 data validation, it appears that opening and saving the file leads to data validation only kept on the first cell of the range. By looking a bit into the code, it appears that in the DataValidation struct (of the office2010/excel module), the reference sequence contains only one coordinate (vs a range in the "classic" data validation). As you can see below, I am correctly having a range in my excel file. It looks like a bug to me but if I'm doing something wrong, feel free to point me to the right direction.

DataValidation "classic"

DataValidation office2010/excel

Excel data validation example

<x14:dataValidation type="list" allowBlank="1" showInputMessage="1" showErrorMessage="1" xr:uid="{00000000-0002-0000-0100-000008000000}">
    <x14:formula1>
        <xm:f>Lists!$F$2:$F$31</xm:f>
    </x14:formula1>
    <xm:sqref>H6:H999 J6:J999 M6:M999</xm:sqref>
</x14:dataValidation>

[MathNya]

@Aeradriel Thank you for your report. We have checked and found it to be a bug. We will address it in the next update.

[MathNya]

The latest version has been released. Please confirm that the problem has been fixed.