You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by Shan Zhu <sh...@gmail.com> on 2012/07/18 12:47:14 UTC
[QA BUG][Spreadsheet]Proposal to fix Bug 93128 in next AOO release.
Hi, all
There is a defect "*Bug
93128*<https://issues.apache.org/ooo/show_bug.cgi?id=93128>- Data
validity works incorrectly with criteria "Allow text length" for numbers"
in bugzilla.
It is about Validity.
The cell can not accept number in any format (say, integer, decimal, date,
percentage, etc) with "Text length" as validity rule.
"Text length" means the length of content in cell, it should not set a
limitation to the content format. It doesn't make sense.
And it will also impact the MSOffice interoperability, because Excel can
accept numbers with such a criteria. *Bug
117802*<https://issues.apache.org/ooo/show_bug.cgi?id=117802>had been
created for this side effect.
So, I suggest to fix it in next release and call for voluteer here. : )
Regards,
Shan Zhu
Re: [QA BUG][Spreadsheet]Proposal to fix Bug 93128 in next AOO release.
Posted by Shan Zhu <sh...@gmail.com>.
Hi, Juergen
I said "The next release" just want to separate it from Release Blocker of
AOO3.4.1. Perhaps, 3.4.2, 3.5, etc. : )
Thanks, Kevin.
Regards,
Shan Zhu
2012/7/18 Kevin Grignon <ke...@gmail.com>
> KG01 - see comments inline
>
> On Jul 18, 2012, at 7:08 PM, Jürgen Schmidt <jo...@googlemail.com>
> wrote:
>
> > On 7/18/12 12:47 PM, Shan Zhu wrote:
> >> Hi, all
> >>
> >> There is a defect "*Bug
> >> 93128*<https://issues.apache.org/ooo/show_bug.cgi?id=93128>- Data
> >> validity works incorrectly with criteria "Allow text length" for
> numbers"
> >> in bugzilla.
> >> It is about Validity.
> >> The cell can not accept number in any format (say, integer, decimal,
> date,
> >> percentage, etc) with "Text length" as validity rule.
> >>
> >> "Text length" means the length of content in cell, it should not set a
> >> limitation to the content format. It doesn't make sense.
>
> KG01 - agreed
>
> >> And it will also impact the MSOffice interoperability, because Excel can
> >> accept numbers with such a criteria. *Bug
> >> 117802*<https://issues.apache.org/ooo/show_bug.cgi?id=117802>had been
> >> created for this side effect.
> >>
> >> So, I suggest to fix it in next release and call for voluteer here. : )
>
> KG01 - Second the fix. Volunteers?
>
> > with next release you mean 3.5, correct
> >
> > Juergen
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> > For additional commands, e-mail: ooo-users-help@incubator.apache.org
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
Re: [QA BUG][Spreadsheet]Proposal to fix Bug 93128 in next AOO release.
Posted by Shan Zhu <sh...@gmail.com>.
Hi, Juergen
I said "The next release" just want to separate it from Release Blocker of
AOO3.4.1. Perhaps, 3.4.2, 3.5, etc. : )
Thanks, Kevin.
Regards,
Shan Zhu
2012/7/18 Kevin Grignon <ke...@gmail.com>
> KG01 - see comments inline
>
> On Jul 18, 2012, at 7:08 PM, Jürgen Schmidt <jo...@googlemail.com>
> wrote:
>
> > On 7/18/12 12:47 PM, Shan Zhu wrote:
> >> Hi, all
> >>
> >> There is a defect "*Bug
> >> 93128*<https://issues.apache.org/ooo/show_bug.cgi?id=93128>- Data
> >> validity works incorrectly with criteria "Allow text length" for
> numbers"
> >> in bugzilla.
> >> It is about Validity.
> >> The cell can not accept number in any format (say, integer, decimal,
> date,
> >> percentage, etc) with "Text length" as validity rule.
> >>
> >> "Text length" means the length of content in cell, it should not set a
> >> limitation to the content format. It doesn't make sense.
>
> KG01 - agreed
>
> >> And it will also impact the MSOffice interoperability, because Excel can
> >> accept numbers with such a criteria. *Bug
> >> 117802*<https://issues.apache.org/ooo/show_bug.cgi?id=117802>had been
> >> created for this side effect.
> >>
> >> So, I suggest to fix it in next release and call for voluteer here. : )
>
> KG01 - Second the fix. Volunteers?
>
> > with next release you mean 3.5, correct
> >
> > Juergen
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> > For additional commands, e-mail: ooo-users-help@incubator.apache.org
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
Re: [QA BUG][Spreadsheet]Proposal to fix Bug 93128 in next AOO release.
Posted by Kevin Grignon <ke...@gmail.com>.
KG01 - see comments inline
On Jul 18, 2012, at 7:08 PM, Jürgen Schmidt <jo...@googlemail.com> wrote:
> On 7/18/12 12:47 PM, Shan Zhu wrote:
>> Hi, all
>>
>> There is a defect "*Bug
>> 93128*<https://issues.apache.org/ooo/show_bug.cgi?id=93128>- Data
>> validity works incorrectly with criteria "Allow text length" for numbers"
>> in bugzilla.
>> It is about Validity.
>> The cell can not accept number in any format (say, integer, decimal, date,
>> percentage, etc) with "Text length" as validity rule.
>>
>> "Text length" means the length of content in cell, it should not set a
>> limitation to the content format. It doesn't make sense.
KG01 - agreed
>> And it will also impact the MSOffice interoperability, because Excel can
>> accept numbers with such a criteria. *Bug
>> 117802*<https://issues.apache.org/ooo/show_bug.cgi?id=117802>had been
>> created for this side effect.
>>
>> So, I suggest to fix it in next release and call for voluteer here. : )
KG01 - Second the fix. Volunteers?
> with next release you mean 3.5, correct
>
> Juergen
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: [QA BUG][Spreadsheet]Proposal to fix Bug 93128 in next AOO release.
Posted by Jürgen Schmidt <jo...@googlemail.com>.
On 7/18/12 12:47 PM, Shan Zhu wrote:
> Hi, all
>
> There is a defect "*Bug
> 93128*<https://issues.apache.org/ooo/show_bug.cgi?id=93128>- Data
> validity works incorrectly with criteria "Allow text length" for numbers"
> in bugzilla.
> It is about Validity.
> The cell can not accept number in any format (say, integer, decimal, date,
> percentage, etc) with "Text length" as validity rule.
>
> "Text length" means the length of content in cell, it should not set a
> limitation to the content format. It doesn't make sense.
> And it will also impact the MSOffice interoperability, because Excel can
> accept numbers with such a criteria. *Bug
> 117802*<https://issues.apache.org/ooo/show_bug.cgi?id=117802>had been
> created for this side effect.
>
> So, I suggest to fix it in next release and call for voluteer here. : )
with next release you mean 3.5, correct
Juergen
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org