https://bugs.documentfoundation.org/show_bug.cgi?id=154600
Bug ID: 154600
Summary: PIVOTTABLE: Wrong anchor (SUM) fields
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
One of our customers at SoftMaker had a serious problem with pivot tables.
The customer exported the calc document to xlsm format with Libre Office.
PlanMaker and Excel can't import the file completely because of bugs.
Basics:
- For 2+ data fields, an anchor field (SUM Symbol) is added to a pivot table.
- The anchor field is in row fields or in column fields.
Bugs in Libre Office:
- The anchor field is the the data fields.
- The anchor field has a wrong field index of -2.
Data from the calc document:
<pivotFields count="25">
....
</pivotFields>
<rowFields count="1">
<field x="4"/>
</rowFields>
<dataFields count="3">
<dataField name="Soma de ACERTOS" fld="12" subtotal="sum"
numFmtId="164"/>
<dataField name="Soma de ERROS" fld="13" subtotal="sum"
numFmtId="164"/>
<dataField name="Soma - " fld="-2" subtotal="sum"/>
</dataFields>
Thanks for fixing it.
--
You are receiving this mail because:
You are the assignee for the bug.
