I set NumberFormat for a cell to be "General". But it falls when using Excel 2002 Japan version where it uses NumberFormatLocal =?{some japanese word}.
How to tackle the General format in different Office?
The NumberFormat property uses the same format string in different language versions. In your case it is "General".
NumberFormatLocal does the same in local language, it is text displayed in cell formatting dialog.
They are two different properties that set the same thing, the same is for Formula(Local), Name(Local), RefersTo(Local), Category(Local).
But I had a better idea. In one of the worksheet of the Excel template, I preset a cell to be General in Number format. During the creation of worksheet at runtime, I assign the numberformatlocal of that cell to the new worksheet. This will ensure it caters for all other language Excels.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.