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 should also be encoded for valid URI. Looks like the issue with white space in target URI was fixed in r1036215. When trying to convert such hyperlink to URI, a URISyntaxException is thrown. Please find the attachment of the excel file including the hyperlink with a non-breaking space. Below is the sample java code to demonstrate the issue. import java.io.FileInputStream; import java.io.IOException; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.usermodel.WorkbookFactory; public class DemonstrateHyperlinkIssue { public static Workbook getCell(String fileName) throws Exception{ FileInputStream input = null; Workbook excelDoc = null; try { input = new FileInputStream(fileName); excelDoc = WorkbookFactory.create(input); input.close(); } catch(IOException e) { throw e; } finally { if (input != null) { input.close(); } } return excelDoc; } public static void main(String [] args) { try { Workbook wb = getCell("C:\\pathToFile\\test.xlsx"); System.out.println(wb); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } </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.3.0.jar poi-ooxml-3.8-20120326.jar poi-excelant-3.8-20120326.jar stax-api-1.0.1.jar dom4j-1.6.1.jar poi-ooxml-schemas-3.8-20120326.jar Below is the source code InputStream iStream=null; FormBeanExcel ex= (FormBeanExcel)form; Workbook workbook = null; Sheet worksheet = null; try { iStream = ex.getTestFile().getInputStream(); workbook = WorkbookFactory.create(iStream); //It breaks at this point } catch (Exception e) { System.out.println("Eception"); e.printStackTrace(); } Please Suggest . </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 = new ByteArrayOutputStream(); ppt.write(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-XSSFWorkbook-tp5709878.html Sent from the POI - Dev mailing list archive at Nabble.com. </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 disable asserts, for example: SXSSFRow.class.getClassLoader().setClassAssertionStatus(SXSSFRow.class.getName(), false); </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.java:270) at org.apache.poi.hssf.record.RecordFactoryInputStream.nextRecord(RecordFactoryInputStream.java:236) at org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:377) at org.apache.poi.hssf.usermodel.HSSFWorkbook.&lt;init&gt;(HSSFWorkbook.java:275) at org.apache.poi.hssf.usermodel.HSSFWorkbook.&lt;init&gt;(HSSFWorkbook.java:200) at org.apache.poi.hssf.usermodel.HSSFWorkbook.&lt;init&gt;(HSSFWorkbook.java:316) at org.apache.poi.hssf.usermodel.HSSFWorkbook.&lt;init&gt;(HSSFWorkbook.java:297) at com.alstom.hpr.manager.excel.impl.type.XlsImport.importFile(XlsImport.java:40) at com.alstom.hpr.manager.excel.impl.BaseExcelManagement.importFile(BaseExcelManagement.java:89) at com.alstom.hpr.struts.imports.ImportFinUnitDataAction.importFile(ImportFinUnitDataAction.java:190) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:280) at org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:216) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at com.alstom.fwk.servlet.StrutsServlet.service(StrutsServlet.java:95) at com.alstom.hpr.servlet.HprStrutsServlet.service(HprStrutsServlet.java:98) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.alstom.fwk.servlet.filter.SimConnectionFilter.doFilter(SimConnectionFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.alstom.fwk.servlet.filter.LoggerFilter.doFilter(LoggerFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.alstom.fwk.servlet.filter.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:121) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Caused by: org.apache.poi.hssf.record.RecordFormatException: Not enough data (0) to read requested (6) bytes at org.apache.poi.hssf.record.RecordInputStream.checkRecordPosition(RecordInputStream.java:215) at org.apache.poi.hssf.record.RecordInputStream.readFully(RecordInputStream.java:278) at org.apache.poi.hssf.record.RecordInputStream.readFully(RecordInputStream.java:274) at org.apache.poi.hssf.record.chart.ChartEndBlockRecord.&lt;init&gt;(ChartEndBlockRecord.java:44) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at org.apache.poi.hssf.record.RecordFactory$ReflectionRecordCreator.create(RecordFactory.java:56) ... 46 more Code i have written is i am getting the inputstream from the FormFile of struts request HSSFWorkbook wb = new HSSFWorkbook(is); i'd appreciate developer's comments on whether this is indeed a bug and not some rudeness on the part of my own code,please </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 XSSFExcelExtractor(wb); String fullText = ext.getText(); I will attach problem occurred Excel File. Would you please quick answer about this problem.. I got critical issue about that. </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(); int tblNameIdx = 0; for (int i = 0; i &lt; range.numParagraphs(); i++) { Paragraph tablePar = range.getParagraph(i); String parText = tablePar.text(); try { Pattern pattern = Pattern.compile("[\\s]*", Pattern.CASE_INSENSITIVE); Matcher matcher = pattern.matcher(parText); if (matcher.matches()) { continue; } matcher.matches()); } catch (Exception e) { e.printStackTrace(); } Paragraph tableName = range.getParagraph(tblNameIdx); System.out.println("Table name=====&gt;&gt;" + tableName.text()); Table table = range.getTable(tablePar); for (int rowIdx = 0; rowIdx &lt; table.numRows(); rowIdx++) { TableRow row = table.getRow(rowIdx); BorderCode bc = row.getVerticalBorder(); i = i + 1; row.text(); String rowText = ""; for (int colIdx = 0; colIdx &lt; row.numCells(); colIdx++) { TableCell cell = row.getCell(colIdx); rowText = rowText + "\t" + cell.getParagraph(0).text(); i = i + 1; } System.out.println("Row----" + rowIdx + " ===&gt;&gt;" + rowText); } i = i - 1; } else { tblNameIdx = i; } } } catch (Exception e) { e.printStackTrace(); } } } </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 command parameter is no longer rendered at all, i.e. the cell is resized correctly but the image is not visible. The used POI version is the latest stable one (3.8-20120326). </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 an external workbook is not found. Is there a reason for this design decision? I would suggest: - a formula error (e.g. "#REF") - or a checked exception - or if all else fails, an unchecked exception but a subtype so we don't have to catch RuntimeException and a mention of this behavior in the javadocs because until it occurred I had no idea this behavior was expected </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.ss.formula.eval.NotImplementedException: EDATUM at org.apache.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:59) at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:491) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:287) ... 4 more (2) When I try to fix this and to register the function with Germen name "EDATUM", it won't work: I get the following error messages, because EDATUM is, of course, not a function that Excel or POI knows, since this must be the English name "EDATE": Exception in thread "main" java.lang.IllegalArgumentException: EDATUM is not a function from the Excel Analysis Toolpack. at org.apache.poi.ss.formula.atp.AnalysisToolPak.registerFunction(AnalysisToolPak.java:237) at org.apache.poi.ss.formula.WorkbookEvaluator.registerFunction(WorkbookEvaluator.java:712) at com.xls.UserDefinedFunctionExample.main(UserDefinedFunctionExample.java:44) (3) When I register this function via the UDFFinder with German name "EDATUM", it will work: FileInputStream fis = new FileInputStream(workbookFile); Workbook workbook = WorkbookFactory.create(fis); fis.close(); String[] functionNames = { "EDATUM" } ; FreeRefFunction[] functionImpls = { new EDate() } ; UDFFinder udfToolpack = new DefaultUDFFinder( functionNames, functionImpls ) ; //register the user-defined function in the workbook workbook.addToolPack(udfToolpack); POI knows the registered function and is able to evaluate the formula in the Excel sheet. But this is not what I want, because this will register EDATUM a user-defined function. What I want is to give POI the code for the not supported function EDATE (or EDATUM), and I think I have to use WorkbookEvaluator.registerFunction() in this case. (4) Again, when I try to register this function via the UDFFinder with English name "EDATE": I get 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.ss.formula.eval.NotImplementedException: EDATUM at org.apache.poi.ss.formula.UserDefinedFunction.evaluate(UserDefinedFunction.java:59) at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:129) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:491) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:287) ... 4 more This seems to be due to the German EDATUM, which is written in the Excel file, of course. How else could POI know about EDATUM, since everywhere in my code I used EDATE in this case? So EDATUM must come from the Excel file?? ==&gt; Does Excel not work internally with the English function names? How can I solve this problem and register EDATE as EDATE (English name)?? Thanks for any help.... Christian </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