Bug 80265 - Request: Calc should accept and auto-correct full-width brackets "()" to half-width "()"
Summary: Request: Calc should accept and auto-correct full-width brackets "()" to half...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) Master
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Cell-Formula
  Show dependency treegraph
Reported: 2014-06-20 05:41 UTC by Kevin Suo
Modified: 2020-08-14 23:35 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2014-06-20 05:41:25 UTC

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".

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
Comment 1 Kevin Suo 2014-06-20 06:03:20 UTC
For the description of fullwidth and halfwidth chars in CJK , see this wiki page:
Comment 2 Yousuf Philips (jay) (retired) 2014-06-24 07:40:14 UTC
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. :)
Comment 3 Yousuf Philips (jay) (retired) 2014-06-24 07:46:28 UTC
(In reply to comment #2)
> Kingsoft Writer

I mean't Kingsoft Spreadsheet. :)