incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zhang Lu <zhanglu....@gmail.com>
Subject Re: [Call-for-​​Review][Calc]Underline "_" can not work with ";" in format code, the semicolon will always be regarded as separator
Date Thu, 14 Jun 2012 06:17:42 GMT
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 <debin.lei@gmail.com> wrote:

> Zhang Lu, pls check the URL, seem it is wrong.
>
> 2012/6/14 Zhang Lu <zhanglu.aoo@gmail.com>
>
> > 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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message