Return-Path: Delivered-To: apmail-poi-user-archive@www.apache.org Received: (qmail 66682 invoked from network); 30 Apr 2009 02:34:57 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 30 Apr 2009 02:34:57 -0000 Received: (qmail 52978 invoked by uid 500); 30 Apr 2009 02:34:56 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 52920 invoked by uid 500); 30 Apr 2009 02:34:56 -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 Received: (qmail 52910 invoked by uid 99); 30 Apr 2009 02:34:56 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 30 Apr 2009 02:34:56 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of lucasd2130@gmail.com designates 209.85.220.180 as permitted sender) Received: from [209.85.220.180] (HELO mail-fx0-f180.google.com) (209.85.220.180) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 30 Apr 2009 02:34:48 +0000 Received: by fxm28 with SMTP id 28so1622765fxm.21 for ; Wed, 29 Apr 2009 19:34:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:date:message-id:subject :from:to:content-type; bh=Ovx42rbvjRoMqRdQHvys4+aaX1Pt8i7KLVYu7ApOl0w=; b=BW71RZvj/Qhro0GDjrcHBj4D3N5otBOhXDKoO+ZDSbAlOMWo0Yj7Hda7VqdXhSg5v8 2aoijPgbJClVdxJ5Z/JsoXYrYvhHtjOboakg2KTjkuMlqQf8N4OAdJ2jyijpTD3M1+jc 3xLnOAlhE7xudydaPrLyB0ZCHxTqN7AXmqHhQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=dwBdPXF+cmjM0y0tUmQbjj+V5KfFNW9ZNBj26JIpkB7AtubbW4LtyU5NdRVf08OYsp 6s319eiI/cfl4pzv7C1X5hudXZ3GPx80HzN3wkF7juHVn5JQjs5OZ2lux0kspMm342ob ry1IMe5Gg6ufN76frEAQ6nAv+iVj9JEZ8TemU= MIME-Version: 1.0 Received: by 10.103.91.2 with SMTP id t2mr662593mul.47.1241058867732; Wed, 29 Apr 2009 19:34:27 -0700 (PDT) Date: Wed, 29 Apr 2009 22:34:27 -0400 Message-ID: Subject: Java POI HSSF issue with Excel Outline and Expand/Collapse From: David Lucas To: user@poi.apache.org Content-Type: multipart/alternative; boundary=00163662e569f4e2390468bc88cd X-Virus-Checked: Checked by ClamAV on apache.org --00163662e569f4e2390468bc88cd Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Hi All, I'm running into an issue with Excel Outlining using POI HSSF. I create three groups with "Test1" being the root node. I collapse each group as well using setRowGroupCollapsed. However, when I expand the first node on the Excel File generated, all the other nodes are also expanded. Is there a setting to prevent this? I would like to have all levels collapsed and if I expand the first level, the lower levels should remain collapsed until I expand them. Below is my test code and any help is greatly appreciated. Thanks in advance sheet.setAlternativeExpression(false); sheet.setRowSumsBelow(false); Row excelRow = null; Cell excelCell = null; excelRow = sheet.createRow( 0 ); excelCell = excelRow.createCell( 0 ); excelCell.setCellValue( "Test 1" ); excelRow = sheet.createRow( 1 ); excelCell = excelRow.createCell( 1 ); excelCell.setCellValue( "Test 2" ); excelRow = sheet.createRow( 2 ); excelCell = excelRow.createCell( 2 ); excelCell.setCellValue( "Test 3" ); excelRow = sheet.createRow( 3 ); excelCell = excelRow.createCell( 3 ); excelCell.setCellValue( "Test 4" ); sheet.groupRow( 1, 3 ); sheet.groupRow( 2, 3 ); sheet.groupRow( 3, 3 ); sheet.setRowGroupCollapsed( 1, true ); sheet.setRowGroupCollapsed( 2, true ); sheet.setRowGroupCollapsed( 3, true ); --00163662e569f4e2390468bc88cd--