Done. Thanks for your contribution On Wed, Jun 13, 2012 at 9:02 PM, Lei Wang <lei.wang.l...@gmail.com> wrote:
> I will take care of this one. > > > On Wed, Jun 13, 2012 at 2:07 PM, 彭云全 <pengyunq...@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. >> > >