| Summary: | autoSizeColumn columns is throwing null pointer exception | ||
|---|---|---|---|
| Product: | POI | Reporter: | jp <jp> |
| Component: | HSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED WORKSFORME | ||
| Severity: | normal | ||
| Priority: | P2 | ||
| Version: | 3.17-FINAL | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Linux | ||
Could you provide more details? A sample document, code to reproduce etc.? This error is coming from a core bit of the JVM, so I don't think there's much Apache POI can do here... My best guess is either you have a broken/buggy JVM, and need to upgrade it, or you have a broken set of True Type Fonts installed on your machine. Make sure you have the latest version of the JVM installed, and if the problem remains, follow instructions for your chosen Linux distro to install / re-install the fonts + make the JVM able to see them. I couldn't reproduce it in my machine (opensuse leap 42.2) with my Oracle JDK 1.8 update 181. This excepcetion it's occurring in docker, running on container: openjdk:8-jdk-alpine. (In reply to Nick Burch from comment #2) > This error is coming from a core bit of the JVM, so I don't think there's > much Apache POI can do here... > > My best guess is either you have a broken/buggy JVM, and need to upgrade it, > or you have a broken set of True Type Fonts installed on your machine. > > Make sure you have the latest version of the JVM installed, and if the > problem remains, follow instructions for your chosen Linux distro to install > / re-install the fonts + make the JVM able to see them. ohhh I see. I couldn't reproduce it in my OS (OpenSuSE leap 4.2) with Oracle JDK 1.8 u181. this is occurring only in docker, container: openjdk:8-jdk-alpine I hope you can catch it now. I guess will be checking null pointer in FontConfiguration.java:1264 , right ? Looks like https://github.com/docker-library/openjdk/issues/73 - There is a suggested workaround: apt-get -y --no-install-recommends install libfontconfig1 https://github.com/docker-library/openjdk/pull/48 I don't think we can fix anything in Apache POI, a workaround has been proposed, thus resolving this here. |
doing: sheet.autoSizeColumn(i); java.lang.NullPointerException at sun.awt.FontConfiguration.getVersion(FontConfiguration.java:1264) at sun.awt.FontConfiguration.readFontConfigFile(FontConfiguration.java:219) at sun.awt.FontConfiguration.init(FontConfiguration.java:107) at sun.awt.X11FontManager.createFontConfiguration(X11FontManager.java:774) at sun.font.SunFontManager$2.run(SunFontManager.java:431) at java.security.AccessController.doPrivileged(Native Method) at sun.font.SunFontManager.<init>(SunFontManager.java:376) at sun.awt.FcFontManager.<init>(FcFontManager.java:35) at sun.awt.X11FontManager.<init>(X11FontManager.java:57) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at java.lang.Class.newInstance(Class.java:442) at sun.font.FontManagerFactory$1.run(FontManagerFactory.java:83) at java.security.AccessController.doPrivileged(Native Method) at sun.font.FontManagerFactory.getInstance(FontManagerFactory.java:74) at java.awt.Font.getFont2D(Font.java:491) at java.awt.Font.canDisplayUpTo(Font.java:2060) at java.awt.font.TextLayout.singleFont(TextLayout.java:470) at java.awt.font.TextLayout.<init>(TextLayout.java:531) at org.apache.poi.ss.util.SheetUtil.getDefaultCharWidth(SheetUtil.java:275) at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:250) at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:235) at org.apache.poi.xssf.usermodel.XSSFSheet.autoSizeColumn(XSSFSheet.java:549) at org.apache.poi.xssf.usermodel.XSSFSheet.autoSizeColumn(XSSFSheet.java:531)