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 25D96200BA8 for ; Mon, 24 Oct 2016 22:17:13 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 24794160AEB; Mon, 24 Oct 2016 20:17:13 +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 6C393160AD7 for ; Mon, 24 Oct 2016 22:17:12 +0200 (CEST) Received: (qmail 74056 invoked by uid 500); 24 Oct 2016 20:17:11 -0000 Mailing-List: contact dev-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Developers List" Delivered-To: mailing list dev@poi.apache.org Received: (qmail 74045 invoked by uid 99); 24 Oct 2016 20:17:11 -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; Mon, 24 Oct 2016 20:17:11 +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 279EAC20DB for ; Mon, 24 Oct 2016 20:17:11 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -1.999 X-Spam-Level: X-Spam-Status: No, score=-1.999 tagged_above=-999 required=6.31 tests=[KAM_LAZY_DOMAIN_SECURITY=1, RP_MATCHES_RCVD=-2.999] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id amC7UtIkiFhM for ; Mon, 24 Oct 2016 20:17:10 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id D8D1B5FC27 for ; Mon, 24 Oct 2016 20:17:09 +0000 (UTC) Received: from asf-bz1-us-mid.priv.apache.org (nat1-us-mid.apache.org [23.253.172.122]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTPS id 9187DE0054 for ; Mon, 24 Oct 2016 20:17:08 +0000 (UTC) Received: by asf-bz1-us-mid.priv.apache.org (ASF Mail Server at asf-bz1-us-mid.priv.apache.org, from userid 33) id D8D1D6090F; Mon, 24 Oct 2016 20:17:06 +0000 (UTC) From: bugzilla@apache.org To: dev@poi.apache.org Subject: [Bug 60302] New: Formulas not working correctly on LibreOffice with SXSSF Date: Mon, 24 Oct 2016 20:17:06 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: SXSSF X-Bugzilla-Version: 3.15-dev X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: nicolaspohren@gmail.com X-Bugzilla-Status: NEW X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: dev@poi.apache.org X-Bugzilla-Target-Milestone: --- X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform bug_status bug_severity priority component assigned_to reporter attachments.created Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit X-Bugzilla-URL: https://bz.apache.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 archived-at: Mon, 24 Oct 2016 20:17:13 -0000 https://bz.apache.org/bugzilla/show_bug.cgi?id=60302 Bug ID: 60302 Summary: Formulas not working correctly on LibreOffice with SXSSF Product: POI Version: 3.15-dev Hardware: PC Status: NEW Severity: normal Priority: P2 Component: SXSSF Assignee: dev@poi.apache.org Reporter: nicolaspohren@gmail.com Created attachment 34402 --> https://bz.apache.org/bugzilla/attachment.cgi?id=34402&action=edit Sample source code When creating a .xlsx file using SXSSF and including a formula (SUM for example), Microsoft Office can open the generated file perfectly. However, when trying to open it with LibreOffice, the generated formula contains 0 as the result, even though it should have a value. Sample source code in attachment Poi version: 3.15 LibreOffice version: 5.2.2.2 -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org For additional commands, e-mail: dev-help@poi.apache.org