#239 Number format not properly retained

[sreenubabu]

Number format not properly retained
Repro:-
1) Create an ods file.
2) Insert a number with #"product id #"###" amount $"###.## custom number format( for example if we insert a number 12345 in the cell , the cell will display “product id #12 amount $345”)
3) Save the ods and convert it to excel using the add-in open ODF option.

Actual result:-
#"product id #"###" amount $"###.## custom number format is converted as #.## to xlsx.
Expected result:-
Number format should be properly retained after conversion

Please see the input and output files for reference:-
Input filename:-Num1.ods
Output filename:-Num1.xlsx
Build_Id:-R2622.
OS:-W2K3
Office version:- 2007 RTM
Severity:- No Go
Type of bug:- Formatting
Reproducible:-yes
Conversion sequence:- Forward
Degree of occurrence:-Systematic.

[sreenubabu]

[Ruth S.]

R5239
Office 2007

Problem Persists.