incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lei Wang <lei.wang.l...@gmail.com>
Subject Re: [Call-for-Review][Calc][From Symphony]Formula GETPIVOTDATA returns #REF! value
Date Thu, 14 Jun 2012 06:41:41 GMT
Done. Thanks for your contribution

On Wed, Jun 13, 2012 at 9:02 PM, Lei Wang <lei.wang.leiw@gmail.com> wrote:

> I will take care of this one.
>
>
> On Wed, Jun 13, 2012 at 2:07 PM, 彭云全 <pengyunquan@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.
>>
>
>

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