http://blog.gmane.org/gmane.comp.jakarta.poi.devel hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22688 <pre>Hello! I use Apache POI to write a converter .doc to .html. I have a problem with WordToHtmlConverter - its doesn't handles TextBoxes. So, in my class, I use the method HWPFDocument.getOfficeDrawingsMain() and get Collection&lt;OfficeDrawing&gt; using getOfficeDrawings(). After that, what should I do, to get the text and images that are stored in this TextBox? </pre> Dmitry Zamula 2012-05-24T14:15:51 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22682 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53282 Priority: P2 Bug ID: 53282 Assignee: dev&lt; at &gt;poi.apache.org Summary: Hyperlink with a non-breaking space throws java.lang.IllegalStateException: The hyperlink for cell A2 references relation rId2, but that didn't exist! Severity: normal Classification: Unclassified Reporter: lakshmi.nchandana&lt; at &gt;gmail.com Hardware: PC Status: NEW Version: 3.8-dev Component: XSSF Product: POI I sent this query to the POI mailing list couple of days back and was advised to open a bug here. I tested hyperlinks with Apache POI (3.8 version) and it throws java.lang.IllegalStateException: The hyperlink for cell A2 references relation rId2, but that didn't exist! for hyperlinks with non-breaking spaces. The non-breaking space in an hyperlink relation is not a valid java URI. These invalid characters sho</pre> bugzilla< at >apache.org 2012-05-23T21:13:23 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22678 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53280 Priority: P2 Bug ID: 53280 Assignee: dev&lt; at &gt;poi.apache.org Summary: While reading xlsx file in WAS 6.1 it throws org.apache.poi.POIXMLException:java.lang.reflect.Invoc ationTargetException Severity: critical Classification: Unclassified OS: Windows XP Reporter: ankur8819&lt; at &gt;gmail.com Hardware: PC Status: NEW Version: 3.8 Component: XSSF Product: POI Created attachment 28823 --&gt; https://issues.apache.org/bugzilla/attachment.cgi?id=28823&amp;action=edit Stack Trace for the Exception Hi, While reading a xlsx file using POI3.8 .I am getting an Exception. org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException The same code woks fine with Tomcat Server but fails with WAS6.1.I am suspecting some library conflict. Below is my class path. poi-3.8-20120326.jar xmlbeans-2.</pre> bugzilla< at >apache.org 2012-05-23T14:09:08 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22677 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53278 Priority: P2 Bug ID: 53278 Assignee: dev&lt; at &gt;poi.apache.org Summary: HSLF SlideShow write() leeds to java.lang.ArrayIndexOutOfBoundsException Severity: blocker Classification: Unclassified OS: All Reporter: mendle&lt; at &gt;gmx.de Hardware: All Status: NEW Version: 3.8 Component: HSLF Product: POI From Version 3.8 up to the current 3.9-beta1 the write() function of SlideShow results in an ArrayIndexOutOfBoundsException. The SlideShow is created from an array of bytes containing a valid excel file, and then even without modification if the write() function is called (for streaming to the client) the exception occurs. With final version 3.7 everything is fine. What is done: SlideShow ppt = new SlideShow( new ByteArrayInputStream(byte[] data) // data containing valid ppt file ); ByteArrayOutputStream out </pre> bugzilla< at >apache.org 2012-05-23T09:55:22 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22676 <pre>Hi~ when I instantiate XSSFWorkbook or XSSFExcelExtractor for getText(). New instantiate about them is blocked with linked XSLX file. -----&gt; http://bit.ly/JU6Ujl (no error, no exception, just blocked..) I write code like below # # case 1 # OPCPackage pkg = OPCPackage.open(fileName); // blocked below code, no exception.. no response.. XSSFExcelExtractor ext = new XSSFExcelExtractor(pkg); String fullText = ext.getText(); # # case 2 # OPCPackage pkg = OPCPackage.open(fileName); // blocked below code, no exception.. no response.. XSSFWorkbook wb = new XSSFWorkbook(pkg); XSSFExcelExtractor ext = new XSSFExcelExtractor(wb); String fullText = ext.getText(); I will attach problem occurred Excel File. (1.xlsx) Would you please quick answer about this problem.. I got critical issue about that. I use poi-3.8 / windows 7 64bit / 32bit jdk 6 and 7 Thanks. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/POI-XLSX-Blocked-when-instantiate-of-XSSFExcelExtractor-or-XSSFWor</pre> toplinuxer 2012-05-23T04:18:39 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22672 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53275 Priority: P2 Bug ID: 53275 Assignee: dev&lt; at &gt;poi.apache.org Summary: XSSFColor.setColor requires to clear previously set 'indexed' flag if color is non-indexed (theme) color Severity: normal Classification: Unclassified Reporter: andrei.astrouski&lt; at &gt;gmail.com Hardware: PC Status: NEW Version: 3.8 Component: XSSF Product: POI Patch: public void setColor(XSSFColor color) { if(color == null) _ctFont.setColorArray(null); else { CTColor ctColor = _ctFont.sizeOfColorArray() == 0 ? _ctFont.addNewColor() : _ctFont.getColorArray(0); if (ctColor.isSetIndexed()) { ctColor.unsetIndexed(); } ctColor.setRgb(color.getRgb()); } } </pre> bugzilla< at >apache.org 2012-05-22T16:43:03 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22671 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53274 Priority: P2 Bug ID: 53274 Assignee: dev&lt; at &gt;poi.apache.org Summary: XSSFColor.getRgbWithTint() return white color for black and vice versa Severity: normal Classification: Unclassified Reporter: andrei.astrouski&lt; at &gt;gmail.com Hardware: PC Status: NEW Version: 3.8 Component: XSSF Product: POI ctColor.getRgb() returns the white instead of black and the black instead of white. In getRgb() this issue is fixed. Patch: public byte[] getRgbWithTint() { byte[] rgb = getRgb(); double tint = ctColor.getTint(); if (rgb != null &amp;&amp; tint != 0) { for (int i = 0; i &lt; rgb.length; i++){ rgb[i] = applyTint(rgb[i] &amp; 0xFF, tint); } } return rgb; } </pre> bugzilla< at >apache.org 2012-05-22T16:38:18 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22670 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53273 Priority: P2 Bug ID: 53273 Assignee: dev&lt; at &gt;poi.apache.org Summary: CellStyle interface doesn't contain methods that return border Color object (like CellStyle.getFillBackgroundColorColor) Severity: normal Classification: Unclassified Reporter: andrei.astrouski&lt; at &gt;gmail.com Hardware: PC Status: NEW Version: 3.8 Component: POI Overall Product: POI So working with the model, we can't get the color of border </pre> bugzilla< at >apache.org 2012-05-22T16:32:38 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22669 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53272 Priority: P2 Bug ID: 53272 Assignee: dev&lt; at &gt;poi.apache.org Summary: Font interface doesn't contain method that returns Color object (like CellStyle.getFillBackgroundColorColor) Severity: normal Classification: Unclassified Reporter: andrei.astrouski&lt; at &gt;gmail.com Hardware: PC Status: NEW Version: 3.8 Component: POI Overall Product: POI So working with the model, we can't get the color </pre> bugzilla< at >apache.org 2012-05-22T16:30:38 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22668 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53271 Priority: P2 Bug ID: 53271 Assignee: dev&lt; at &gt;poi.apache.org Summary: Remove unconditional assert in SXSSFRow.getCell(int, MissingCellPolicy) Severity: normal Classification: Unclassified Reporter: adam&lt; at &gt;labkey.com Hardware: PC Status: NEW Version: 3.8 Component: SXSSF Product: POI The first line of this method is: assert false; ...which makes it unusable when asserts are enabled. Per Yegor Kozlov, "This particular assert means that SXSSFRow.getCell(int, MissingCellPolicy) is not yet covered by unit tests and *may* not be compatible with XSSF. This line will be removed in the future. Can you create a request in POI Bugzilla so that we don't forget about it?" FWIW, I've switched to SXSSF in our application (LabKey Server) and disabled asserts, and our use of this method seems to work fine. Workaround is to disa</pre> bugzilla< at >apache.org 2012-05-22T16:18:28 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22660 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53269 Priority: P2 Bug ID: 53269 Assignee: dev&lt; at &gt;poi.apache.org Summary: multiple save currupt file Severity: normal Classification: Unclassified Reporter: apache_nospam&lt; at &gt;achner.com Hardware: PC Status: NEW Version: 3.8 Component: XSSF Product: POI Created attachment 28813 --&gt; https://issues.apache.org/bugzilla/attachment.cgi?id=28813&amp;action=edit corrupt file Reproducible error XSSFWorkbook wb = new XSSFWorkbook(); wb.createSheet("Test"); FileOutputStream os = new FileOutputStream("C:/dev/myfile1.xlsx"); wb.write(os); os.close(); os = new FileOutputStream("C:/dev/myfile2.xlsx"); wb.write(os); os.close(); Saving an existing workbook first time produces a correct file (3.236 Bytes). Saving it a second time produces a corrupt file (2.888 Bytes). </pre> bugzilla< at >apache.org 2012-05-22T07:42:59 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22657 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53264 Priority: P2 Bug ID: 53264 Assignee: dev&lt; at &gt;poi.apache.org Summary: unable to create record instance..Not enough data (0) to read requested (6) bytes Severity: major Classification: Unclassified OS: Windows XP Reporter: csekhar406&lt; at &gt;gmail.com Hardware: PC Status: NEW Version: 3.8 Component: HSSF Product: POI I am using Poi latest final 3.8 version to fix this issue.but still i am getting the fallowing exception. org.apache.poi.hssf.record.RecordFormatException: Unable to construct record instance at org.apache.poi.hssf.record.RecordFactory$ReflectionRecordCreator.create(RecordFactory.java:64) at org.apache.poi.hssf.record.RecordFactory.createSingleRecord(RecordFactory.java:263) at org.apache.poi.hssf.record.RecordFactoryInputStream.readNextRecord(RecordFactoryInputStream.jav</pre> bugzilla< at >apache.org 2012-05-18T19:04:37 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22652 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53262 Priority: P2 Bug ID: 53262 Assignee: dev&lt; at &gt;poi.apache.org Summary: XSSFCellStyle.getFillForegroundXSSFColor returs null if theme color is set as Accent color in the Styles panel Severity: normal Classification: Unclassified Reporter: andrei.astrouski&lt; at &gt;gmail.com Hardware: PC Status: NEW Version: 3.8 Component: XSSF Product: POI If bg color is set in the Style panel, xml node (in styles.xml) &lt;cellXfs&gt; -&gt; &lt;xf&gt; doesn't have 'applyFill' attribute, and getFillForegroundXSSFColor method checks this parameter. As a result method returns null. </pre> bugzilla< at >apache.org 2012-05-18T13:50:10 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22648 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53255 Priority: P2 Bug ID: 53255 Assignee: dev&lt; at &gt;poi.apache.org Summary: Row Grouping Code Which Works in XSSF Produces Invalid Excel in SXSSF Severity: critical Classification: Unclassified Reporter: gjungman&lt; at &gt;utilinc.com Hardware: PC Status: NEW Version: 3.8-dev Component: SXSSF Product: POI Hello, I have code that groups and collapses rows as shown below: sheet.groupRow(startGroup, endGroup); sheet.setRowGroupCollapsed(startGroup, true); It works fine in XSSF, but if I change to SXSSF it produces an Excel workbook that Excel claims is corrupt. Very large workbooks is when both of these feature are most useful. Thanks! </pre> bugzilla< at >apache.org 2012-05-17T20:20:40 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22641 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53250 Priority: P2 Bug ID: 53250 Assignee: dev&lt; at &gt;poi.apache.org Summary: Blocked when instantiate of XSSFExcelExtractor or XSSFWorkbook Severity: critical Classification: Unclassified Reporter: toplinuxer&lt; at &gt;gmail.com Hardware: PC Status: NEW Version: 3.8 Component: XSSF Product: POI Hi~ when I instantiate XSSFWorkbook or XSSFExcelExtractor for getText(). New instantiate about them is blocked with attached XSLX file. I write code like below # # case 1 # OPCPackage pkg = OPCPackage.open(fileName); // blocked below code, no exception.. no response.. XSSFExcelExtractor ext = new XSSFExcelExtractor(pkg); String fullText = ext.getText(); # # case 2 # OPCPackage pkg = OPCPackage.open(fileName); // blocked below code, no exception.. no response.. XSSFWorkbook wb = new XSSFWorkbook(pkg); XSSFExcelExtractor ext = new XSSFExc</pre> bugzilla< at >apache.org 2012-05-16T23:50:38 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22640 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53243 Priority: P2 Bug ID: 53243 Assignee: dev&lt; at &gt;poi.apache.org Summary: Extract Tables from word document Severity: normal Classification: Unclassified OS: Windows XP Reporter: ayah683&lt; at &gt;gmail.com Hardware: PC Status: NEW Version: unspecified Component: HWPF Product: POI Created attachment 28793 --&gt; https://issues.apache.org/bugzilla/attachment.cgi?id=28793&amp;action=edit word document file i used POI 3.8 to extract tables from word document but i can't get all tables in Doc i write this code to get this action public static void main(String[] args) { String fileName = "C:\\fjn3312r.doc"; try { InputStream fis = new FileInputStream(fileName); POIFSFileSystem fs = new POIFSFileSystem(fis); HWPFDocument doc = new HWPFDocument(fs); Range range = doc.getRange()</pre> bugzilla< at >apache.org 2012-05-16T15:43:34 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22635 <pre>I need to convert PowerPoint 2003/2007(ppt/pptx) to HTML. But I have not found any code how to do this. So, how to Convert MS PowerPoint 2003/2007(ppt/pptx) into HTML using APACHE POI or Else? I have found Apache POI. But don't know what code can do the trick -- View this message in context: http://apache-poi.1045710.n5.nabble.com/How-to-Convert-MS-PowerPoint-2003-2007-into-HTML-using-APACHE-POI-or-Else-tp5709774.html Sent from the POI - Dev mailing list archive at Nabble.com. </pre> abc 2012-05-16T03:47:11 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22623 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53227 Priority: P2 Bug ID: 53227 Assignee: dev&lt; at &gt;poi.apache.org Summary: Scaled image not visible in SXSSFWorkbook Severity: major Classification: Unclassified Reporter: edwin.roth&lt; at &gt;unycom.com Hardware: PC Status: NEW Version: 3.8 Component: SXSSF Product: POI Created attachment 28774 --&gt; https://issues.apache.org/bugzilla/attachment.cgi?id=28774&amp;action=edit not working XSL After replacing org.apache.poi.hssf.usermodel.HSSFWorkbook by its streaming equivalent org.apache.poi.xssf.streaming.SXSSFWorkbook in the AddDimensionedImage.java sample: package org.apache.poi.ss.examples; public class AddDimensionedImage { public static void main(String[] args) { Workbook workbook = null; //... //workbook = new HSSFWorkbook(); workbook=new SXSSFWorkbook(100); //... } } the image supplied as c</pre> bugzilla< at >apache.org 2012-05-14T08:10:33 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22617 <pre>When evaluating a formula in a cell, I got a runtime exception with the following (partial) stacktrace: at org.apache.poi.ss.formula.OperationEvaluationContext.createExternSheetRefEvaluator(OperationEvaluationContext.java:89) at org.apache.poi.ss.formula.OperationEvaluationContext.getRef3DEval(OperationEvaluationContext.java:249) at org.apache.poi.ss.formula.WorkbookEvaluator.getEvalForPtg(WorkbookEvaluator.java:607) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:493) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:287) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:229) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:354) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluate(HSSFFormulaEvaluator.java:185) It seems the class org.apache.poi.ss.formula.OperationEvaluationContext throws a runtime exception if </pre> Alex Vb 2012-05-11T09:36:48 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22607 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53209 Priority: P2 Bug ID: 53209 Assignee: dev&lt; at &gt;poi.apache.org Summary: Too many styles corrupts the excel Severity: normal Classification: Unclassified Reporter: awm&lt; at &gt;mbcli.com Hardware: PC Status: NEW Version: 3.8 Component: XSSF Product: POI Having a 3250 rows x 10 cells for each row seem to be the limit the number of styles. 3500 x 10 breaks the excel file. Attached is a set of files/code to replicate the issue. </pre> bugzilla< at >apache.org 2012-05-09T19:32:09 http://comments.gmane.org/gmane.comp.jakarta.poi.devel/22604 <pre>Hi all, I receive problems when registering a not supported Excel function, in this case EDATE (or, in German, EDATUM). (1) When I register this function with the name "EDATE", it won't work: WorkbookEvaluator.registerFunction("EDATE", new EDate()); I receive the following error messages: Exception in thread "main" org.apache.poi.ss.formula.eval.NotImplementedException: Error evaluating cell Tabelle1!B2 at org.apache.poi.ss.formula.WorkbookEvaluator.addExceptionInfo(WorkbookEvaluator.java:356) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:297) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:229) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:354) at org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluate(HSSFFormulaEvaluator.java:185) at com.xls.UserDefinedFunctionExample.main(UserDefinedFunctionExample.java:55) Caused by: org.apache.poi</pre> Christian 2012-05-09T16:47:41 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.jakarta.poi.devel