incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 119972] [From Symphony]Formula GETPIVOTDATA returns #REF! value
Date Wed, 13 Jun 2012 04:08:09 GMT
https://issues.apache.org/ooo/show_bug.cgi?id=119972

pengyunquan <yunquanp@cn.ibm.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #78275|                            |review?
              Flags|                            |

--- Comment #2 from pengyunquan <yunquanp@cn.ibm.com> ---
Created attachment 78275
  --> https://issues.apache.org/ooo/attachment.cgi?id=78275&action=edit
Fix patch for Bug 119972

The Root Cause is that 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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Mime
View raw message