You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openoffice.apache.org by 彭云全 <pe...@gmail.com> on 2012/06/13 08:07:27 UTC
[Call-for-Review][Calc][From Symphony]Formula GETPIVOTDATA returns
#REF! value
Hi All,
My name is pengyunquan. I am a developer working several years in
Symphony team. My special areas are PivotTable / Graphic / VCL /
Performance.
I have a patch for review.
https://issues.apache.org/ooo/show_bug.cgi?id=119972
Root Cause : Within MS Excel, the user-defined field name( called
"Layout Name" in AOO ) can be used in the Formula "GETPIVOTDATA", and
MS Excel will check original field name & Layout Name. But in AOO,
just orginal field name & an automatically generated data field name
are checked. When outputting Pivot Table, the data field name is
outputted as automatically generated data field name if the Layout
name is invalid, while the data field name will be outputted as the
Layout name if the Layout name is valid. For the users, they just see
the outputted name, and the formula "GETPIVOTDATA" should check the
outputted name. As a result, the formula "GETPIVOTDATA" should check
the Layout name if the Layout name is valid, and check the
automatically generated data field name if the Layout name is invalid.
Re: [Call-for-Review][Calc][From Symphony]Formula GETPIVOTDATA
returns #REF! value
Posted by Lei Wang <le...@gmail.com>.
Done. Thanks for your contribution
On Wed, Jun 13, 2012 at 9:02 PM, Lei Wang <le...@gmail.com> wrote:
> I will take care of this one.
>
>
> On Wed, Jun 13, 2012 at 2:07 PM, 彭云全 <pe...@gmail.com> wrote:
>
>> Hi All,
>>
>> My name is pengyunquan. I am a developer working several years in
>> Symphony team. My special areas are PivotTable / Graphic / VCL /
>> Performance.
>>
>> I have a patch for review.
>> https://issues.apache.org/ooo/show_bug.cgi?id=119972
>>
>> Root Cause : Within MS Excel, the user-defined field name( called
>> "Layout Name" in AOO ) can be used in the Formula "GETPIVOTDATA", and
>> MS Excel will check original field name & Layout Name. But in AOO,
>> just orginal field name & an automatically generated data field name
>> are checked. When outputting Pivot Table, the data field name is
>> outputted as automatically generated data field name if the Layout
>> name is invalid, while the data field name will be outputted as the
>> Layout name if the Layout name is valid. For the users, they just see
>> the outputted name, and the formula "GETPIVOTDATA" should check the
>> outputted name. As a result, the formula "GETPIVOTDATA" should check
>> the Layout name if the Layout name is valid, and check the
>> automatically generated data field name if the Layout name is invalid.
>>
>
>
Re: [Call-for-Review][Calc][From Symphony]Formula GETPIVOTDATA
returns #REF! value
Posted by Lei Wang <le...@gmail.com>.
I will take care of this one.
On Wed, Jun 13, 2012 at 2:07 PM, 彭云全 <pe...@gmail.com> wrote:
> Hi All,
>
> My name is pengyunquan. I am a developer working several years in
> Symphony team. My special areas are PivotTable / Graphic / VCL /
> Performance.
>
> I have a patch for review.
> https://issues.apache.org/ooo/show_bug.cgi?id=119972
>
> Root Cause : Within MS Excel, the user-defined field name( called
> "Layout Name" in AOO ) can be used in the Formula "GETPIVOTDATA", and
> MS Excel will check original field name & Layout Name. But in AOO,
> just orginal field name & an automatically generated data field name
> are checked. When outputting Pivot Table, the data field name is
> outputted as automatically generated data field name if the Layout
> name is invalid, while the data field name will be outputted as the
> Layout name if the Layout name is valid. For the users, they just see
> the outputted name, and the formula "GETPIVOTDATA" should check the
> outputted name. As a result, the formula "GETPIVOTDATA" should check
> the Layout name if the Layout name is valid, and check the
> automatically generated data field name if the Layout name is invalid.
>