Return-Path: X-Original-To: apmail-poi-dev-archive@www.apache.org Delivered-To: apmail-poi-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 881E11121C for ; Thu, 12 Jun 2014 09:28:11 +0000 (UTC) Received: (qmail 92033 invoked by uid 500); 12 Jun 2014 09:28:11 -0000 Delivered-To: apmail-poi-dev-archive@poi.apache.org Received: (qmail 91992 invoked by uid 500); 12 Jun 2014 09:28: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 91982 invoked by uid 99); 12 Jun 2014 09:28:11 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jun 2014 09:28:11 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.115] (HELO eir.zones.apache.org) (140.211.11.115) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jun 2014 09:28:11 +0000 Received: by eir.zones.apache.org (Postfix, from userid 80) id 8055F1B5B; Thu, 12 Jun 2014 09:27:47 +0000 (UTC) From: bugzilla@apache.org To: dev@poi.apache.org Subject: [Bug 56377] Autosize columns with custom date format (yyyy-MM-dd HH:mm:ss GMT) gets wrong width Date: Thu, 12 Jun 2014 09:27:47 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: POI X-Bugzilla-Component: XSSF X-Bugzilla-Version: 3.10 X-Bugzilla-Keywords: X-Bugzilla-Severity: normal X-Bugzilla-Who: apache@gagravarr.org X-Bugzilla-Status: NEEDINFO X-Bugzilla-Priority: P2 X-Bugzilla-Assigned-To: dev@poi.apache.org X-Bugzilla-Target-Milestone: --- X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: bug_status Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit X-Bugzilla-URL: https://issues.apache.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org https://issues.apache.org/bugzilla/show_bug.cgi?id=56377 Nick Burch changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO --- Comment #4 from Nick Burch --- I notice that your problematic cell is using the Calibri font Have you made sure that you have the Calibri font installed on your machine, *AND* available to Java? POI uses the Java font code to work out how big each letter needs to be, when calculating the sizing, and that requires the right fonts to be present to get a precise value. Without the right font, Java picks a "nearby" one which doesn't always size out the same. See the bottom of the warning at http://poi.apache.org/spreadsheet/quick-guide.html#Autofit -- 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