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 620A7200B33 for ; Wed, 29 Jun 2016 14:53:16 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 6098A160A57; Wed, 29 Jun 2016 12:53:16 +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 84335160A4D for ; Wed, 29 Jun 2016 14:53:15 +0200 (CEST) Received: (qmail 29363 invoked by uid 500); 29 Jun 2016 12:53:09 -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 29306 invoked by uid 99); 29 Jun 2016 12:53:06 -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; Wed, 29 Jun 2016 12:53:06 +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 DC097C02E7 for ; Wed, 29 Jun 2016 12:53:05 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -1.726 X-Spam-Level: X-Spam-Status: No, score=-1.726 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_MED=-2.3, RP_MATCHES_RCVD=-1.426] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=mitre.onmicrosoft.com 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 WfvnfdFb3aBX for ; Wed, 29 Jun 2016 12:53:04 +0000 (UTC) Received: from smtpvmsrv1.mitre.org (smtpvmsrv1.mitre.org [192.52.194.136]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id DDFD35F4EE for ; Wed, 29 Jun 2016 12:53:03 +0000 (UTC) Received: from smtpvmsrv1.mitre.org (localhost.localdomain [127.0.0.1]) by localhost (Postfix) with SMTP id E31DD6C0A4A for ; Wed, 29 Jun 2016 08:52:56 -0400 (EDT) Received: from imshyb01.MITRE.ORG (imshyb01.mitre.org [129.83.29.2]) by smtpvmsrv1.mitre.org (Postfix) with ESMTP id D12766C04A1 for ; Wed, 29 Jun 2016 08:52:56 -0400 (EDT) Received: from imshyb02.MITRE.ORG (129.83.29.3) by imshyb01.MITRE.ORG (129.83.29.2) with Microsoft SMTP Server (TLS) id 15.0.1130.7; Wed, 29 Jun 2016 08:52:56 -0400 Received: from gcc01-dm2-obe.outbound.protection.outlook.com (10.140.19.249) by imshyb02.MITRE.ORG (129.83.29.3) with Microsoft SMTP Server (TLS) id 15.0.1130.7 via Frontend Transport; Wed, 29 Jun 2016 08:52:56 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mitre.onmicrosoft.com; s=selector1-mitre-org; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=tP3QoR01Ukr1/iNb1geV3gA+vGy0O/r7gmWDDZsboMI=; b=GXirODQNLXFVYDTVpGWbZfnpzXALCK1kIsOWzyIdVE5ZRBRIhmyYOvLjCc28r1lBlPT4qpVnEG5pC31ozZIsNvgLCT0q5Z6ep9GNZLLkXMDFMiw1ZuOhyJ+ReCbBprE5lAPgUSRDv+l1mj6ZGzm6lf6ueHXaQKgxra88sN9mb40= Received: from CY1PR09MB1115.namprd09.prod.outlook.com (10.166.196.19) by CY1PR09MB1113.namprd09.prod.outlook.com (10.166.196.17) with Microsoft SMTP Server (TLS) id 15.1.523.12; Wed, 29 Jun 2016 12:52:50 +0000 Received: from CY1PR09MB1115.namprd09.prod.outlook.com ([10.166.196.19]) by CY1PR09MB1115.namprd09.prod.outlook.com ([10.166.196.19]) with mapi id 15.01.0523.024; Wed, 29 Jun 2016 12:52:50 +0000 From: "Allison, Timothy B." To: POI Users List Subject: xlsx somewhat recently switched to Scientific notation for long sequences of digits? Thread-Topic: xlsx somewhat recently switched to Scientific notation for long sequences of digits? Thread-Index: AdHSBSPq03gYvDoxSW2hpgIE5M33eQ== Date: Wed, 29 Jun 2016 12:52:50 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=tallison@mitre.org; x-originating-ip: [192.80.55.86] x-ms-office365-filtering-correlation-id: 9e68a2a6-6db5-4d1a-b71b-08d3a01c472f x-microsoft-exchange-diagnostics: 1;CY1PR09MB1113;6:l8pPW4OFWxsHZYoSwGxtf7jV7YwtHnJFP8IwMXFdIQ+B5tyOk8+5szARYRlzc0qemO6LX8wfllTKHiYuRZMCfQnP5O2BA1ZzGjV3zTMmQAFQb5Ex1f1dWgPPoJgxF4OBrCmSek0d2l2CXtTgu3YDAEEL5mYJWtWbMvrIKcwfaK7LfsM4JWB/iZ/peENp9ERalUIeoIh9DJ4DkOirs75KNH4bagJXMNxlM5GeNTiuc0VpphhbSwFmV4AZ/kfidhYJgHEHK01y06rkJBjqMRkoz91E/FMMIxBTumJ5ryMsBMEexjAejknXSuIvsoUjicIEvvKT7ZF6319YEhiroD0bi5BD9m85UA5+magZguSv5M0=;5:954JRyzNPouCACAMbOdq6gHG3kkcqJGXn65QwavLGlTmgU7Y71cMyp5tlJlt5QU/V2WjK5hZKlDaNU8Peiz13wlqONrTDb9PBogkORn0wC9CmgCd/Z/br839VthyAY14t0E7iXizIiIj0KqSGjGNOg==;24:+BXhf67j4qqznVi8NzrMaENmJJ7xMjyFRz+8B461e1RBrENa4nnWmfrYY4aTKbXSA8ZK4P1ztTlpXnVmWikfzDU9TWKvh1BxiYxOpm8N0Qo=;7:894Z48/0soKpdMyrDk/PdIwccRlWrDh7+81J0eIcDdc8ZFTGj4WQc7CjCNKpNUR5TXQLZmwlA8iLz0h91h2nLrtuFDHI8W1KYSFU46Ve82LPC+cVH0f3Ir7w14P6wXym0uo9AuJeqBOsY1FtK7tFtYYdLBMbC/q9dmIUl2mwP1vpJjdyBqi6PoFXTPQO1PvwUuWWd47xKjvnx1jf55ePqA/BbDbVr9mQ8vJ1Frr0/+pp95E9arQljcYKcomSWnSJQS5DSKydLOh7xorpJRbIig== x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:CY1PR09MB1113; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(134217032509453)(21748063052155); x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(601004)(2401047)(8121501046)(5005006)(10201501046)(3002001)(6055026);SRVR:CY1PR09MB1113;BCL:0;PCL:0;RULEID:;SRVR:CY1PR09MB1113; x-forefront-prvs: 09888BC01D x-forefront-antispam-report: SFV:NSPM;SFS:(10009020)(7916002)(199003)(189002)(11100500001)(7696003)(5002640100001)(450100001)(19580395003)(77096005)(2900100001)(122556002)(5003600100003)(15975445007)(8936002)(7846002)(7736002)(9686002)(10400500002)(7906003)(8676002)(81166006)(19617315012)(81156014)(99286002)(229853001)(106356001)(105586002)(107886002)(6116002)(86362001)(189998001)(66066001)(33656002)(110136002)(76576001)(102836003)(3660700001)(16236675004)(586003)(87936001)(19625215002)(50986999)(68736007)(101416001)(92566002)(54356999)(97736004)(790700001)(19300405004)(3280700002)(74316001)(2906002)(3846002);DIR:OUT;SFP:1101;SCL:1;SRVR:CY1PR09MB1113;H:CY1PR09MB1115.namprd09.prod.outlook.com;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; received-spf: None (protection.outlook.com: mitre.org does not designate permitted sender hosts) spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_CY1PR09MB11153C296104F3C566263B35C7230CY1PR09MB1115namp_" MIME-Version: 1.0 X-MS-Exchange-CrossTenant-originalarrivaltime: 29 Jun 2016 12:52:50.1978 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: c620dc48-1d50-4952-8b39-df4d54d74d82 X-MS-Exchange-Transport-CrossTenantHeadersStamped: CY1PR09MB1113 X-OriginatorOrg: mitre.org archived-at: Wed, 29 Jun 2016 12:53:16 -0000 --_000_CY1PR09MB11153C296104F3C566263B35C7230CY1PR09MB1115namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable All, On https://issues.apache.org/jira/browse/TIKA-2025, a Tika user noted tha= t, at least for xlsx, what used to be rendered as a long sequence of digits= (e.g. 340229177292566) is now being extracted as scientific notation (3.40= 229E+14). This new behavior mimics Excel more closely, but is there an eas= y/obvious way for us at the Tika level to revert back to extracting the ful= l sequence of digits or do I have to look into this at the POI level? Thank you. Best, Tim --_000_CY1PR09MB11153C296104F3C566263B35C7230CY1PR09MB1115namp_--