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://permalink.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://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22687 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53282 Yegor Kozlov &lt;yegor&lt; at &gt;dinom.ru&gt; changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO --- Comment #4 from Yegor Kozlov &lt;yegor&lt; at &gt;dinom.ru&gt; --- I can't reproduce it. Please try again to attach a sample file with a nbsp . Yegor (In reply to comment #3) </pre> bugzilla< at >apache.org 2012-05-24T08:28:06 http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22686 <pre>Thanks for reply. Would you plz suggest me about how to JVM diagnostic for this poi problem. I can't judge diagnostic technique for this problem :) -- View this message in context: http://apache-poi.1045710.n5.nabble.com/POI-XLSX-Blocked-when-instantiate-of-XSSFExcelExtractor-or-XSSFWorkbook-tp5709878p5709913.html Sent from the POI - Dev mailing list archive at Nabble.com. </pre> toplinuxer 2012-05-24T04:26:29 http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22685 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53282 lakshmi &lt;lakshmi.nchandana&lt; at &gt;gmail.com&gt; changed: What |Removed |Added ---------------------------------------------------------------------------- OS| |All --- Comment #3 from lakshmi &lt;lakshmi.nchandana&lt; at &gt;gmail.com&gt; --- Unable to attach the excel file. To reproduce the error, copy/paste the below in an excel file nobody&lt; at &gt;nowhere.uk  nobody&lt; at &gt;nowhere.com </pre> bugzilla< at >apache.org 2012-05-23T21:29:59 http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22684 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53282 --- Comment #2 from lakshmi &lt;lakshmi.nchandana&lt; at &gt;gmail.com&gt; --- Comment on attachment 28827 --&gt; https://issues.apache.org/bugzilla/attachment.cgi?id=28827 Excel file containing the hyperlink with a non-breaking space please ignore this attachment. </pre> bugzilla< at >apache.org 2012-05-23T21:27:39 http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22683 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53282 --- Comment #1 from lakshmi &lt;lakshmi.nchandana&lt; at &gt;gmail.com&gt; --- Created attachment 28827 --&gt; https://issues.apache.org/bugzilla/attachment.cgi?id=28827&amp;action=edit Excel file containing the hyperlink with a non-breaking space </pre> bugzilla< at >apache.org 2012-05-23T21:24:02 http://permalink.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://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22681 <pre> Your file opens just fine for me, no blocking or exceptions, the code above just works There must be some sort of issue with either your system or your jvm. I'd suggest you try some of the usual JVM diagnostic issues to try to work out what's going wrong on your machine Nick </pre> Nick Burch 2012-05-23T17:42:29 http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22680 <pre>Thanks Nick, it is indeed as you have suggested. When I register a "built-in" function such as IPMT that is not yet supported by POI, then POI will recognize my implementation of this function. (The "built-in" functions must implement the Function interface in POI.) To register the function, I used the WorkbookEvaluator.registerFunction("IPMT", new IPTM()) method, in this case. On the other hand, when I implement a not supported function that is not "built-in", and belongs to the ATP (Analysis Tool Pack) of Excel, and I use a German version of Excel (or Open Office Calc), then POI will do the following: (a) if I register my function under the English name of the function, for example: WorkbookEvaluator.registerFunction("SERIESSUM", new SERIESSUM()) then POI will recognize my code and register the function. But now POI will not recognize that it should apply this implementation of the "SERIESSUM" function to the equivalent German "POTENZREIHE" function that it will read from the Excel file. This is because it works by "name" of the function, as you have suggested before. But the English and the German name of a function differ in these cases. (b) if I register my function under the German name of the function, for example: WorkbookEvaluator.registerFunction("POTENZREIHE", new SERIESSUM()) then POI won't register my function at all. This is because, internally, it works only with the English names of ATP functions, and "potenzreihe" is, of course, not in that list of functions that POI works with. (c) The fact that POI works with function names for ATP functions, is also supported by the few functions that have the same name in the English and German version of Excel. For example, "DURATION" is the name for the English function, and for the German function, as well. In this case, when I register my function under the English = German name of the function, that is, WorkbookEvaluator.registerFunction("DURATION", new DURATION()) then POI will register my function - because it knows the English name - AND it will apply this implementation to the function that it finds in the Excel file - because it will find the German name of the function that it reads from the Excel file in its list of English function names - simply because they are both identical. ***************************** Is there any solution to this problem? Of course, one could "register" the German functions as user-defined functions (UDF), but this is not really what is intended. Is there any simple bypass to this problem? Thanks for any suggestions... Christian Am 09.05.2012 19:30, schrieb Nick Burch: </pre> Christian 2012-05-23T16:59:07 http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22679 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53280 Nick Burch &lt;nick.burch&lt; at &gt;alfresco.com&gt; changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #1 from Nick Burch &lt;nick.burch&lt; at &gt;alfresco.com&gt; --- If you look a little further down your exception stacktrace, you'll see what's wrong: Caused by: java.lang.NoClassDefFoundError: org.openxmlformats.schemas.spreadsheetml.x2006.main.CTPhoneticRun This is covered in the FAQ: http://poi.apache.org/faq.html#faq-N10025 If you're able to provide the unit test needed to have your new part of the schemas included as standard, please re-open the bug and attach the test </pre> bugzilla< at >apache.org 2012-05-23T14:17:50 http://permalink.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://permalink.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://permalink.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://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22675 <pre>Did you try with the latest POI-3.8 ? If the problem is still there, can you create a new bug in Bugzilla and attach a sample file with a non-breaking space and Java code that demonstrates the problem? This way we record the issue and will not forget about it. Yegor On Wed, May 23, 2012 at 2:09 AM, lakshmi &lt;lakshmi.nidadavolu&lt; at &gt;yahoo.com&gt; wrote: </pre> Yegor Kozlov 2012-05-23T08:18:13 http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22674 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=49765 --- Comment #26 from Romesh Soni &lt;soni.romesh&lt; at &gt;gmail.com&gt; --- Created attachment 28822 --&gt; https://issues.apache.org/bugzilla/attachment.cgi?id=28822&amp;action=edit Sample code Call the CustomXWPFDocument.java like this: import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import org.apache.poi.openxml4j.exceptions.InvalidFormatException; import org.apache.poi.xwpf.usermodel.Document; import org.apache.poi.xwpf.usermodel.XWPFDocument; /* Romesh Soni soni.romesh&lt; at &gt;gmail.com */ public class TestCustom { public static void main(String []a) throws FileNotFoundException, IOException, InvalidFormatException { CustomXWPFDocument document = new CustomXWPFDocument(new FileInputStream(new File("c://Economic.docx"))); FileOutputStream fos = new FileOutputStream(new File("C:\\updatedTemplate.docx")); String blipId = document.addPictureData(new FileInputStream(new File("c:\\Most_famous_Caves_of_the_Dordogne_Private_p_4.jpg")), Document.PICTURE_TYPE_JPEG); System.out.println(document.getNextPicNameNumber(Document.PICTURE_TYPE_JPEG)); //System.out.println(document.getNextPicNameNumber(Document.PICTURE_TYPE_JPEG)); document.createPicture(blipId,document.getNextPicNameNumber(Document.PICTURE_TYPE_JPEG), 500, 500); document.write(fos); fos.flush(); fos.close(); } } </pre> bugzilla< at >apache.org 2012-05-23T06:44:25 http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22673 <pre>http://apache-poi.1045710.n5.nabble.com/file/n5709875/test.xlsx test.xlsx Hi, I tested a hyperlink with the fix that has a non-breaking space, its also not a valid java.util.URI. The hyperlink with a non-breaking space is not being encoded in the PackagingURIHelper.toURI(value). The non-breaking space which is an invalid character should be encoded to be a valid java.util.URI. Example of a non-breaking space is "nobody&lt; at &gt;nowhere.uk ". It looks like a regular space but its a non-breaking space. The uploaded file test.xlsx includes this hyperlink. -- View this message in context: http://apache-poi.1045710.n5.nabble.com/DO-NOT-REPLY-Bug-50154-New-POIFS-save-losing-drawing-part-tp3236279p5709875.html Sent from the POI - Dev mailing list archive at Nabble.com. </pre> lakshmi 2012-05-22T22:09:10 http://permalink.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://permalink.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://permalink.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://permalink.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://permalink.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 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.jakarta.poi.devel