[Bug 65040] New: Cell IFERROR don't work with other formula cells with POI
https://bz.apache.org/bugzilla/show_bug.cgi?id=65040 Bug ID: 65040 Summary: Cell IFERROR don't work with other formula cells with POI Product: POI Version: 4.1.2-FINAL Hardware: PC Status: NEW Severity: blocker Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: sunyiao1...@gmail.com Target Milestone: --- Created attachment 37667 --> https://bz.apache.org/bugzilla/attachment.cgi?id=37667&action=edit IFERROR Example When I want to evaluate the formula cell with IFERROR cell, it don't work. I attached a example Excel File Ex. In sheet 1 I got A2 Cell with IFERROR =IFERROR(SUM(B2,B3,"Some Error Here",aetezt);0) In sheet2 I use this IFERROR cell to do a SUM in cell A2: =SOMME(Sheet1!A2,Sheet1!C2,Sheet1!C3) POI can't return the result of sheet2 A2 correctly: Value Actual with POI : 0 Expected Value : 7 Could you please check this and correct it please ? Best regards, Yiao SUN -- 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 65040] Cell IFERROR don't work with other formula cells with POI
https://bz.apache.org/bugzilla/show_bug.cgi?id=65040 Dominik Stadler changed: What|Removed |Added Severity|blocker |major OS||All -- 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 65009] When loading a PPT, PictureData indices are 0-based
https://bz.apache.org/bugzilla/show_bug.cgi?id=65009 Dominik Stadler changed: What|Removed |Added Keywords||PatchAvailable -- 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 65026] Migrate tests to Junit 5
https://bz.apache.org/bugzilla/show_bug.cgi?id=65026 --- Comment #3 from Dolls France --- [reply] [−]DescriptionAndreas Beeker 2020-12-24 18:23:30 UTC Junit5 brings a few features missing in Junit4 - namely better support for parameterized and nested tests. I've decided to give it a try, and then I was in the middle of migration purgatory :) https://sex-dolls-europe.com The following changes will be visible after I committed the 1000+ file changes: a) Junit5 uses different annotations and different packages -- 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 65042] New: Writing pircture to workbook cause memory leak due to picture data is to much in memory.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65042 Bug ID: 65042 Summary: Writing pircture to workbook cause memory leak due to picture data is to much in memory. Product: POI Version: 4.1.2-FINAL Hardware: Macintosh OS: Mac OS X 10.4 Status: NEW Severity: blocker Priority: P2 Component: SXSSF Assignee: dev@poi.apache.org Reporter: satioas...@gmail.com Target Milestone: --- Created attachment 37670 --> https://bz.apache.org/bugzilla/attachment.cgi?id=37670&action=edit Memory Usage Dump Sxssf using Xssf handle its picture. So picture will save in memory, not flush with row. This means if we have a lot of pictures had to write in xlsx, this will cause memory leak which was I am struggling with. I can't find a way to flush picture data before workbook.write(). The test case is, 300kb picture, one row write 10 pictures. JVM -Xmx128m. There will be an oom when write 50 rows. In that time, the picture data list will have 60mb in memory. -- 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 65042] Writing pircture to workbook cause memory leak due to picture data is to much in memory.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65042 --- Comment #1 from Runzhi --- Created attachment 37671 --> https://bz.apache.org/bugzilla/attachment.cgi?id=37671&action=edit Memory I count in program -- 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 65009] When loading a PPT, PictureData indices are 0-based
https://bz.apache.org/bugzilla/show_bug.cgi?id=65009 Dominik Stadler changed: What|Removed |Added Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #2 from Dominik Stadler --- Applied via r1884948 in a slightly different way to use the same approach across two similar code-places. -- 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 65042] Writing pircture to workbook cause memory leak due to picture data is to much in memory.
https://bz.apache.org/bugzilla/show_bug.cgi?id=65042 Dominik Stadler changed: What|Removed |Added Severity|blocker |major -- 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 64986] Cannot evaluate formulas with extra comma before missing optional parameter
https://bz.apache.org/bugzilla/show_bug.cgi?id=64986 Dominik Stadler changed: What|Removed |Added OS||All -- 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 64980] org.apache.poi.openxml4j.exceptions.PartAlreadyExistsException
https://bz.apache.org/bugzilla/show_bug.cgi?id=64980 Dominik Stadler changed: What|Removed |Added OS||All -- 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 64950] about doughnutchart
https://bz.apache.org/bugzilla/show_bug.cgi?id=64950 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO -- 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 64959] [PATCH] PackagePart#flush is unused
https://bz.apache.org/bugzilla/show_bug.cgi?id=64959 Dominik Stadler changed: What|Removed |Added Summary|PackagePart#flush is unused |[PATCH] PackagePart#flush ||is unused -- 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 64959] [PATCH] PackagePart#flush is unused
https://bz.apache.org/bugzilla/show_bug.cgi?id=64959 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO -- 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 65042] Adding pictures to workbook causes memory leak
https://bz.apache.org/bugzilla/show_bug.cgi?id=65042 Dominik Stadler changed: What|Removed |Added Summary|Writing pircture to |Adding pictures to workbook |workbook cause memory leak |causes memory leak |due to picture data is to | |much in memory. | -- 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 65042] Adding pictures to workbook causes memory leak
https://bz.apache.org/bugzilla/show_bug.cgi?id=65042 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #2 from Dominik Stadler --- Can you provide a small piece of code which reproduces the problem for you? Ideally as a self-contained unit-test so we can reproduce the problem and take a closer look? -- 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 64980] org.apache.poi.openxml4j.exceptions.PartAlreadyExistsException
https://bz.apache.org/bugzilla/show_bug.cgi?id=64980 --- Comment #2 from Dominik Stadler --- The main [Content_Types.xml] in the .xlsx is not according to the spec in the broken file, it does not link to the shared-strings xml file as required. Unfortunately both LibreOffice and Excel are "lenient" for many such cases and thus makes it actually harder for everyone else ... -- 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 64838] Loading and saving a file adds an unwanted tag resulting in additional newlines in the document
https://bz.apache.org/bugzilla/show_bug.cgi?id=64838 Dominik Stadler changed: What|Removed |Added Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #6 from Dominik Stadler --- I thought some more about this and decided to try to remove this behavior as it seems unwanted and is likely a very old remnant of the early implementation here. We'll see if there are cases that need this behavior and can then re-add it under some better conditions that do not change files in such an unexpected way. This is done via r1884958. -- 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 64986] Cannot evaluate formulas with extra comma before missing optional parameter
https://bz.apache.org/bugzilla/show_bug.cgi?id=64986 Dominik Stadler changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #1 from Dominik Stadler --- This should be fixed via r1884959, we now handle missing or blank match_type as default value "1". -- 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 64032] FormulaEvaluator executes IFERROR function bug
https://bz.apache.org/bugzilla/show_bug.cgi?id=64032 Dominik Stadler changed: What|Removed |Added Resolution|--- |WORKSFORME Status|NEW |RESOLVED --- Comment #1 from Dominik Stadler --- There is a method for all formula-evaluators to ignore such missing workbooks, see BaseFormulaEvaluator#setIgnoreMissingWorkbooks(). Please try to use this method to configure how Apache POI behaves here. Please reopen tihs issue if this does not solve it in your case together with more information to reproduce it, i.e. ideally a self-contained piece of code which reproduces the situation that you encounter. -- 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 65040] Cell IFERROR don't work with other formula cells with POI
https://bz.apache.org/bugzilla/show_bug.cgi?id=65040 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO -- 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 64980] org.apache.poi.openxml4j.exceptions.PartAlreadyExistsException
https://bz.apache.org/bugzilla/show_bug.cgi?id=64980 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO -- 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 64851] ctr.getTArray() returns empty array
https://bz.apache.org/bugzilla/show_bug.cgi?id=64851 Dominik Stadler changed: What|Removed |Added Resolution|--- |INFORMATIONPROVIDED Status|NEW |RESOLVED --- Comment #3 from Dominik Stadler --- I am not an expert on the underlying XML, but I think oyu only provide the inner XML here, and the "w:r" is actually provided via the CTR.Factory anyway. Anyway I don't think there is anything for Apache POI to fix, so closing this for now. -- 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 64811] autoSizeColumn too small if cell contains special characters
https://bz.apache.org/bugzilla/show_bug.cgi?id=64811 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from Dominik Stadler --- When running this locally on Linux Ubuntu 20.04, the width of the cells is fine, so it may be related to the fonts that are installed on the system where you run the auto-size operation (OS rendering functionality is used to draw the actual characters of the Font of the cell). Please verify if default fonts and some basic X-window libraries are installed as those might be needed for proper execution of the auto-sizing functionality. -- 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 64759] Can't clone sheet - unknown relation type found: http://schemas.microsoft.com/office/2017/10/relationships/threadedComment
https://bz.apache.org/bugzilla/show_bug.cgi?id=64759 Dominik Stadler changed: What|Removed |Added Severity|normal |enhancement -- 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 64689] WordToHtmlConverter does not support "Text Wrapping: Around" for tables
https://bz.apache.org/bugzilla/show_bug.cgi?id=64689 Dominik Stadler changed: What|Removed |Added Severity|minor |enhancement -- 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 64674] the formula of cell is disabled when ExcelToHtmlConverter is used
https://bz.apache.org/bugzilla/show_bug.cgi?id=64674 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from Dominik Stadler --- Can you provide an source-example which allows to reproduce this? Preferably as a self-contained unit-test so it can be added to the test-suite? -- 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 60924] New Excel 2016 Statements Not Supported
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924 Dominik Stadler changed: What|Removed |Added Depends on||64633 Referenced Bugs: https://bz.apache.org/bugzilla/show_bug.cgi?id=64633 [Bug 64633] [PATCH] Support of function TEXTJOIN -- 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 64633] [PATCH] Support of function TEXTJOIN
https://bz.apache.org/bugzilla/show_bug.cgi?id=64633 Dominik Stadler changed: What|Removed |Added Blocks||60924 Referenced Bugs: https://bz.apache.org/bugzilla/show_bug.cgi?id=60924 [Bug 60924] New Excel 2016 Statements Not Supported -- 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 64750] getDataValidations relies on the count attribute being present
https://bz.apache.org/bugzilla/show_bug.cgi?id=64750 Dominik Stadler changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #1 from Dominik Stadler --- Thanks for the very detailed reproducer! This is fixed now on latest trunk via r1885011, we now only look at the array and ignore the "count" attribute to always handle elements even if count is not set. -- 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 65046] New: Simplify integration tests
https://bz.apache.org/bugzilla/show_bug.cgi?id=65046 Bug ID: 65046 Summary: Simplify integration tests Product: POI Version: 4.1.x-dev Hardware: All OS: All Status: NEW Severity: enhancement Priority: P2 Component: POI Overall Assignee: dev@poi.apache.org Reporter: kiwiwi...@apache.org Target Milestone: --- Created attachment 37678 --> https://bz.apache.org/bugzilla/attachment.cgi?id=37678&action=edit Integration test patch The TestAllFiles class is a bit non-deterministic, i.e. the several try catches and various expected failure lists are confusing. I've changed the implementation so it's now based on a test list which takes into account which ... - file, - file handler - test case, - password - and exception/message ... is processed. To have comparable exceptions, I've removed the wrapping IOException/POIXMLException. Furthermore I've activated concurrent processing, which cuts the test time on my machine by 50% - only active for the integration tests. As this would affect our current regression test comparability, I stash it here until we've released POI 5.0.0 ... and maybe you want to give it a review. -- 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 64450] InvalidFormatException because of a PivotTable
https://bz.apache.org/bugzilla/show_bug.cgi?id=64450 Dominik Stadler changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #1 from Dominik Stadler --- A change via r1885056 allows to parse such a document. However it seems this file is slightly corrupt as it includes an empty id in the relationship definitions. -- 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 64494] CellStyles propagate unexpectedly and incorrectly
https://bz.apache.org/bugzilla/show_bug.cgi?id=64494 Dominik Stadler changed: What|Removed |Added Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #1 from Dominik Stadler --- It seems there is an additional "applyAlignment" boolean that is currently not handled by Apache POI. This should be fixed on latest trunk via r1885059 by setting this and also checking it's value for getters, you should be able to verify this via the next nightly build. -- 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 64411] Provide JigSaw modules
https://bz.apache.org/bugzilla/show_bug.cgi?id=64411 Dominik Stadler changed: What|Removed |Added Severity|normal |enhancement -- 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 64341] Incorrect value returned for FormulaError on evaluating formula cell
https://bz.apache.org/bugzilla/show_bug.cgi?id=64341 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO -- 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 64261] Parse Errors for application/vnd.ms-excel
https://bz.apache.org/bugzilla/show_bug.cgi?id=64261 Dominik Stadler changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #4 from Dominik Stadler --- As far as I see this was actually fixed some time ago via r1875956. -- 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 64258] Provide implementation for TDIST function
https://bz.apache.org/bugzilla/show_bug.cgi?id=64258 Dominik Stadler changed: What|Removed |Added Summary|Alternative approach for|Provide implementation for |TDIST function formula |TDIST function |evaluation | Severity|major |enhancement -- 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 64165] Can't read in rows without 'r' attribute
https://bz.apache.org/bugzilla/show_bug.cgi?id=64165 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #4 from Dominik Stadler --- Any plans to provide the mentioned updated patch? -- 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 64132] Regression in handling UnknownEscherRecord when getting pictures in .doc files
https://bz.apache.org/bugzilla/show_bug.cgi?id=64132 --- Comment #1 from Dominik Stadler --- Running "git bisect" identifies change r1873187 being related here. -- 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 64036] Replace reflection calls in factories for Java 9+
https://bz.apache.org/bugzilla/show_bug.cgi?id=64036 Dominik Stadler changed: What|Removed |Added Blocks||64132 Referenced Bugs: https://bz.apache.org/bugzilla/show_bug.cgi?id=64132 [Bug 64132] Regression in handling UnknownEscherRecord when getting pictures in .doc files -- 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 64132] Regression in handling UnknownEscherRecord when getting pictures in .doc files
https://bz.apache.org/bugzilla/show_bug.cgi?id=64132 Dominik Stadler changed: What|Removed |Added Depends on||64036 Referenced Bugs: https://bz.apache.org/bugzilla/show_bug.cgi?id=64036 [Bug 64036] Replace reflection calls in factories for Java 9+ -- 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 64132] Regression in handling UnknownEscherRecord when getting pictures in .doc files
https://bz.apache.org/bugzilla/show_bug.cgi?id=64132 Dominik Stadler changed: What|Removed |Added Severity|normal |regression -- 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 64132] Regression in handling UnknownEscherRecord when getting pictures in .doc files
https://bz.apache.org/bugzilla/show_bug.cgi?id=64132 Dominik Stadler changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #2 from Dominik Stadler --- Fixed via r1885092, these documents should be parsed as before again now. -- 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 65042] Adding pictures to workbook causes memory leak
https://bz.apache.org/bugzilla/show_bug.cgi?id=65042 --- Comment #3 from Runzhi --- Sorry for the late response. I have created a repository that can reproduce the problem. Run unit test with max heap size 128m. Repository URL is : https://github.com/foresx/poi-memory-leak-demo -- 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 65058] New: SUMPRODUCT evaluation error with some SUMIFS cases
https://bz.apache.org/bugzilla/show_bug.cgi?id=65058 Bug ID: 65058 Summary: SUMPRODUCT evaluation error with some SUMIFS cases Product: POI Version: 4.1.2-FINAL Hardware: PC Status: NEW Severity: critical Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: gerard.du...@externe.bnpparibas.com Target Milestone: --- Created attachment 37687 --> https://bz.apache.org/bugzilla/attachment.cgi?id=37687&action=edit test case for bug reproduction I'm managing an XFFS workflow within which I have a formula cell with a SUMIFS nside a SUMPRODUCT. But its evaluation fails, whereas Excel 2016 just handles it well. Here is an example of failing formula: SUMPRODUCT(SUMIFS(B1:B3, C1:C3, F6:F7)). This one would also fail: SUMPRODUCT(SUMIFS(B1:B3, C1:C3, D2:D3)). ... whereas this one works: SUMPRODUCT(SUMIFS(B1:B3, C1:C3, D1:D2)). The generated exception: java.lang.RuntimeException: Invalid arg type for SUMPRODUCT: (org.apache.poi.ss.formula.eval.ErrorEval) at org.apache.poi.ss.formula.functions.Sumproduct.evaluate(Sumproduct.java:83) at org.apache.poi.ss.formula.OperationEvaluatorFactory.evaluate(OperationEvaluatorFactory.java:153) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:541) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:275) at org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:216) at org.apache.poi.xssf.usermodel.BaseXSSFFormulaEvaluator.evaluateFormulaCellValue(BaseXSSFFormulaEvaluator.java:56) at org.apache.poi.ss.formula.BaseFormulaEvaluator.evaluate(BaseFormulaEvaluator.java:110) at com.bnpparibas.sit.fin.asteria.formula.SumproductSumifsBugTest.testFormulaEvaluateAll(SumproductSumifsBugTest.java:68) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:628) at org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:117) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:184) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:180) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:127) at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:68) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:135) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122) at org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:80) at java.util.ArrayList.forEach(ArrayList.java:1257) at org.junit.platform.engine.support.hierarchical.SameThreadHierarchicalTestExecutorService.invokeAll(SameThreadHierarchicalTestExecutorService.java:38) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$5(NodeTestTask.java:139) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:125) at org.junit.platform.engine.support.hierarchical.Node.around(Node.java:135) at org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:123) at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73) at org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:122
[Bug 65058] SUMPRODUCT evaluation error with some SUMIFS cases
https://bz.apache.org/bugzilla/show_bug.cgi?id=65058 --- Comment #1 from gerard.du...@externe.bnpparibas.com --- Created attachment 37688 --> https://bz.apache.org/bugzilla/attachment.cgi?id=37688&action=edit expected output if evaluation worked -- 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 65059] New: wrong evaluation of SUMPRODUCT when nested SUMIFS use ranges
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059 Bug ID: 65059 Summary: wrong evaluation of SUMPRODUCT when nested SUMIFS use ranges Product: POI Version: 4.1.2-FINAL Hardware: PC Status: NEW Severity: normal Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: gerard.du...@externe.bnpparibas.com Target Milestone: --- Created attachment 37689 --> https://bz.apache.org/bugzilla/attachment.cgi?id=37689&action=edit test case for reproduction I'm managing an XFFS workflow within which I have a formula cell with a SUMIFS nside a SUMPRODUCT. But its evaluation give a bad result: it is different from Excel of Office 365. The nested SUMIFS uses ranges as criteria. For example: SUMPRODUCT(SUMIFS(B1:B3, C1:C3, D1:D3)) The evaluation is done via FormulaEvaluator.evaluateAll(). I'm providing a test case for more details. -- 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 65059] wrong evaluation of SUMPRODUCT when nested SUMIFS use ranges
https://bz.apache.org/bugzilla/show_bug.cgi?id=65059 --- Comment #1 from gerard.du...@externe.bnpparibas.com --- Created attachment 37690 --> https://bz.apache.org/bugzilla/attachment.cgi?id=37690&action=edit expected output if workbook written on file system -- 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 65061] New: Handle VmlDrawings containing spreadsheet-ml default namespace
https://bz.apache.org/bugzilla/show_bug.cgi?id=65061 Bug ID: 65061 Summary: Handle VmlDrawings containing spreadsheet-ml default namespace Product: POI Version: 4.1.x-dev Hardware: All OS: All Status: NEW Severity: normal Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: kiwiwi...@apache.org Target Milestone: --- Created attachment 37691 --> https://bz.apache.org/bugzilla/attachment.cgi?id=37691&action=edit excel containing vmldrawing with invalid default namespace The regression test came up with a few failing documents containing vmlDrawing1.xmls which have a spreadsheet-ml default namespace [1]. This is wrong and needs to be workaround - i.e. vml drawings have no root namespace [2]. I can think of three ways to workaround it: a) remove the namespace before parsing the file b) replace the namespace in the loaded XmlObject c) keep it inside and ignore it I've picked a). contra b): works, but the document is modified after it's validated. contra c): writing the drawing back again keeps the erroneous declaration. and the XmlBeans accessor doesn't work too. I still need to test my modifications, but the fix will be applied soon. [1] http://schemas.openxmlformats.org/spreadsheetml/2006/main [2] https://c-rex.net/projects/samples/ooxml/e1/Part1/OOXML_P1_Fundamentals_VML_topic_ID0EZ5EO.html -- 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 65061] Handle VmlDrawings containing spreadsheet-ml default namespace
https://bz.apache.org/bugzilla/show_bug.cgi?id=65061 Andreas Beeker changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #1 from Andreas Beeker --- applied via r1885197 -- 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 65042] Adding pictures to workbook causes memory leak
https://bz.apache.org/bugzilla/show_bug.cgi?id=65042 Dominik Stadler changed: What|Removed |Added Status|NEEDINFO|NEW Severity|major |enhancement --- Comment #4 from Dominik Stadler --- Thanks for the detailed reproducing code, I took a look at your sample-project now. Pictures in .xlsx files are not stored per "row" or "sheet", but rather globally in a separate structure along the other parts. The current SXSSFWorkbook only flushes and removes rows based on the "rowAccesswindowSize". So flushing picture data for SXSSFWorkbook is currently not supported, we can consider adding it as an enhancement, naturally it will happen sooner if you can propose an implementation that offers this as additional option for SXSSFWorkbook in some way, however it will require some coding as you likely need to flush out pictures in a similar way as the rows and then a write-time combine the information into the final document as well. -- 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 57342] Writing very large file via SXSSF leads to corrupt file
https://bz.apache.org/bugzilla/show_bug.cgi?id=57342 Bug 57342 depends on bug 62872, which changed state. Bug 62872 Summary: Writing large files with 800k rows gives java.io.IOException: This archive contains unclosed entries. https://bz.apache.org/bugzilla/show_bug.cgi?id=62872 What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED -- 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 62872] Writing large files with 800k rows gives java.io.IOException: This archive contains unclosed entries.
https://bz.apache.org/bugzilla/show_bug.cgi?id=62872 Dominik Stadler changed: What|Removed |Added Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #12 from Dominik Stadler --- I think we provide as much as we can here by allowing the user to select Zip64Mode if necessary. Unfortunately not all tools seem to be able to handle such files, so we cannot use this as default right now. We may be able to switch it in the future when all the major tools have enabled support. Please reopen if there is still something that can be done in Apache POI here. -- 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 62872] Writing large files with 800k rows gives java.io.IOException: This archive contains unclosed entries.
https://bz.apache.org/bugzilla/show_bug.cgi?id=62872 --- Comment #13 from PJ Fanning --- Dominik - Zip64Mode.Always is the default in SXSSFWorkbook as of POI 5.0.0 -- 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 65046] Simplify integration tests
https://bz.apache.org/bugzilla/show_bug.cgi?id=65046 Dominik Stadler changed: What|Removed |Added Attachment #37678|text/plain |application/x-gzip mime type|| Attachment #37678|1 |0 is patch|| -- 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 65046] Simplify integration tests
https://bz.apache.org/bugzilla/show_bug.cgi?id=65046 --- Comment #1 from Dominik Stadler --- Thanks for the suggestion, yes, sound like a good idea to clean up the integration-testing a bit and also the speedup sounds very good as it is becoming a bit long-running already. I will review the impact on the mass-testing, the following items are used currently: * reuse the excludes via TestAllFiles.SCAN_EXCLUDES * a way to lookup matching handlers based on file-extension via POIFileScanner * use the interface FileHandler for executing the test for each file * use BaseIntegrationTest.test() for executing tests for each file None of the logic in TestAllFiles itself is needed, so refactoring it should be possible as long as the basic FileHandler implementations are kept as-is. Removing POIFileScanner would need some other way of getting a list of matching documents. Keeping this in one place would be nice to not duplicate this logic in both projects. Not sure how much impact the changed Exception-handling will have, this will need a closer look. But let's keep this until after the 5.0.0 release so we do not introduce more changes right now. -- 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 62872] Writing large files with 800k rows gives java.io.IOException: This archive contains unclosed entries.
https://bz.apache.org/bugzilla/show_bug.cgi?id=62872 --- Comment #14 from Dominik Stadler --- Ah, thanks for the note. But files created via SXSSFWorkbook seem to still work in LibreOffice even with this, so what was making them corrupt here? -- 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 62872] Writing large files with 800k rows gives java.io.IOException: This archive contains unclosed entries.
https://bz.apache.org/bugzilla/show_bug.cgi?id=62872 --- Comment #15 from PJ Fanning --- This is an old issue - not really sure what was wrong over 2 years ago. -- 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 65063] New: WMF parsing failed on closed empty polygon
https://bz.apache.org/bugzilla/show_bug.cgi?id=65063 Bug ID: 65063 Summary: WMF parsing failed on closed empty polygon Product: POI Version: 4.1.x-dev Hardware: PC OS: Linux Status: NEW Severity: normal Priority: P2 Component: HSLF Assignee: dev@poi.apache.org Reporter: kiwiwi...@apache.org Target Milestone: --- Created attachment 37692 --> https://bz.apache.org/bugzilla/attachment.cgi?id=37692&action=edit wmf having an empty closed polygon The regression tests came up with a PPT containing a WMF file with an empty polygon causing the parsing to fail. -- 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 65063] WMF parsing failed on closed empty polygon
https://bz.apache.org/bugzilla/show_bug.cgi?id=65063 Andreas Beeker changed: What|Removed |Added Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #1 from Andreas Beeker --- applied via r1885215 -- 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 65042] Adding pictures to workbook causes memory leak
https://bz.apache.org/bugzilla/show_bug.cgi?id=65042 --- Comment #5 from Runzhi --- Thanks a lot. When I have free time, I think I will have a try. -- 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 64450] InvalidFormatException because of a PivotTable
https://bz.apache.org/bugzilla/show_bug.cgi?id=64450 --- Comment #2 from odelpozo --- (In reply to Dominik Stadler from comment #1) > A change via r1885056 allows to parse such a document. However it seems this > file is slightly corrupt as it includes an empty id in the relationship > definitions. Hello, Thanks for the update. When is expected to be released the version of the library with this issue fixed? -- 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 65065] New: NullPointerException in org.apache.poi.xssf.usermodel.XSSFCellStyle#cloneStyleFrom
https://bz.apache.org/bugzilla/show_bug.cgi?id=65065 Bug ID: 65065 Summary: NullPointerException in org.apache.poi.xssf.usermodel.XSSFCellStyle#cloneStyle From Product: POI Version: 4.1.2-FINAL Hardware: PC OS: Mac OS X 10.1 Status: NEW Severity: major Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: liugenshui2...@163.com Target Milestone: --- Exception: Exception in thread "main" java.lang.NullPointerException at org.apache.poi.xssf.model.StylesTable.getNumberFormatId(StylesTable.java:273) at org.apache.poi.xssf.model.StylesTable.putNumberFormat(StylesTable.java:295) at org.apache.poi.xssf.usermodel.XSSFDataFormat.getFormat(XSSFDataFormat.java:52) at org.apache.poi.xssf.usermodel.XSSFCellStyle.cloneStyleFrom(XSSFCellStyle.java:185) at com.genshui.excel.ExcelStyleTest.copyCellStyle(ExcelStyleTest.java:56) at com.genshui.excel.ExcelStyleTest.main(ExcelStyleTest.java:29) it actually happened in org.apache.poi.xssf.model.StylesTable#getNumberFormatId when the map numberFormats has a null value -- 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 65065] NullPointerException in org.apache.poi.xssf.usermodel.XSSFCellStyle#cloneStyleFrom
https://bz.apache.org/bugzilla/show_bug.cgi?id=65065 Andreas Beeker changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from Andreas Beeker --- as usual: please attach the causing Excel file -- 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 60924] New Excel 2016 Statements Not Supported
https://bz.apache.org/bugzilla/show_bug.cgi?id=60924 Matafagafo changed: What|Removed |Added CC||matafag...@yahoo.com -- 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 64772] docx file signing failed
https://bz.apache.org/bugzilla/show_bug.cgi?id=64772 Andreas Beeker changed: What|Removed |Added Resolution|--- |CLOSED Status|NEEDINFO|RESOLVED --- Comment #4 from Andreas Beeker --- A months have passed since the request to provide the docx and I/we haven't received something. Feel free to reopen the issue with an attached docx causing this error - I assume the docx is enough, I probably don't need the pfx keystore. -- 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 62010] Attempting to password protect excel file without writing to disk, getting Rule M2.4 exception
https://bz.apache.org/bugzilla/show_bug.cgi?id=62010 Andreas Beeker changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WORKSFORME --- Comment #1 from Andreas Beeker --- 3 years later it's probably too late, but you need to close the stream which you've got from "OutputStream os = enc.getDataStream(fs)" -- 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 64861] Error should never happen
https://bz.apache.org/bugzilla/show_bug.cgi?id=64861 Bug 64861 depends on bug 62010, which changed state. Bug 62010 Summary: Attempting to password protect excel file without writing to disk, getting Rule M2.4 exception https://bz.apache.org/bugzilla/show_bug.cgi?id=62010 What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WORKSFORME -- 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 65065] NullPointerException in org.apache.poi.xssf.usermodel.XSSFCellStyle#cloneStyleFrom
https://bz.apache.org/bugzilla/show_bug.cgi?id=65065 --- Comment #2 from liugenshui2...@163.com --- Created attachment 37693 --> https://bz.apache.org/bugzilla/attachment.cgi?id=37693&action=edit the causing Excel file the causing Excel file -- 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 65065] NullPointerException in org.apache.poi.xssf.usermodel.XSSFCellStyle#cloneStyleFrom
https://bz.apache.org/bugzilla/show_bug.cgi?id=65065 --- Comment #3 from liugenshui2...@163.com --- (In reply to Andreas Beeker from comment #1) > as usual: please attach the causing Excel file the causing Excel file see Comment 2 -- 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 64086] No valid entries or contents found, this is not a valid OOXML.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64086 --- Comment #5 from Kais hamdulay --- Hi i am facing same issue. The xlsx works fine on windows but fails in linux with same 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 64086] No valid entries or contents found, this is not a valid OOXML.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64086 Kais hamdulay changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|WORKSFORME |--- -- 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 64086] No valid entries or contents found, this is not a valid OOXML.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64086
--- Comment #6 from Kais hamdulay ---
Hi I am facing a similar issue faced by kanish
the file works smoothly on windows but when I transfer file in binary mode
using winscp to the ftp server and read it from the i get the below error
org.apache.poi.openxml4j.exceptions.InvalidOperationException: Could not open
the specified zip entry source stream
at
org.apache.poi.openxml4j.opc.ZipPackage.openZipEntrySourceStream(ZipPackage.java:212)
at
org.apache.poi.openxml4j.opc.ZipPackage.openZipEntrySourceStream(ZipPackage.java:194)
at
org.apache.poi.openxml4j.opc.ZipPackage.openZipEntrySourceStream(ZipPackage.java:168)
at org.apache.poi.openxml4j.opc.ZipPackage.(ZipPackage.java:149)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:277)
at
org.apache.poi.xssf.usermodel.XSSFWorkbookFactory.createWorkbook(XSSFWorkbookFactory.java:124)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:327)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:295)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:276)
at
com.shari.importer.helper.ImportCommonHelper.initializeFile(ImportCommonHelper.java:434)
at
com.shari.importer.helper.ImportCommonHelper.getMappedStock(ImportCommonHelper.java:291)
at
com.shari.importer.processor.XLSXMerchantImportSetupProcessor.remoteFetchAndProcess(XLSXMerchantImportSetupProcessor.java:136)
at
com.shari.importer.processor.XLSXMerchantImportSetupProcessor.processMerchantImportSetups(XLSXMerchantImportSetupProcessor.java:102)
at
com.shari.importer.processor.XLSXMerchantImportSetupProcessor.process(XLSXMerchantImportSetupProcessor.java:71)
at
com.shari.importer.service.MerchantCatalogImportService.importMerchantsCatalog(MerchantCatalogImportService.java:40)
at
com.shari.importer.consumer.AutomatedMerchantCatalogImportEventConsumer.consumeEvent(AutomatedMerchantCatalogImportEventConsumer.java:24)
at
com.broadleafcommerce.jobsevents.service.DatabaseSystemEventNodeImpl.executeEvent(DatabaseSystemEventNodeImpl.java:827)
at
com.broadleafcommerce.jobsevents.service.DatabaseSystemEventNodeImpl$5$1.execute(DatabaseSystemEventNodeImpl.java:756)
at
com.broadleafcommerce.jobsevents.service.consumer.EventLockUtil.runLockedOperation(EventLockUtil.java:139)
at
com.broadleafcommerce.jobsevents.service.DatabaseSystemEventNodeImpl$5.run(DatabaseSystemEventNodeImpl.java:749)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.io.EOFException: unexpected EOF - expected len: 1848089 -
actual len: 1847932
at org.apache.poi.util.IOUtils.toByteArray(IOUtils.java:196)
at org.apache.poi.util.IOUtils.toByteArray(IOUtils.java:149)
at
org.apache.poi.openxml4j.util.ZipArchiveFakeEntry.(ZipArchiveFakeEntry.java:47)
at
org.apache.poi.openxml4j.util.ZipInputStreamZipEntrySource.(ZipInputStreamZipEntrySource.java:53)
at
org.apache.poi.openxml4j.opc.ZipPackage.openZipEntrySourceStream(ZipPackage.java:210)
... 22 common frames omitted
2021-01-12 13:52:03.868 ERROR 8070 --- [QueueStatusThreadPoolTaskExecutor-1]
c.s.i.p.XLSXMerchantImportSetupProcessor : Error Occurred processing XLSX
merchant import for : price change - {
c1af6f9d-cc62-4695-bee9-624fb037b36b}
--
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 64086] No valid entries or contents found, this is not a valid OOXML.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64086 Kais hamdulay changed: What|Removed |Added Version|unspecified |4.1.2-FINAL -- 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 64086] No valid entries or contents found, this is not a valid OOXML.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64086 Kais hamdulay changed: What|Removed |Added CC||kaishamdu...@gmail.com -- 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 64086] No valid entries or contents found, this is not a valid OOXML.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64086 --- Comment #7 from Andreas Beeker --- > unexpected EOF - expected len: 1848089 - actual len: 1847932 please verify the file on Windows/Linux is the same, e.g. by using "md5 ". I'm quite sure it's truncated ... -- 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 65075] New: My program works well on my operating system. But when I test it on another system, sometimes the output Word file is not generated
https://bz.apache.org/bugzilla/show_bug.cgi?id=65075
Bug ID: 65075
Summary: My program works well on my operating system. But when
I test it on another system, sometimes the output Word
file is not generated
Product: POI
Version: 4.1.2-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XWPF
Assignee: dev@poi.apache.org
Reporter: abdollah.s...@gmail.com
Target Milestone: ---
Created attachment 37701
--> https://bz.apache.org/bugzilla/attachment.cgi?id=37701&action=edit
The libraries I used in the project
Hi friends I have a big problem I wrote a program in Java with javafx and
apache poi and got the output file using launch4j. My program works well on my
operating system. But when I test it on another system, sometimes the output
Word file is not generated.
I noticed that when I send the information of a row from the table to the new
controller and I want to create a Word file in the new controller, the Word
file is not created. Of course, there is no problem in my system and it does
not run on other systems. I used the try-catch command around the document
created with apache poi and got the IllegalArgumentException error. My codes
are as follows First we send the information of one of the rows of the table to
the destination controller as below
@FXML
void onNewAmrieEnteghaliItemClick(ActionEvent event) {
try{
TablePosition pos =
soldierTable.getSelectionModel().getSelectedCells().get(0);
int row = pos.getRow();
FXMLLoader loader = new
FXMLLoader(getClass().getResource("GetAmrieEnteghal.fxml"));
loader.setControllerFactory(new Callback, Object>() {
public Object call(Class controllerClass) {
if (controllerClass == GetAmrieEnteghalController.class) {
GetAmrieEnteghalController ctrl = new
GetAmrieEnteghalController();
ctrl.setP(
code_meliCol.getCellData(row)
);
return ctrl ;
} else {
try {
return controllerClass.newInstance();
} catch (Exception exc) {
throw new RuntimeException(exc); // just bail
}
}
}
});
Parent root = loader.load();
Stage stage = new Stage();
stage.getIcons().add(APPLICATION_ICON);
Scene scene = new Scene(root);
stage.setScene(scene);
stage.show();
}catch(Exception e){
e.printStackTrace();
noSelectedSoldier();
}
}
In GetAmrieEnteghalController we give the selected row information to the
database and receive other record information and then place it in the object
created with apache poi as below
package javafxapplication3;
import com.jfoenix.controls.JFXTextField;
import java.net.URL;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ResourceBundle;
import java.util.logging.Level;
import java.util.logging.Logger;
import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.fxml.Initializable;
import javafx.stage.Stage;
import javafxapplication3.Models.MyAlert;
import javafxapplication3.Reports.AmrieEnteghal;
public class GetAmrieEnteghalController implements Initializable {
private String s_code_meli;
public void setP(String code_meli){
s_code_meli = code_meli;
}
@FXML
private JFXTextField be;
@FXML
private JFXTextField girande;
@FXML
private JFXTextField sh_nameh;
@FXML
private JFXTextField t_kasr_az_amar;
@FXML
void onGetFormBtnClick(ActionEvent event) {
String daraje = null, name= null, pedar= null, t_ezam= null, sh_amrie=
null, t_amrie= null, t_enteghal= null;
if(SQLiteDB.setConnection()){
if(SQLiteDB.selectQuery("select * from soldiers where code_meli =
'"+s_code_meli+"';")){
ResultSet res = SQLiteDB.getResultSet();
try {
while(res.next()){
daraje = res.getString("daraje");
name = res.getString("name");
pedar = res.getString("pedar");
t_ezam = res.getString("t_e");
sh_amrie = res.getString("sh_amrie_enteghal");
t_amrie = res.getString("t_amrie_enteghal");
t_enteghal = res.getString("t_enteghal");
}
} catch (SQLException ex) {
ex.printStackTrace();
[Bug 64086] No valid entries or contents found, this is not a valid OOXML.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64086 --- Comment #8 from Kais hamdulay --- Hi andreas, There is one difference here I am reading the file from FTPClient and then downloading it on the linux server. I am apache FTPClient to read the file in binary mode and then write it to linux server and then read it from there However,all these operations work fine if the server i it is on windows But throws the error on linux. I can verify the length using the command -- 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 64086] No valid entries or contents found, this is not a valid OOXML.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64086
--- Comment #9 from Kais hamdulay ---
Hi I checked the md5 and its coming different for the file on windows and the
other one that i had copied using winscp to the ftp server and later on read
the file from ftp using FTPClient and written that file on linux server local
path from where i am reading it.
I have checked from the code perspective its perfect as i am setting the file
type as binary while reading the file from ftp and writing the bytes to
destination file using below code.
Howevr,I am not sure what is going wrong here
for (FTPFile ftpFile : result) {
boolean canDownload =
this.isFileEligibleForDownload(merchantImportSetup, ftpFile);
if (ftpFile.isFile() && canDownload) {
ftpFile.setType(FTPSClient.BINARY_FILE_TYPE);
log.info("Save the file to db");
log.info("file to be read from ftp location is : " +
ftpFile.getName());
String remoteFile = "/" +
merchantImportSetup.getDirectory() + "/" + ftpFile.getName();
File localPath = new File(fileSystemBaseDirectory +
File.separator +
merchantCatalogImporterFileService.getRandomizedFile(ftpFile.getName()));
OutputStream outputStream2 = new BufferedOutputStream(new
FileOutputStream(localPath));
InputStream inputStream =
ftpClient.retrieveFileStream(remoteFile);
byte[] bytesArray = new byte[4096];
int bytesRead = -1;
while ((bytesRead = inputStream.read(bytesArray)) != -1) {
outputStream2.write(bytesArray, 0, bytesRead);
}
boolean success = ftpClient.completePendingCommand();
if (success) {
System.out.println("File #2 has been downloaded
successfully.");
}
outputStream2.close();
inputStream.close();
}
--
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 64086] No valid entries or contents found, this is not a valid OOXML.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64086
--- Comment #10 from Kais hamdulay ---
I have found the solution for the issue,.
The issue was with the reading of file from ftp client
Below settings are recommended to avoid falling into this issue from FTPClient
Before every file read or write we need to set the
ftpClient.setFileType(FTP.BINARY_FILE_TYPE) which is very important and solved
my issue
ftpClient = getFTPClient();
ftpClient.setConnectTimeout(connectionTimeout);
ftpClient.connect(url, port);
ftpClient.enterLocalPassiveMode();
ftpClient.setControlEncoding("UTF-8");
ftpClient.setFileType(FTP.BINARY_FILE_TYPE);
//login
if (!ftpClient.login(ftpAuth[0], ftpAuth[1])) {
ftpClient.logout();
}
for (FTPFile ftpFile : result) {
boolean canDownload =
this.isFileEligibleForDownload(merchantImportSetup, ftpFile);
if (ftpFile.isFile() && canDownload) {
log.info("Save the file to db");
log.info("file to be read from ftp location is : " +
ftpFile.getName());
String remoteFile = "/" +
merchantImportSetup.getDirectory() + "/" + ftpFile.getName();
File localPath = new File(fileSystemBaseDirectory +
File.separator +
merchantCatalogImporterFileService.getRandomizedFile(ftpFile.getName()));
OutputStream outputStream = new BufferedOutputStream(new
FileOutputStream(localPath));
ftpClient.setFileType(FTP.BINARY_FILE_TYPE);
ftpClient.retrieveFile(remoteFile, outputStream);
//since file is already copied into local file system ,
upload it to OSS
log.info(merchantImportSetup.getFriendlyImportName() + "-"
+ "file is downloaded from FTP at " + localPath.getAbsolutePath());
String ossPath =
merchantCatalogImporterFileService.uploadToOSS(merchantImportSetup, localPath);
log.info(merchantImportSetup.getFriendlyImportName() + "-"
+ "file is uploaded to OSS at " + ossPath);
downloadFile = localPath;
IOUtils.closeQuietly(outputStream);
break;
}
}
--
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 64086] No valid entries or contents found, this is not a valid OOXML.
https://bz.apache.org/bugzilla/show_bug.cgi?id=64086 Kais hamdulay changed: What|Removed |Added Status|REOPENED|RESOLVED Resolution|--- |FIXED -- 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 65077] New: Workbook.close() clears the second (the last) sheet data in previously saved file
https://bz.apache.org/bugzilla/show_bug.cgi?id=65077
Bug ID: 65077
Summary: Workbook.close() clears the second (the last) sheet
data in previously saved file
Product: POI
Version: 4.1.1-FINAL
Hardware: PC
Status: NEW
Severity: major
Priority: P2
Component: SXSSF
Assignee: dev@poi.apache.org
Reporter: grigorie...@netcracker.com
Target Milestone: ---
Created attachment 37703
--> https://bz.apache.org/bugzilla/attachment.cgi?id=37703&action=edit
example source file
Hi guys,
In the following example second invocation of Workbook.close() produces file
test2.xlsx with two sheets, but the second has no data.
Also observed: the first file has size of 32,952 bytes and the second one has
61,619 bytes.
int rowNumber = 0;
int cellNumber = 0;
String outputFileName = "c:/temp/test1.xlsx";
File outFile = new File(outputFileName);
File outFile2 = new File("c:/temp/test2.xlsx");
Workbook workbook = new SXSSFWorkbook(100);
try {
Sheet sheet = workbook.createSheet("Sheet1");
Row row = null;
for (int i = 0; i < 1000; i++) {
row = sheet.createRow(rowNumber++);
cellNumber = 0;
for (int j = 1; j <= 10; j++) {
Cell cell = row.createCell(cellNumber++);
cell.setCellValue(String.valueOf(j));
}
}
try (FileOutputStream out = new FileOutputStream(outFile)) {
workbook.write(out);
}
} finally {
workbook.close();
((SXSSFWorkbook) workbook).dispose();
}
workbook = new SXSSFWorkbook((XSSFWorkbook)
WorkbookFactory.create(outFile), 100);
try {
Sheet sheet = workbook.createSheet("Sheet2");
Row row = null;
for (int i = 0; i < 1000; i++) {
row = sheet.createRow(rowNumber++);
cellNumber = 0;
for (int j = 1; j <= 10; j++) {
Cell cell = row.createCell(cellNumber++);
cell.setCellValue(String.valueOf(j));
}
}
try (FileOutputStream out = new FileOutputStream(outFile2)) {
workbook.write(out);
}
} finally {
workbook.close();
((SXSSFWorkbook) workbook).dispose();
}
--
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 65077] Workbook.close() clears the second (the last) sheet data in previously saved file
https://bz.apache.org/bugzilla/show_bug.cgi?id=65077
Andrey Grigoriev changed:
What|Removed |Added
OS||All
--- Comment #1 from Andrey Grigoriev ---
There was wrong example. Please use this one:
int rowNumber = 0;
int cellNumber = 0;
String outputFileName = "c:/temp/test1.xlsx";
File outFile = new File(outputFileName);
//File outFile2 = new File("c:/temp/test2.xlsx");
Workbook workbook = new SXSSFWorkbook(100);
try {
Sheet sheet = workbook.createSheet("Sheet1");
Row row = null;
for (int i = 0; i < 1000; i++) {
row = sheet.createRow(rowNumber++);
cellNumber = 0;
for (int j = 1; j <= 10; j++) {
Cell cell = row.createCell(cellNumber++);
cell.setCellValue(String.valueOf(j));
}
}
try (FileOutputStream out = new FileOutputStream(outFile)) {
workbook.write(out);
}
} finally {
workbook.close();
((SXSSFWorkbook) workbook).dispose();
}
rowNumber = 0;
cellNumber = 0;
workbook = new SXSSFWorkbook((XSSFWorkbook)
WorkbookFactory.create(outFile), 100);
try {
Sheet sheet = workbook.createSheet("Sheet2");
Row row = null;
for (int i = 0; i < 1000; i++) {
row = sheet.createRow(rowNumber++);
cellNumber = 0;
for (int j = 1; j <= 10; j++) {
Cell cell = row.createCell(cellNumber++);
cell.setCellValue(String.valueOf(j));
}
}
Files.delete(Paths.get(outFile.getPath()));
try (FileOutputStream out = new FileOutputStream(outFile)) {
workbook.write(out);
}
} finally {
workbook.close();
((SXSSFWorkbook) workbook).dispose();
}
--
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 64450] InvalidFormatException because of a PivotTable
https://bz.apache.org/bugzilla/show_bug.cgi?id=64450 --- Comment #3 from Dominik Stadler --- It will be included in the next major release 5.0.0 which is currently in the "voting phase", so ideally will be available soon. -- 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 65081] New: Adding a new sheet to a large SS using low memory
https://bz.apache.org/bugzilla/show_bug.cgi?id=65081 Bug ID: 65081 Summary: Adding a new sheet to a large SS using low memory Product: POI Version: unspecified Hardware: PC Status: NEW Severity: enhancement Priority: P2 Component: SXSSF Assignee: dev@poi.apache.org Reporter: kar...@contentiq.com Target Milestone: --- When attaching a new sheet to an existing spreadsheet, the current function will still load the entire SS in memory before attaching the new sheet. This method uses an alternative approach by modifying the base XML structure to attach a new sheet, instead of loading the entire SS. -- 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 65081] Adding a new sheet to a large SS using low memory
https://bz.apache.org/bugzilla/show_bug.cgi?id=65081 Karan Banga changed: What|Removed |Added OS||All -- 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 65081] Adding a new sheet to a large SS using low memory
https://bz.apache.org/bugzilla/show_bug.cgi?id=65081 Andreas Beeker changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from Andreas Beeker --- Please add your patch. -- 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 65075] My program works well on my operating system. But when I test it on another system, sometimes the output Word file is not generated
https://bz.apache.org/bugzilla/show_bug.cgi?id=65075 Sayi changed: What|Removed |Added OS||All --- Comment #1 from Sayi --- Hi, I think you should focus on whether it's a POI bug, rather than giving too much irrelevant code. -- 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 63421] An XDDFScatterChartData chart with a single series and default formatting has non-uniform formatting
https://bz.apache.org/bugzilla/show_bug.cgi?id=63421 --- Comment #2 from David --- This problem can be solved disabling a color property: ((XSSFChart)objChart).getCTChart().getPlotArea().getScatterChartArray(0) .addNewVaryColors().setVal(false); -- 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 65046] Simplify integration tests
https://bz.apache.org/bugzilla/show_bug.cgi?id=65046 Andreas Beeker changed: What|Removed |Added Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #2 from Andreas Beeker --- Applied via r1885538 I've removed POIFileScanner as it's not need for the internal integration tests. To lookup the handler, you can copy the logic of TestAllFiles.allfiles. If this doesn't work, POIFileScanner can be reverted. -- 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 65084] New: A same message is attached to different exceptions
https://bz.apache.org/bugzilla/show_bug.cgi?id=65084
Bug ID: 65084
Summary: A same message is attached to different exceptions
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: OPC
Assignee: dev@poi.apache.org
Reporter: zhong...@pku.org.cn
Target Milestone: ---
The message is " Packages shall not contain equivalent part names and package
implementers shall neither create nor recognize packages with equivalent part
names". It is attached to three different exceptions.
1. OPCPackage#addPackagePart throws InvalidOperationException:
protected PackagePart addPackagePart(PackagePart part) {
...
if (partList.containsKey(part._partName)) {
if (!partList.get(part._partName).isDeleted()) {
throw new InvalidOperationException(
"A part with the name '"
+
part._partName.getName()
+ "' already
exists : Packages shall not contain equivalent part names and package
implementers shall neither create nor recognize packages with equivalent part
names. [M1.12]");
}
// If the specified partis flagged as deleted, we make
it
// available
part.setDeleted(false);
// and delete the old part to replace it thereafeter
this.partList.remove(part._partName);
}
}
2. ZipPackage.EntryTriple#register throws InvalidFormatException:
private class EntryTriple implements Comparable {
...
if (partList.containsKey(partName)) {
throw new InvalidFormatException(
"A part with the name '"+partName+"' already exist :
Packages shall not contain equivalent part names " +
"and package implementers shall neither create nor
recognize packages with equivalent part names. [M1.12]");
}
}
3. OPCPackage#createPart throws PartAlreadyExistsException:
PackagePart createPart(PackagePartName partName, String contentType,
boolean loadRelationships) {
...
if (partList.containsKey(partName)
&& !partList.get(partName).isDeleted()) {
throw new PartAlreadyExistsException(
"A part with the name '" +
partName.getName() + "'" +
" already exists : Packages shall not
contain equivalent part names and package" +
" implementers shall neither create nor
recognize packages with equivalent part names. [M1.12]");
}
...
}
It is strange to find the same type of errors is attached to three different
exceptions. InvalidOperationException looks better than the other two, as far
as the message is concerned. Maybe, the messages themselves shall be revised?
--
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 65085] New: LineRect shall throw more specific exceptions
https://bz.apache.org/bugzilla/show_bug.cgi?id=65085
Bug ID: 65085
Summary: LineRect shall throw more specific exceptions
Product: POI
Version: unspecified
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: HSLF
Assignee: dev@poi.apache.org
Reporter: zhong...@pku.org.cn
Target Milestone: ---
LineRect#getRowHeight and LineRect#setRowHeight throw IllegalArgumentException:
public double getRowHeight(int row) {
if (row < 0 || row >= cells.length) {
throw new IllegalArgumentException("Row index '"+row+"' is not
within range [0-"+(cells.length-1)+"]");
}
return cells[row][0].getAnchor().getHeight();
}
@Override
public void setRowHeight(int row, final double height) {
if (row < 0 || row >= cells.length) {
throw new IllegalArgumentException("Row index '"+row+"' is not
within range [0-"+(cells.length-1)+"]");
}
...
}
In both cases, it is more reasonable to throw IndexOutOfBoundsException.
--
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 65046] Simplify integration tests
https://bz.apache.org/bugzilla/show_bug.cgi?id=65046 --- Comment #3 from Dominik Stadler --- POIFileScanner can easily be moved to the regression-test project, but it is now complicated to use the integration-test functionality to find a matching handler for an arbitrary file, i.e. "TestAllFiles.HANDLERS.get(TestAllFiles.getExtension(file))" does not work any more. I would like to re-use this "knowledge" from poi about the relation of extensions to file-handlers. -- 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 65046] Simplify integration tests
https://bz.apache.org/bugzilla/show_bug.cgi?id=65046 --- Comment #4 from Andreas Beeker --- I refactored the TestAllFiles class and extracted some classes. Have a look at TestAllFiles.allfiles - the StressMap is used to retrieve the FileHandlers. It must be initialized with the mapping file before. For the mass test, the "Exceptions" sheet doesn't need to be provided. -- 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 65016] Creating a chart throws IndexOutOfBoundsException
https://bz.apache.org/bugzilla/show_bug.cgi?id=65016 Alain Fagot Bearez changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #2 from Alain Fagot Bearez --- Following pull request should fix the exception which was thrown when trying to unset an underlying XML element which was not set. https://github.com/apache/poi/pull/220 Could you check if this also fixes your use case? -- 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 64950] about doughnutchart
https://bz.apache.org/bugzilla/show_bug.cgi?id=64950 --- Comment #3 from Alain Fagot Bearez --- The pull request at https://github.com/apache/poi/pull/201/ is now providing the expected behaviour to set the hole size. I am still working to make the chart creation from scratch produce a file which opens with PowerPoint, as it currently only opens with LibreOffice. -- 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 63421] An XDDFScatterChartData chart with a single series and default formatting has non-uniform formatting
https://bz.apache.org/bugzilla/show_bug.cgi?id=63421 Alain Fagot Bearez changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #3 from Alain Fagot Bearez --- Rather than using the low-level API calls as suggested in comment #2, the XDDFScatterChartData object also offers direct access to the method setVaryColors where you can disable the default behaviour. Could you try in your code? XDDFScatterChartData data = (XDDFScatterChartData) chart.createData(ChartTypes.SCATTER data.setVaryColors(false) -- 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 65016] Creating a chart throws IndexOutOfBoundsException
https://bz.apache.org/bugzilla/show_bug.cgi?id=65016 Dominik Stadler changed: What|Removed |Added Status|NEEDINFO|NEW --- Comment #3 from Dominik Stadler --- This seems to fix the issue for me, Thanks! -- 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 65040] Cell IFERROR don't work with other formula cells with POI
https://bz.apache.org/bugzilla/show_bug.cgi?id=65040 --- Comment #1 from Yiao SUN --- my college added tests and example in ticket https://bz.apache.org/bugzilla/show_bug.cgi?id=65058 and https://bz.apache.org/bugzilla/show_bug.cgi?id=65059 -- 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 65016] Creating a chart throws IndexOutOfBoundsException
https://bz.apache.org/bugzilla/show_bug.cgi?id=65016 Alain Fagot Bearez changed: What|Removed |Added Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #4 from Alain Fagot Bearez --- fixed by r1885700 -- 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 64244] [PATCH] Fix exception from using applyFont for unicode representation _xHHHH_
https://bz.apache.org/bugzilla/show_bug.cgi?id=64244 --- Comment #3 from Hyeonmin Park --- Suggestion: add this ticket to History of Changes http://poi.apache.org/changes.html#5.0.0 -- 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
