Description: When you input a formula in Calc, the valid round bracket is "()". However, for many users (like our Chinese users), when they are inputting formulas they may incorrectly type brackets like "()". "()" is "Full-width" chars, and is very common for Chinese users. Microsoft Office has the functionality to auto-correct the "Full-width" brackets to "half-width" brackets. For example, when you type in cell A1 "=(1+1)" and hit ENTER, MSO auto-correct the formula to "=(1+1)" and calculates the correct result "2". P.S.: In fact, Calc already has the functionality to auto-correct some chars within formula which the users input by mistake, for example: when you input "=1x1", Calc will ask you if you accept the suggestion to correct the formula as "=1*1". So I think what is needed is to just include "()" to the auto-correction char list. This enhancement request was first raised in the Chinese LibreOffice discussion forum, see here: http://libreofficechina.org/thread-9-1-1.html
For the description of fullwidth and halfwidth chars in CJK , see this wiki page: http://en.wikipedia.org/wiki/Fullwidth_form#Full
Confirmed it gives an 'Err:501' value in the field in Calc 4.3.0. It works fine in Kingsoft Writer but Excel 2013 returned an error. I'm assuming the autocorrect in MSO might be limited to only the chinese version, while i'm using the english version. :)
(In reply to comment #2) > Kingsoft Writer I mean't Kingsoft Spreadsheet. :)
I'm not sure what the appropriate implementation is, but at least I can give a possible sourcecode pointer https://opengrok.libreoffice.org/search?project=core&full=&defs=&refs=bCorrected&path=&hist=&type=&xrd=&nn=1