[Bug 62442] Attribute "relid" bound to namespace "urn:schemas-microsoft-com:office:office" was already specified for element "v:fill"
https://bz.apache.org/bugzilla/show_bug.cgi?id=62442 --- Comment #4 from Стас Агарков --- Prompt, please, the actual working Java XML Parsers, except for Apache Xerces J -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 62247] Support for LineStyle in XSSFComment
https://bz.apache.org/bugzilla/show_bug.cgi?id=62247 --- Comment #3 from Kai G --- Hi Mayur, I think PJ asked if you can provide a patch against the current master that includes the feature that you are missing. See https://poi.apache.org/guidelines.html about information how you can contribute to Apache POI -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 62444] New: Newline character in table header row cell causes damage to Excel file
https://bz.apache.org/bugzilla/show_bug.cgi?id=62444
Bug ID: 62444
Summary: Newline character in table header row cell causes
damage to Excel file
Product: POI
Version: 3.17-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: dmgau...@uab.edu
Target Milestone: ---
Overview
If there is a newline (or perhaps a carriage return) in the text of a header
cell in a table in an XSSFSheet, when the workbook is written out by POI and
then read by Excel, Excel reports some unreadable content in the workbook.
Steps to Reproduce
1) Use Excel to prepare a workbook that has a table in the first sheet.
2) Select a header cell in the table, and enter text containing a new-line in
the cell. In Excel 2011 for Mac, this is done with the keystroke combination
cmd-option-return.
3) Save the workbook.
4) Read and then write the workbook using the following POI code:
final File testFile = new File(srcFile.getParentFile(), "test.xlsx");
final InputStream is = new FileInputStream(srcFile);
final XSSFWorkbook wb = (XSSFWorkbook) WorkbookFactory.create(is);
is.close();
try (OutputStream fileOut = new FileOutputStream(testFile)) {
wb.write(fileOut);
wb.close();
}
5) Open the workbook in Excel. You will get warning message about repairing
unreadable content; when you examine the repair log file, you will get the
following information:
Repair Result to test 04744.xml
Errors were detected in file ‘[path redacted]:test.xlsx'
Repaired Records: Table from /xl/tables/table1.xml (List)
This has been seen in version 3.17 of POI, on Macintosh running OS X 10.11.6,
using Excel 2011 for Mac
--
You are receiving this mail because:
You are the assignee for the bug.
-
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 62442] Attribute "relid" bound to namespace "urn:schemas-microsoft-com:office:office" was already specified for element "v:fill"
https://bz.apache.org/bugzilla/show_bug.cgi?id=62442 --- Comment #3 from PJ Fanning --- The error is coming from the Java built-in version of the Apache Xerces XML parser. You can replace this (cf https://docs.oracle.com/javase/7/docs/api/javax/xml/parsers/DocumentBuilderFactory.html). You can experiment with different XML parsers and settings for them. I am not personally aware of any setup that workaround this issue. The XML in your spreadsheet is badly formed. -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 62442] Attribute "relid" bound to namespace "urn:schemas-microsoft-com:office:office" was already specified for element "v:fill"
https://bz.apache.org/bugzilla/show_bug.cgi?id=62442 Стас Агарков changed: What|Removed |Added OS||All --- Comment #2 from Стас Агарков --- This file was sent by the supplier of children's clothing https://acoolakids.ru/ I'll find out from them how they create such a file. What kind of workaround can I find? Now, I just ask users of my software through Excel to re-save the file. Excel fixes this error. -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 62442] Attribute "relid" bound to namespace "urn:schemas-microsoft-com:office:office" was already specified for element "v:fill"
https://bz.apache.org/bugzilla/show_bug.cgi?id=62442 --- Comment #1 from PJ Fanning --- Comment on attachment 35961 --> https://bz.apache.org/bugzilla/attachment.cgi?id=35961 test file for crash apache poi open What produced that test xlsx file? The content of the xl/drawings/vmlDrawing1.vml is causing an XML parsing issue in Apache Xerces Not the duplicate o:relid="rId1" attributes. Maybe there is a way to set some system properties that gets Xerces to ignore the duplicate attributes. -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 62442] Attribute "relid" bound to namespace "urn:schemas-microsoft-com:office:office" was already specified for element "v:fill"
https://bz.apache.org/bugzilla/show_bug.cgi?id=62442 Стас Агарков changed: What|Removed |Added Attachment #35961|test file for crash apa poi |test file for crash apache description|open|poi open -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 62442] New: Attribute "relid" bound to namespace "urn:schemas-microsoft-com:office:office" was already specified for element "v:fill"
https://bz.apache.org/bugzilla/show_bug.cgi?id=62442 Bug ID: 62442 Summary: Attribute "relid" bound to namespace "urn:schemas-microsoft-com:office:office" was already specified for element "v:fill" Product: POI Version: 3.17-FINAL Hardware: PC Status: NEW Severity: normal Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: stas.agar...@gmail.com Target Milestone: --- Created attachment 35961 --> https://bz.apache.org/bugzilla/attachment.cgi?id=35961=edit test file for crash apa poi open An error occurs while opening the file: org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException at org.apache.poi.POIXMLFactory.createDocumentPart(POIXMLFactory.java:63) at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:580) at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:592) at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:165) at org.apache.poi.xssf.usermodel.XSSFWorkbook.(XSSFWorkbook.java:270) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:266) at ru.misterparser.acoola.Parser.processFile(Parser.java:121) at ru.misterparser.acoola.Parser.run(Parser.java:102) Caused by: java.lang.reflect.InvocationTargetException 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 org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:56) at org.apache.poi.POIXMLFactory.createDocumentPart(POIXMLFactory.java:60) ... 7 more Caused by: org.apache.xmlbeans.XmlException: Attribute "relid" bound to namespace "urn:schemas-microsoft-com:office:office" was already specified for element "v:fill". at org.apache.poi.xssf.usermodel.XSSFVMLDrawing.read(XSSFVMLDrawing.java:134) at org.apache.poi.xssf.usermodel.XSSFVMLDrawing.(XSSFVMLDrawing.java:120) ... 13 more Caused by: org.xml.sax.SAXParseException; lineNumber: 14; columnNumber: 35; Attribute "relid" bound to namespace "urn:schemas-microsoft-com:office:office" was already specified for element "v:fill". at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:203) at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalError(ErrorHandlerWrapper.java:177) at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:400) at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327) at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:284) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.scanStartElement(XMLNSDocumentScannerImpl.java:322) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:2784) at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:602) at com.sun.org.apache.xerces.internal.impl.XMLNSDocumentScannerImpl.next(XMLNSDocumentScannerImpl.java:112) at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:505) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:841) at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:770) at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141) at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:243) at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:339) at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:121) at org.apache.poi.util.DocumentHelper.readDocument(DocumentHelper.java:140) at org.apache.poi.xssf.usermodel.XSSFVMLDrawing.read(XSSFVMLDrawing.java:132) ... 14 more -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[GitHub] poi pull request #112: Support for LineStyle in XSSFComment
Github user mayuranchalia closed the pull request at: https://github.com/apache/poi/pull/112 --- - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[Bug 62247] Support for LineStyle in XSSFComment
https://bz.apache.org/bugzilla/show_bug.cgi?id=62247 --- Comment #2 from Mayur Jain --- Hi PJ, I am not sure what do mean by creating a pull request on Github? -- You are receiving this mail because: You are the assignee for the bug. - To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
[GitHub] poi pull request #112: Support for LineStyle in XSSFComment
GitHub user mayuranchalia opened a pull request: https://github.com/apache/poi/pull/112 Support for LineStyle in XSSFComment XSSFComment doesn't have support for Linestyle similar to HSSFComment In HSSFComment we have functions like setLineStyle and setLineStyleColor, similar feature is required for XSSFComment . Bugzilla bug https://bz.apache.org/bugzilla/show_bug.cgi?id=62247 You can merge this pull request into a Git repository by running: $ git pull https://github.com/apache/poi trunk Alternatively you can review and apply these changes as the patch at: https://github.com/apache/poi/pull/112.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #112 commit fb321255e8aab6f51ef579c554ff1b5028e3a2d3 Author: Javen O'Neal Date: 2017-11-07T00:29:09Z bug 61730: add iterator interface to CellRangeAddressBase for iterating over CellAddresses git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1814448 13f79535-47bb-0310-9956-ffa450edef68 commit 841cc75ee498921c97fd9386e8f564e75010f173 Author: Javen O'Neal Date: 2017-11-07T01:54:25Z bug 61730: add javadoc git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1814451 13f79535-47bb-0310-9956-ffa450edef68 commit 163673a7aa8b42324f4aa922971a9475ddcdee62 Author: Javen O'Neal Date: 2017-11-07T07:21:24Z bug 61730: remove CellRangeAddressBase which is eager. The lazy iterator is safer, less likely to cause an OOM/DoS. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1814461 13f79535-47bb-0310-9956-ffa450edef68 commit 8b0145c6e0cb27ac72610271073ebac140e5ca5a Author: Javen O'Neal Date: 2017-11-07T07:26:48Z bug 61730: remove asSet function from unit test git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1814462 13f79535-47bb-0310-9956-ffa450edef68 commit 2d5b6457c6d5dd5a8f910d726bb493233b01724b Author: Dominik Stadler Date: 2017-11-08T14:59:08Z Some JavaDoc adjustments, typos, IntelliJ warnings git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1814587 13f79535-47bb-0310-9956-ffa450edef68 commit 70fdcdf8481cdcf3c6465a189956e30822a3e96f Author: Mark Murphy Date: 2017-11-11T14:18:24Z Surface XSSF Header/Footer Attributes (60887) git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1814950 13f79535-47bb-0310-9956-ffa450edef68 commit c1e6c2eef7949e74e99d6dda799d2be1b9c6b6ff Author: Javen O'Neal Date: 2017-11-12T01:30:42Z deprecate XWPFTable#addNewRowBetween(int,int), which has not been implemented since 2008 when this class was first authored. (Unrelated: This closes #82 on github). git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1814997 13f79535-47bb-0310-9956-ffa450edef68 commit fd29e874025e5d2ab6f6595ccc9687639124dc2f Author: Javen O'Neal Date: 2017-11-12T01:32:43Z make tableRows final; initialize where defined rather than in constructor. git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1814998 13f79535-47bb-0310-9956-ffa450edef68 commit 1bc1bdb58b2b3517c98ebc5899810f8ce1234411 Author: Javen O'Neal Date: 2017-11-12T01:34:52Z XWPFTable#getRows() should return an unmodifiable list unless the method can correctly update xmlbeans in response to modifying the list git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1814999 13f79535-47bb-0310-9956-ffa450edef68 commit fbccf3066cda10b8f1408d11785a1d07a24a8f18 Author: Javen O'Neal Date: 2017-11-12T06:14:43Z github #81: sheet names are case insensitive git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1815001 13f79535-47bb-0310-9956-ffa450edef68 commit bac484ba379cc226ace386fdd851ffd8bdc76b12 Author: Javen O'Neal Date: 2017-11-12T06:52:38Z +svn:eol-style native *.java git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1815002 13f79535-47bb-0310-9956-ffa450edef68 commit a1b8f3ff1446f1e52d9ced9de8370e10cf5e5faa Author: Javen O'Neal Date: 2017-11-12T21:48:41Z bug 61745: add support for charts in XWPF/docx. Thanks to Sandeep Tiwari for the patch git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1815047 13f79535-47bb-0310-9956-ffa450edef68 commit f062e7f1c2c278b19f5fb7ac86bb7df9d3a48882 Author: Javen O'Neal Date: 2017-11-13T00:51:41Z bug 61745: remove String#toString() usage found by forbidden apis check git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1815048 13f79535-47bb-0310-9956-ffa450edef68 commit 1b9d599882ba628b8d7499b807e404186ffa1ac0 Author: Dominik Stadler Date: 2017-11-13T11:44:50Z Fix tests git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1815085 13f79535-47bb-0310-9956-ffa450edef68 commit 3e70d22cbc45f1460583127e9c430a461b7852c9 Author: Dominik Stadler Date: 2017-11-13T11:46:04Z Fix setting a font-color if no previous color is defined
