http://permalink.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/22694 <pre>this is a known limitation - current implementation supports only pictures. This is true both for WordToHtml and WordToFo converters. It may sound like a simple improvement but unfortunately it is not. In MS Word native text (paragraph and text runs) and text in graphic objects are two completely different beasts. Normal text is converted to html or FO. Graphic needs to be converted either to Image or to SVG and this is still a TODO. Yegor On Thu, May 24, 2012 at 6:15 PM, Dmitry Zamula &lt;club.brantner&lt; at &gt;gmail.com&gt; wrote: </pre> Yegor Kozlov 2012-05-25T13:35:50 http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22693 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53271 Yegor Kozlov &lt;yegor&lt; at &gt;dinom.ru&gt; changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |FIXED OS| |All --- Comment #1 from Yegor Kozlov &lt;yegor&lt; at &gt;dinom.ru&gt; --- Fixed in r1342604 Yegor </pre> bugzilla< at >apache.org 2012-05-25T12:54:15 http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22692 <pre>You appear to have just dumped a huge pile of code into an email, without any explanation, so as it stands you're unlikely to get a lot of help... As a general tip though, try with POI 3.8 Final rather than 3.5, as it has several years work of bug fixes Nick </pre> Nick Burch 2012-05-24T21:53:55 http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22691 <pre>package test; import java.io.FileInputStream; import java.io.InputStream; import java.util.LinkedHashMap; import java.util.Locale; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.usermodel.WorkbookFactory; public class Excel2007Util { public LinkedHashMap validateFile(String strFile, int feedColumnCount){ System.out.println("Starting of method validateFile in FileUploadUtil to validate whether the file is a valid file format or not." ); boolean validFile = true; //String invalidFileMessage = AdjustmentsConstants.invalidTemplateMsg;; int rowCount = 0; int columnCount = 0; Row row = null; Cell cell = null; String strTemp = null; LinkedHashMap returnMap = new LinkedHashMap(); //HSSFSheet sheet = null; Sheet sheet = null; if(strFile != null ){ System.out.println("strFile is issue : " </pre> raopoi 2012-05-24T17:47:13 http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22690 <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 ---------------------------------------------------------------------------- Status|NEEDINFO |NEW </pre> bugzilla< at >apache.org 2012-05-24T16:26:26 http://permalink.gmane.org/gmane.comp.jakarta.poi.devel/22689 <pre>https://issues.apache.org/bugzilla/show_bug.cgi?id=53282 --- Comment #5 from lakshmi &lt;lakshmi.nchandana&lt; at &gt;gmail.com&gt; --- Created attachment 28830 --&gt; https://issues.apache.org/bugzilla/attachment.cgi?id=28830&amp;action=edit Excel file with a non-breaking space hyperlink </pre> bugzilla< at >apache.org 2012-05-24T16:25:39 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 sho</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 </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.</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 </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-XSSFWor</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.addPi</pre> bugzilla< at >apache.org 2012-05-23T06:44:25 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.jakarta.poi.devel