#583 ODS List validation are not retained after conversion

[sreenubabu]

List validation are not retained after conversion
Repro:-
1) Create an ods file
2) Select an cell in the a sheet of the ods file
3) Select Data-> validity
4) Click on Criteria -> allow -> select list
5) Enter some numbers in Entries for the list
6) Click on Input Help & Error Alerts -> Give some inputs for them and check on “show Error messages when invalid values are entered”
7) Save the ods file and convert it to xlsx file using the add-in “Open ODF” option
Actual result:-
List validations are not retained after conversion. list for the cell is not displayed after conversion
Expected result:-
List validations should be properly retained after conversion.
Please see the input and output files for reference:-
Input filename:-111.ods
Output filename: - Copy of 111_tmp.xlsx
Build_Id:-R4126(Add-ins)
OS:-W2K3
Office: - 2007 RTM
Reproducible:-yes
Type of bug: -Formatting
Conversion sequence: - Forward (i.e. ods -> xlsx)
Severity: - No Go
Degree of occurrence:- Systematic

[sreenubabu]

[Ruth S.]

R5248
Office 2007

The list for the cell is still not displayed after conversion.
The list validation is not retained properly either: It is now restricted to the value which is already entered in the cell ("105"). Trying to enter any other value will cause an error message.