sorry, It should be: https://issues.apache.org/ooo/show_bug.cgi?id=119943
On Thu, Jun 14, 2012 at 2:01 AM, debin lei <[email protected]> wrote: > Zhang Lu, pls check the URL, seem it is wrong. > > 2012/6/14 Zhang Lu <[email protected]> > > > Hi~ > > Another fix for review. > > > > https://issues.apache.org/ooo/show_bug.cgi?id=119943< > > https://issues.apache.org/ooo/show_bug.cgi?id=119941> > > > > Step: > > 1.Create a SC file. > > 2.Right click a cell-> Text and Cell Properties, switch to Number tab > page. > > 3.Selecet a number format.Say, "0.00" > > 4.Insert "_;" into the format code string. Say, "0_;.00", click OK. > > 5.The _ can not makes this number format skip a blank width as character > > ";". > > The ";" will be regarded as a separator in format code. > > > > Root Cause: > > Underline "_" can not work with ";" in format code, the semicolon will > > always be regarded as separator. > > when meet ";", number format scanner recognized it as a section divide > > symbol. ignore '*' and '_' before ';', and need to handle several place > > holder or other special symbol > > > > Resolution: > > if ';' is put behind of '_' and '*' (such escape symbol), recognized it > as > > a simple string and checked the number of such special symbol > > > > > > -- > Best regards > Lei Debin >
