https://bz.apache.org/bugzilla/show_bug.cgi?id=67271
--- Comment #4 from Matthias Raschhofer <[email protected]> --- Created attachment 39006 --> https://bz.apache.org/bugzilla/attachment.cgi?id=39006&action=edit Updated the example code to initialize the pivot field items and the pivot cache definition Hi Komal, The pivot table support in Apache POI is rather limited. When creating a new pivot table, POI only creates the general structure and data references. Excel will then refresh the pivot data upon opening the file. Regarding your issue, see this StackOverflow post for further helpful information: https://stackoverflow.com/questions/37305976/apache-poi-xssfpivottable-setdefaultsubtotal/40480654#40480654 It is not enough to set the defaultSubtotal field, which essentially just updates the underlying XML attribute. In order to remove the subtotal row from the pivot table, the pivot field items have to be adapted as well. I adapted your example code (PivotTableCode.java) to add the necessary changes. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
