From user-return-22934-archive-asf-public=cust-asf.ponee.io@poi.apache.org Sun Feb 11 20:33:10 2018 Return-Path: X-Original-To: archive-asf-public@eu.ponee.io Delivered-To: archive-asf-public@eu.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by mx-eu-01.ponee.io (Postfix) with ESMTP id 69D2018064E for ; Sun, 11 Feb 2018 20:33:10 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 59C5E160C4E; Sun, 11 Feb 2018 19:33:10 +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 66D8C160C2E for ; Sun, 11 Feb 2018 20:33:09 +0100 (CET) Received: (qmail 66319 invoked by uid 500); 11 Feb 2018 19:33:08 -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 66302 invoked by uid 99); 11 Feb 2018 19:33:07 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 11 Feb 2018 19:33:07 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 1B80BC0048 for ; Sun, 11 Feb 2018 19:33:07 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.129 X-Spam-Level: ** X-Spam-Status: No, score=2.129 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_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id VZNP1qtQbCGM for ; Sun, 11 Feb 2018 19:33:03 +0000 (UTC) Received: from mail-it0-f48.google.com (mail-it0-f48.google.com [209.85.214.48]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 690F95F178 for ; Sun, 11 Feb 2018 19:33:03 +0000 (UTC) Received: by mail-it0-f48.google.com with SMTP id c80so4156616itb.4 for ; Sun, 11 Feb 2018 11:33:03 -0800 (PST) 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=s+tPOPx96Rm6J7Ml42vEg/1HqeLTE4uQiAIJe0r01jo=; b=XgFByLCd4VSLU33fIKY/osHLEG+YgGdAfOBKfi0fZyGBZTj82V1fRzuICVXuzx+uxw 3LDvLeiFAOlCXBB8mzuHmGECbHSLJbF9JEdHjms9vxP3AA6ioPakJbnFkwQkk3pIgftt p3e6ePcWXA0VQoDXldV8xpYObB8S1R7uANywDeL04ihY3rtZtQsBN4icI2GzC3wbtdqq TYnQIQmat7KckkCs+4xhtfM6Q9k3afugClQKeEwMrXnE47/uWasWkZMzDCQZnRXOeFgF aG0hj8ot+i8ihogjI5oKoCBRNk+GiQz2tKJlEYLNBbVaYKjOuqv5zmacWG1Tljb79Qk8 B7hQ== 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=s+tPOPx96Rm6J7Ml42vEg/1HqeLTE4uQiAIJe0r01jo=; b=CYdULDiAWNjHaQRIxVdeUAQXlMZuG28p+TNNk9nKRzDNVeTn8JpAhDH5Xlkqwq+T8S XJJqGqEa4AS/orhbLHKz5lKrFIDBDsabIylgKKlbnFqIVSObzYLjpk1HoLWO7vcufdRm RzSXQurU59zPcL/mtLpm2RK76ytEOYySUnvU9GqiZed1MJKe8mJQjb+8/dPticKdaFpG uxA9ttzjEgioN4v3tQSiGvNXm4VFwTOxs4bGr1pO8uRLwXJPZqsdf/FwsgSwmfRWgAYt M6DDGCnUMUHwCYXc8kFo6KMBnYqRDUYYgOq0nskVbzJdU2yFLN+Oi66Uf4kuvMEcNXeU fkSQ== X-Gm-Message-State: APf1xPCt3s87tHG8H2vzu7eybdy77podBPc7Urwg6ei77BUwK5xIdj/F +Wb6n/wToFyCArltFhJwuPiiF01tg7KL3IfhWzN9uQ== X-Google-Smtp-Source: AH8x224HkTX9JhBKAiX9BwTCbY3luWLPFUYJxHre/u9qeGC6w2H3EQtCUjl47x0U1Kq9OzPDhwcmRMmJfn4/SNwLEE4= X-Received: by 10.36.9.73 with SMTP id 70mr2575134itm.133.1518377577114; Sun, 11 Feb 2018 11:32:57 -0800 (PST) MIME-Version: 1.0 Received: by 10.107.198.65 with HTTP; Sun, 11 Feb 2018 11:32:56 -0800 (PST) From: Markus Christian Date: Sun, 11 Feb 2018 20:32:56 +0100 Message-ID: Subject: ArrayIndexOutOfBoundsException while UpdatingFile To: user@poi.apache.org Content-Type: multipart/alternative; boundary="001a11373de21e6ff20564f4d492" --001a11373de21e6ff20564f4d492 Content-Type: text/plain; charset="UTF-8" Hi, I'm getting the following exception when updating/writing in a xlsx-file with apache POI3.17: java.lang.ArrayIndexOutOfBoundsException: 1 at org.apache.poi.xssf.usermodel.XSSFTable.setCellReferences(XSSFTable.java:303) atorg.apache.poi.xssf.usermodel.XSSFTable.getStartCellReference(XSSFTable.java:275) at org.apache.poi.xssf.usermodel.XSSFTable.updateHeaders(XSSFTable.java:356) at org.apache.poi.xssf.usermodel.XSSFTable.writeTo(XSSFTable.java:102) at org.apache.poi.xssf.usermodel.XSSFTable.commit(XSSFTable.java:113) at org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:486) at org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:491) at org.apache.poi.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:491) at org.apache.poi.POIXMLDocument.write(POIXMLDocument.java:242) at gui.Reiter.dateiSpeichern(Reiter.java:660) at gui.Hauptfenster$4.actionPerformed(Hauptfenster.java:405) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259) at javax.swing.AbstractButton.doClick(AbstractButton.java:376) at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833) at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877) at java.awt.Component.processMouseEvent(Component.java:6533) at javax.swing.JComponent.processMouseEvent(JComponent.java:3324) at java.awt.Component.processEvent(Component.java:6298) at java.awt.Container.processEvent(Container.java:2236) at java.awt.Component.dispatchEventImpl(Component.java:4889) at java.awt.Container.dispatchEventImpl(Container.java:2294) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466) at java.awt.Container.dispatchEventImpl(Container.java:2280) at java.awt.Window.dispatchEventImpl(Window.java:2746) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90) at java.awt.EventQueue$4.run(EventQueue.java:731) at java.awt.EventQueue$4.run(EventQueue.java:729) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80) at java.awt.EventQueue.dispatchEvent(EventQueue.java:728) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) it will be cause in the red line of the following code: try (FileOutputStream outPutStream = new FileOutputStream(actualFile)){ fileAccess(); System.out.println("File: "+actualFile); System.out.println("Sheet: "+actualSheet.getSheetName()); //Daten abspeichern Header header=actualSheet.getHeader(); header.setLeft(jtaZeitraum.getText()); header.setCenter(jtaAnschrift.getText());; header.setRight(jtaVonBis.getText()); for(int i=0; i