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 Wed, 13 Jun 2012 13:02:48 GMT
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