Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 70AE8200CA7 for ; Wed, 14 Jun 2017 18:22:27 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 6F9E4160BDB; Wed, 14 Jun 2017 16:22:27 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id B5ABA160BC0 for ; Wed, 14 Jun 2017 18:22:26 +0200 (CEST) Received: (qmail 31431 invoked by uid 500); 14 Jun 2017 16:22:25 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Delivered-To: moderator for user@poi.apache.org Received: (qmail 23575 invoked by uid 99); 14 Jun 2017 16:19:54 -0000 X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.147 X-Spam-Level: X-Spam-Status: No, score=-0.147 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-2.796, RCVD_IN_SORBS_SPAM=0.5, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=zKps4r4dVFVNU9+kee2yUAFgAMwxXnd6swTi5wWNMIM=; b=bYnWLbjgRpZD02FRkQdNCfsSQr9ULokYogQJh+1NyG+jY7SC+bMbFxlwO+dXGMpRRW WTl99BL2zo04OQjbHE0DVPXnpaOx9QQVuSTTwCyuz8Bz+7zrk1u45vQO2P7ojDU5o3wV gN5JvRYaSkkxpEOElMALCrEPiAFZrKz008JcCHHJVACNAOrjO7Woq8PPLWmzXtAcRzkM N/do32ss1IdwbzIvyvxyUVpiKiEUDL2DudTiXuaME3G1YYFRDK6UyYIqsQlLIii8w8tU LoI8/Ahd5FWZZuCR/YqFPZuXbMeNIAkdrYUw3696Owjhotw/rwcFSFKrJ2FJnVieKVJG lTdg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=zKps4r4dVFVNU9+kee2yUAFgAMwxXnd6swTi5wWNMIM=; b=UHeLdK4UOhirzBt0yLfKWPL7LV9AEGuv4tNoGQ7Jts3IJDGkmRQBOhC49NYghvi3BX 2JgGjW5jaZHdQZ7CGjasCxyue1NibB8JJB8JLvPirAsPMTWUxTTLDjz7kBSY87EaX3NH ELMdtKxPQ4lT+KJTwAr9msoEul9MLTor9wZZvKoAcj8LB0tctI67qKi0Z0dr9tZcP6n9 xodmXxh5Ul1LuWPZaVtOTLvqtOd1gcKy3MkzFEwObOiTHNxMQEKDlOxEDHI6LWCG6I2E 4QVl5y/4xErk+yWafSUKa3zZK1HZusz3QgEoLRDYotwMBqqZNhSjjqqtEP75FvbIardp xjIw== X-Gm-Message-State: AKS2vOyFbViOHHaCrs5K9gGboXylz+WAA+i7LohR2tSJ5l+yuElR6MUG jhlZLvSPFqVJOENPxd2SSyB/aLQ0ZqTs X-Received: by 10.223.133.181 with SMTP id 50mr653666wrt.27.1497457192510; Wed, 14 Jun 2017 09:19:52 -0700 (PDT) MIME-Version: 1.0 From: Matthew Stiles Date: Wed, 14 Jun 2017 16:19:41 +0000 Message-ID: Subject: Pivot Table - Collapse Entire Field To: user@poi.apache.org Content-Type: multipart/alternative; boundary="001a1147d21006a7e00551edecb1" archived-at: Wed, 14 Jun 2017 16:22:27 -0000 --001a1147d21006a7e00551edecb1 Content-Type: text/plain; charset="UTF-8" Hi there, I asked about this on StackOverflow, and haven't received any answers yet, so I thought I would ask here as well. Does POI support the same functionality that is available in Excel by right clicking on a Pivot Table, then selecting Expand/Collapse -> Collapse Entire Field? Here is a link to my StackOverflow question, which goes into more detail: https://stackoverflow.com/questions/44378170/ Is there a simple function or something I am missing here in POI? Or is Excel doing a lot of work in the background that would translate to a lot of work in POI to achieve this? Thanks in advance, Matt --001a1147d21006a7e00551edecb1--