[Bug 69315] PropertiesChunk.readProperties stops reading properties when a multi valued property is encountered
https://bz.apache.org/bugzilla/show_bug.cgi?id=69315 --- Comment #3 from Dominik Stadler --- I tried to reproduce the proposed fix, but could not. @Test void testBug69315() throws Exception { POIDataSamples testData = POIDataSamples.getPOIFSInstance(); try (MAPIMessage mapi = new MAPIMessage(testData.openResourceAsStream("MailSentPropertyMultiple.msg"))) { assertNotNull(mapi.getAttachmentFiles()); assertNotNull(mapi.getDisplayBCC()); assertNotNull(mapi.getMessageDate()); AttachmentChunks[] attachments = mapi.getAttachmentFiles(); for (AttachmentChunks attachment : attachments) { DirectoryChunk chunkDirectory = attachment.getAttachmentDirectory(); if (chunkDirectory != null) { MAPIMessage attachmentMSG = chunkDirectory.getAsEmbeddedMessage(); assertNotNull(attachmentMSG); String body = attachmentMSG.getTextBody(); assertNotNull(body); } } assertNull(mapi.getSummaryInformation()); assertNull(mapi.getDocumentSummaryInformation()); Chunks chunks = mapi.getMainChunks(); assertNotNull(chunks); //assertEquals("", chunks.getProperties().keySet().toString()); } } Can you extend this test-case to reproduce and verify the suggested changes? FYI, I don't know much about the format and the implementation in POI, it was done years ago by people who left since then. -- 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 69315] PropertiesChunk.readProperties stops reading properties when a multi valued property is encountered
https://bz.apache.org/bugzilla/show_bug.cgi?id=69315 --- Comment #2 from Dominik Hölzl --- Created attachment 39870 --> https://bz.apache.org/bugzilla/attachment.cgi?id=39870&action=edit E-Mail with a multi valued named property This e-mail contains the multi valued named property 8005101F (, 0001, 0002, 0003). The e-mail also contains the property CLIENT_SUBMIT_TIME, but when reading it it returns null instead of the correct value when the patch of this bug report is not applied. NOTE: The file cannot be opened with Outlook as it was programmatically modified, but it can be parsed with 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 65943] SXSSF doesn't support Rich Text Strings
https://bz.apache.org/bugzilla/show_bug.cgi?id=65943 --- Comment #9 from KarlRamsey --- (In reply to PJ Fanning from comment #7) > https://bananagame.co is a publicly > accessible URL. > > Talk to your ISP or your network admin. There are no planned releases - we've recently done 2 releases and we normally only do 1 or 2 a year. You could try the potential solution in Commment 2 or you can build POI yourself from the latest source files and use those jars. -- 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 43648] Wrong signedness for IntPtg
https://bz.apache.org/bugzilla/show_bug.cgi?id=43648 --- Comment #2 from Rick --- I appreciate the author's willingness to take risks and push boundaries. https://786.osttopstfreeware.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 68615] getSummaryInformation breaks document images
https://bz.apache.org/bugzilla/show_bug.cgi?id=68615 Matafagafo changed: What|Removed |Added CC||matafag...@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 68714] Operator BETWEEN should work both ways
https://bz.apache.org/bugzilla/show_bug.cgi?id=68714 Matafagafo changed: What|Removed |Added CC||matafag...@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 66644] Make Apache POI binaries reproducible
https://bz.apache.org/bugzilla/show_bug.cgi?id=66644 Dominik Stadler changed: What|Removed |Added Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #6 from Dominik Stadler --- A simple check now did not show any differences any more when building latest Apache POI twice. There are also some unit-tests which verify that written files do not differ if SOURCE_DATE_EPOCH is set. See https://poi.apache.org/help/faq.html#faq-reproducible-build-and-output for a FAQ entry describing both aspects of "reproducibility". -- 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 66687] Combination of XSSF and SXSSF may result in invalid files
https://bz.apache.org/bugzilla/show_bug.cgi?id=66687 --- Comment #2 from Martin Schlömer --- I have not been working on this for more than a year now, so maybe i'm misremembering things. We use templates created by customers and complete them with JXLS programmatically. If the issue is with the stored templates - we can't control that. If the issue is opening the file in the wrong way - i guess that's on JXLS then. If i need to look into it again, i'll have to get back to you next week. -- 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 66687] Combination of XSSF and SXSSF may result in invalid files
https://bz.apache.org/bugzilla/show_bug.cgi?id=66687 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from Dominik Stadler --- What is the use-case for using Apache POI in this way? I.e. can't you stick to SXSSF only? -- 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 66827] Exception on loading Excel xslx-file with cell comment
https://bz.apache.org/bugzilla/show_bug.cgi?id=66827 Dominik Stadler changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #8 from Dominik Stadler --- The workaround should be available since Apache POI 5.2.4. -- 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 68615] getSummaryInformation breaks document images
https://bz.apache.org/bugzilla/show_bug.cgi?id=68615 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from Dominik Stadler --- It seems reading the summary-information is not necessary, the following is sufficient to trigger this for me: try (HWPFDocument doc = new HWPFDocument(new FileInputStream("/tmp/file-sample_100kB.doc"))) { try (OutputStream outputStream = new FileOutputStream("/tmp/output.doc")) { doc.write(outputStream); } } Unfortunately support for doc/docx is not complete and no-one is actively working on it, so patches/fixes are highly welcome! -- 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 68615] getSummaryInformation breaks document images
https://bz.apache.org/bugzilla/show_bug.cgi?id=68615 Dominik Stadler changed: What|Removed |Added Summary|getSummaryInformation |getSummaryInformation |brokes document images |breaks document images -- 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 68714] Operator BETWEEN should work both ways
https://bz.apache.org/bugzilla/show_bug.cgi?id=68714 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from Dominik Stadler --- There is also a 2nd enum DataValidationEvaluator.OperatorEnum which might need similar adjustment. A test-case which verifies the fix would be good so we ensure it is staying this way in the future. -- 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 69127] The Cell style background is not applied when an input spreadsheet is used with all the cells in a non default style
https://bz.apache.org/bugzilla/show_bug.cgi?id=69127 Dominik Stadler changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WORKSFORME --- Comment #1 from Dominik Stadler --- In your sample code, you set "style2" for cell 3. If I change this to "style3", the cell color is as expected for me. Thus closing as WORKSFORME, please reopen if there is still a problem, but then please also attach a sample xlsx to make it easier to reproduce your exact 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 69265] Hyperlink type provided during hyperlink creation not same as the type retrieved from Cell.getHyperlink() or sheet.getHyperlinkList()
https://bz.apache.org/bugzilla/show_bug.cgi?id=69265 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #3 from Dominik Stadler --- What happens if you try to create a file with this type in Excel? Can you attach a sample file? It seems the spec for .xls files does not support type "Email", see "2.3.7.1 Hyperlink Object" in the spec document MS-OSHARED. Therefore Apache POI currently defaults to URL in this case. .xlsx (via XSSF and SXSSF) should support Email properly. -- 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 69315] PropertiesChunk.readProperties stops reading properties when a multi valued property is encountered
https://bz.apache.org/bugzilla/show_bug.cgi?id=69315 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from Dominik Stadler --- Can you share a sample file which can be used to verify as part of automated tests that it works? -- 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 68779] Mixed cell reference is being malformatted
https://bz.apache.org/bugzilla/show_bug.cgi?id=68779 PJ Fanning changed: What|Removed |Added Severity|critical|normal -- 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 69212] IndexOutOfBoundsException at DateUtil.isCellDateFormatted() method
https://bz.apache.org/bugzilla/show_bug.cgi?id=69212 Dominik Stadler changed: What|Removed |Added Resolution|--- |WORKSFORME Status|NEEDINFO|RESOLVED -- 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 68779] Mixed cell reference is being malformatted
https://bz.apache.org/bugzilla/show_bug.cgi?id=68779 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 69021] HSSF: Java.lang.ClassCastException: class org.apache.poi.hssf.record.DSFRecord cannot be cast to class org.apache.poi.hssf.record.TabIdRecord
https://bz.apache.org/bugzilla/show_bug.cgi?id=69021 Dominik Stadler changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #3 from Dominik Stadler --- This seems to be fixed, please report if a recent nightly build still does not work for you. -- 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 69178] ZipPartMarshaller uses hardcoded value for MS compatibility mode
https://bz.apache.org/bugzilla/show_bug.cgi?id=69178 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 69163] POITextExtractor appendText new feature
https://bz.apache.org/bugzilla/show_bug.cgi?id=69163 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 69212] IndexOutOfBoundsException at DateUtil.isCellDateFormatted() method
https://bz.apache.org/bugzilla/show_bug.cgi?id=69212 --- Comment #2 from Dominik Stadler --- No update, thus closing, please reopen with more information including a standalone reproducer-test-case if you still encounter this in a more recent version than the fairly outdated 3.x. -- 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 69267] Inconsistent Behavior in Grouping and Ungrouping Columns in Apache POI
https://bz.apache.org/bugzilla/show_bug.cgi?id=69267 Dominik Stadler changed: What|Removed |Added Component|POI Overall |SS Common -- 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 69294] Getting 'functionMetadata.txt' not found error in 5.2.5
https://bz.apache.org/bugzilla/show_bug.cgi?id=69294 Dominik Stadler changed: What|Removed |Added Resolution|--- |WORKSFORME Status|NEEDINFO|RESOLVED --- Comment #2 from Dominik Stadler --- This is likely nothing that can be fixed in Apache POI, thus closing this here for now, please use the mailing list or Stackoverflow for usage questions. -- 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 69315] PropertiesChunk.readProperties stops reading properties when a multi valued property is encountered
https://bz.apache.org/bugzilla/show_bug.cgi?id=69315 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 69324] Add AGGREGATE function like SUBTOTAL
https://bz.apache.org/bugzilla/show_bug.cgi?id=69324 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 69322] setting useTempFilePackageParts is true Cause an error: Fail to save: an error occurs while saving the package : arraycopy: destination index out of bounds
https://bz.apache.org/bugzilla/show_bug.cgi?id=69322 --- Comment #5 from lwd --- github address:https://github.com/a96219/TempFilePackagePartsError/blob/main/src/main/java/org/example/OPCPackageTest.java Set the JVM parameter - Xmx100M then run org.Example.OPCPackageTest.main method. Ran successfully but did not clean up temporary 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 69322] setting useTempFilePackageParts is true Cause an error: Fail to save: an error occurs while saving the package : arraycopy: destination index out of bounds
https://bz.apache.org/bugzilla/show_bug.cgi?id=69322 --- Comment #4 from lwd --- (In reply to PJ Fanning from comment #3) > In ran the test case on my Macbook and it worked ok. No exceptions and wrote > out the xlsx file. I made no modifications to the code to get it to work. Sorry, a description of jvm parameters is missing. I am testing the effect of useTempFilePackageParts=true on the jvm heap memory usage, which works fine when the jvm parameter -Xmx1000M is set, and the above error occurs when -Xmx100M is set. And I noticed that it worked fine when the jvm parameter -Xmx1000M was set, But by setting the TempFile as expected. SetTempFileCreationStrategy (new DefaultTempFileCreationStrategy (tempDir)); The temporary files in the specified temporary directory are not deleted correctly. In my example I use var wb = new SXSSFWorkbook(1) to build a blank excel file, and I end up calling this._wb = new XSSFWorkbook() to build a blank excel file. In the method of new XSSFWorkbook () used in newPackage (XSSFWorkbookType workbookType) method through UnsynchronizedByteArrayOutputStream constructs a in the memory OPCPackage object. I updated my example to add an OPCPackageTest class. In this class I first create a blank excel file and then open it through SXSSFWorkbook and write the relevant data. github address:https://github.com/a96219/TempFilePackagePartsError/blob/main/src/main/java/org/example/OPCPackageTest.java Set the JVM parameter - Xmx100M then run org. Example. OPCPackageTest. The main method. Ran successfully but did not clean up temporary 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 69324] Add AGGREGATE function like SUBTOTAL
https://bz.apache.org/bugzilla/show_bug.cgi?id=69324 --- Comment #2 from sfis...@gmail.com --- PJF: to be fair, there are use cases where the spreadsheet being processed by POI is treated as a System of Record, requiring POI to exercise calculations after inputs are modified. DR: part of what PJF is alluding to still holds though. i ran across the same issue sometime ago, and submitted a PR with the added functionality added. what you have come across is the generic "not yet implemented" error that occurs when POI exercises a function that has not been implemented yet. there are two ways to attack this: 1) there is a mechanism to "patch" the functional dictionary at runtime. you can do this but depending on the function in question, it can require a fair bit of baggage code (some of the functions rely on package protected/private semantics which i found infuriating, but that is a discussion for another day with a beer in hand) 2) you can submit a PR and have someone (more than likely PJF) review and merge. caveat emptor YMMV void where prohibited by law past gains are no guarantee of future returns -- 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 69324] Add AGGREGATE function like SUBTOTAL
https://bz.apache.org/bugzilla/show_bug.cgi?id=69324 PJ Fanning changed: What|Removed |Added OS||All --- Comment #1 from PJ Fanning --- POI is a volunteer project. No volunteer has a major interest in supporting every Excel function and all the permutations. Code contributions are welcome. Most users don't need POI to calculate the formulas. If you read an Excel file, the formula results are cached in the file and POI uses these. If you write an xlsx file using POI, you don't need to POI to calculate the values because Excel will when it reads the file. This might need this POI code. Workbook wb = ... wb.setForceFormulaRecalculation(true); -- 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 69324] New: Add AGGREGATE function like SUBTOTAL
https://bz.apache.org/bugzilla/show_bug.cgi?id=69324 Bug ID: 69324 Summary: Add AGGREGATE function like SUBTOTAL Product: POI Version: unspecified Hardware: PC Status: NEW Severity: normal Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: dre...@yahoo.com Target Milestone: --- AGGREGATE has more functionality than SUBTOTAL. The MIN/MAX functions do not adjust when a filter is applied to the data. Add support for AGGREGATE function. Current test case throws function not supported exception. AGGREGATE is similar to SUBTOTAL function. -- 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 69322] setting useTempFilePackageParts is true Cause an error: Fail to save: an error occurs while saving the package : arraycopy: destination index out of bounds
https://bz.apache.org/bugzilla/show_bug.cgi?id=69322 --- Comment #3 from PJ Fanning --- In ran the test case on my Macbook and it worked ok. No exceptions and wrote out the xlsx file. I made no modifications to the code to get it to work. -- 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 69322] setting useTempFilePackageParts is true Cause an error: Fail to save: an error occurs while saving the package : arraycopy: destination index out of bounds
https://bz.apache.org/bugzilla/show_bug.cgi?id=69322 --- Comment #2 from PJ Fanning --- It might be worth trying to test with an updated commons-compress (1.27.1) jar. poi-ooxml 5.2.0 uses the latest commons-io jar. -- 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 69322] setting useTempFilePackageParts is true Cause an error: Fail to save: an error occurs while saving the package : arraycopy: destination index out of bounds
https://bz.apache.org/bugzilla/show_bug.cgi?id=69322 --- Comment #1 from PJ Fanning --- Unfortunately, that exception seems to be happening in commons-io. commons-io is a different ASF project. All POI is doing is writing bytes to a commons-compress ZipArchiveOutputStream - and commons-compress is yet another different ASF project. -- 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 69323] Regression in commit 1def0cba38 , the poifiles tmp directory is expected to exist for the lifespan of the application
https://bz.apache.org/bugzilla/show_bug.cgi?id=69323 PJ Fanning changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #1 from PJ Fanning --- PR merged - 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 69323] New: Regression in commit 1def0cba38 , the poifiles tmp directory is expected to exist for the lifespan of the application
https://bz.apache.org/bugzilla/show_bug.cgi?id=69323 Bug ID: 69323 Summary: Regression in commit 1def0cba38 , the poifiles tmp directory is expected to exist for the lifespan of the application Product: POI Version: 5.3.0-FINAL Hardware: PC OS: Mac OS X 10.1 Status: NEW Severity: normal Priority: P2 Component: POI Overall Assignee: dev@poi.apache.org Reporter: gir...@gmail.com Target Milestone: --- It is common practise to let the operating system clean temp directories of old files. This would eventually clean out the poifiles directory if it hasn't been used for a while. The code introduced in commit 1def0cba387d8c869a371768ee3c1c3 introduces this problem by never even check if the directory still exists. For a web application, that usually has a lifespan of a number of weeks at least, this is a problem. I suggest partly reverting the change and at least have a check that cheks that the directory still exists. -- 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 69322] setting useTempFilePackageParts is true Cause an error: Fail to save: an error occurs while saving the package : arraycopy: destination index out of bounds
https://bz.apache.org/bugzilla/show_bug.cgi?id=69322 lwd changed: What|Removed |Added CC||a96219...@gmail.com 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 69322] New: setting useTempFilePackageParts is true Cause an error: Fail to save: an error occurs while saving the package : arraycopy: destination index out of bounds
https://bz.apache.org/bugzilla/show_bug.cgi?id=69322 Bug ID: 69322 Summary: setting useTempFilePackageParts is true Cause an error: Fail to save: an error occurs while saving the package : arraycopy: destination index out of bounds Product: POI Version: 5.3.0-FINAL Hardware: PC Status: NEW Severity: normal Priority: P2 Component: SXSSF Assignee: dev@poi.apache.org Reporter: a96219...@gmail.com Target Milestone: --- Enable the following Settings in the program ZipInputStreamZipEntrySource.setThresholdBytesForTempFiles(5000); ZipPackage.setUseTempFilePackageParts(true); Then export 200 images to excel xlsx file The following error occurred A test case was uploaded on github with the following repository address: https://github.com/a96219/TempFilePackagePartsError Running the org.example.Main.main method produces the following error: Exception in thread "main" org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : arraycopy: destination index -2331 out of bounds for byte[33554432] at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:604) at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1531) at org.apache.poi.openxml4j.opc.OPCPackage.close(OPCPackage.java:506) at org.apache.poi.ooxml.POIXMLDocument.close(POIXMLDocument.java:189) at org.apache.poi.xssf.usermodel.XSSFWorkbook.close(XSSFWorkbook.java:642) at org.apache.poi.xssf.streaming.SXSSFWorkbook.close(SXSSFWorkbook.java:936) at org.example.Main.main(Main.java:65) Caused by: java.lang.ArrayIndexOutOfBoundsException: arraycopy: destination index -2331 out of bounds for byte[33554432] at java.base/java.lang.System.arraycopy(Native Method) at org.apache.commons.io.output.AbstractByteArrayOutputStream.writeImpl(AbstractByteArrayOutputStream.java:332) at org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream.write(UnsynchronizedByteArrayOutputStream.java:207) at org.apache.commons.compress.archivers.zip.StreamCompressor$OutputStreamCompressor.writeOut(StreamCompressor.java:64) at org.apache.commons.compress.archivers.zip.StreamCompressor.writeCounted(StreamCompressor.java:305) at org.apache.commons.compress.archivers.zip.StreamCompressor.deflate(StreamCompressor.java:197) at org.apache.commons.compress.archivers.zip.StreamCompressor.flushDeflater(StreamCompressor.java:230) at org.apache.commons.compress.archivers.zip.ZipArchiveOutputStream.flushDeflater(ZipArchiveOutputStream.java:983) at org.apache.commons.compress.archivers.zip.ZipArchiveOutputStream.closeArchiveEntry(ZipArchiveOutputStream.java:585) at org.apache.poi.openxml4j.opc.internal.marshallers.ZipPartMarshaller.marshall(ZipPartMarshaller.java:93) at org.apache.poi.openxml4j.opc.internal.TempFilePackagePart.save(TempFilePackagePart.java:117) at org.apache.poi.openxml4j.opc.internal.marshallers.DefaultMarshaller.marshall(DefaultMarshaller.java:46) at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:590) ... 6 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
[Bug 69209] get rid of ignoreMissingFontSystem property and just be lax?
https://bz.apache.org/bugzilla/show_bug.cgi?id=69209 PJ Fanning changed: What|Removed |Added Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #1 from PJ Fanning --- I kept ignoreMissingFontSystem but it now defaults to true. Change will appear in POI 5.3.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 68094] In 5.2.4 After called autoSizeColumn function, the returned column width is smaller than in 5.2.3, which makes the columns to be cut off
https://bz.apache.org/bugzilla/show_bug.cgi?id=68094 --- Comment #15 from PJ Fanning --- https://github.com/apache/poi/pull/657 will appear in v5.3.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 68094] In 5.2.4 After called autoSizeColumn function, the returned column width is smaller than in 5.2.3, which makes the columns to be cut off
https://bz.apache.org/bugzilla/show_bug.cgi?id=68094 PJ Fanning changed: What|Removed |Added CC||elena.alexandrova@betanxt.c ||om --- Comment #14 from PJ Fanning --- *** Bug 69321 has been marked as a duplicate of this bug. *** -- 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 69321] The sheet columns not auto sized in v.5.3.0
https://bz.apache.org/bugzilla/show_bug.cgi?id=69321 PJ Fanning changed: What|Removed |Added Resolution|--- |DUPLICATE Status|NEW |RESOLVED OS||All --- Comment #1 from PJ Fanning --- *** This bug has been marked as a duplicate of bug 68094 *** -- 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 69321] New: The sheet columns not auto sized in v.5.3.0
https://bz.apache.org/bugzilla/show_bug.cgi?id=69321 Bug ID: 69321 Summary: The sheet columns not auto sized in v.5.3.0 Product: POI Version: 5.3.0-FINAL Hardware: PC Status: NEW Severity: normal Priority: P2 Component: POI Overall Assignee: dev@poi.apache.org Reporter: elena.alexandr...@betanxt.com Target Milestone: --- The following method doesn't work properly in the v. 5.3.0: sheet.trackAllColumnsForAutoSizing(); The sheet columns not auto sized in the generated .xlsx file. I use SXSSFWorkbook and SXSSFSheet classes. When I switched back to version 5.2.3, the sheet columns were auto-sized. implementation 'org.apache.poi:poi:5.2.3' implementation 'org.apache.poi:poi-ooxml:5.2.3' -- 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 69314] Header content from a specific .doc not extracted (TIKA-4307)
https://bz.apache.org/bugzilla/show_bug.cgi?id=69314 August <4u6...@gmail.com> changed: What|Removed |Added CC||4u6...@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 69314] Header content from a specific .doc not extracted (TIKA-4307)
https://bz.apache.org/bugzilla/show_bug.cgi?id=69314 Tim Allison changed: What|Removed |Added Summary|Header content from .doc|Header content from a |not extracted |specific .doc not extracted ||(TIKA-4307) -- 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 69314] New: Header content from .doc not extracted
https://bz.apache.org/bugzilla/show_bug.cgi?id=69314 Bug ID: 69314 Summary: Header content from .doc not extracted Product: POI Version: 5.2.3-FINAL Hardware: PC OS: Linux Status: NEW Severity: normal Priority: P2 Component: HWPF Assignee: dev@poi.apache.org Reporter: talli...@apache.org Target Milestone: --- Over on https://issues.apache.org/jira/browse/TIKA-4307, August Valera shared a .doc file whose header content is not being extracted. The content is extracted when he converts the .doc to a .docx, and I can see the content when I open the file in LibreOffice. The debug logging file that August shared shows that POI identifies some issues during the initial parse -- there may just be problems with the file. I can confirm through the debugger that the content is in the document string, but the ranges for the HeaderStories do not seem to include the header content. Any help would be appreciated. Thank you! -- 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 69308] Best Software for a Pest Control Company
https://bz.apache.org/bugzilla/show_bug.cgi?id=69308 PJ Fanning changed: What|Removed |Added Resolution|--- |INVALID Status|NEW |RESOLVED -- 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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 Henry changed: What|Removed |Added Resolution|INVALID |FIXED --- Comment #16 from Henry --- (In reply to PJ Fanning from comment #14) > Weblogic might rely on an older version of commons-io and this might > conflict with the newer version of commons-io needed by POI. > My understanding is that you can specify 'Parent Last' classloading when > deploying so that your webapps use the jars that you choose in preference to > the ones that Weblogic defaults to. > > https://stackoverflow.com/questions/31583968/how-to-specify-order-of-jar- > class-loading-in-weblogic this is correct. I made the appropriate changes to the weblogic.xml file and it worked properly. Wblogic 12.2.1.4.0 === org.slf4j.* org.apache.commons.collections4.* org.apache.commons.compress.* org.apache.poi.* org.apache.xmlbeans.* org.openxmlformats.* org.apache.commons.io.* org.apache.xmlbeans.* schemaorg_apache_xmlbeans.* schemaorg_apache_xmlbeans/system/sXMLCONFIG/TypeSystemHolder.class schemaorg_apache_xmlbeans/system/sXMLLANG/TypeSystemHolder.class schemaorg_apache_xmlbeans/system/sXMLSCHEMA/TypeSystemHolder.class schemaorg_apache_xmlbeans/system/sXMLTOOLS/TypeSystemHolder.class 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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 Axel Howind changed: What|Removed |Added Resolution|--- |INVALID Status|REOPENED|RESOLVED -- 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 63665] Drop down's options don't appear when clicking arrow in excel exported with Apache POI when there are many cell comments
https://bz.apache.org/bugzilla/show_bug.cgi?id=63665 Dominik Stadler changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |WORKSFORME --- Comment #1 from Dominik Stadler --- Just tried this with a recent version of Microsoft Excel. I did see the "Yes/No" DropDown, so maybe Microsoft fixed this at some point. CLosing this for now, please re-open with more information and reproducer steps if this is still an issue for you. -- 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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 --- Comment #14 from PJ Fanning --- Weblogic might rely on an older version of commons-io and this might conflict with the newer version of commons-io needed by POI. My understanding is that you can specify 'Parent Last' classloading when deploying so that your webapps use the jars that you choose in preference to the ones that Weblogic defaults to. https://stackoverflow.com/questions/31583968/how-to-specify-order-of-jar-class-loading-in-weblogic -- 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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 --- Comment #11 from Axel Howind --- Can you re-check the attached source? This does not seem to be compilable: logger.error("inicia crearexcel"); try { workbook = new XSSFWorkbook(); logger.info("inicia crearexcel 1 error runtime" + e.getMessage(), e ); //Not write in log server } catch (RuntimeException e){ logger.info("inicia crearexcel 1 error runtime" + e.getMessage(), e ); //Not write in log server } catch(Exception e ){ logger.info("inicia crearexcel 1 error " +e.getMessage(), e ); //Not write in log server } finally{ logger.info("finally crear instabncia XSSFWorkbook " ); //write in log server } logger.error("inicia crearexcel 1"); //Not write in log server but it should do it I assume you only use error level for logging to make sure the log messages show. Anyway, inside the try-block, you use `e` which does not seem to be initialised, at least there is neither declaration nor assignment visible. In the following catch, you declare e (`catch RuntimeException e`), which should give a compile time error if `e` were already declared in the scope. So if this is not a snippet of your actual code, it will be difficult to find out what's wrong. Maybe you could try to create a minimal compilable example code that exhibits the problem? -- 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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 --- Comment #10 from sfis...@gmail.com --- your stack trace indicates that the application is running inside weblogic. have you ruled out a conflict with any/all the bundled libraries that an EE container brings into the environment. it is a well known and established practice to perform forensics with regard to library conflicts when bundling a large application for deployment on an EE container. -- 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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 Henry changed: What|Removed |Added Status|RESOLVED|REOPENED Resolution|INFORMATIONPROVIDED |--- --- Comment #9 from Henry --- I have verified that I am using the correct libraries based on https://poi.apache.org/changes.html for version 5.2.4 (commons-io-2-13-0) I uploaded the version to 2.16.1, as you indicate, and it still shows the same error message -- 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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 PJ Fanning changed: What|Removed |Added Resolution|--- |INFORMATIONPROVIDED Status|NEW |RESOLVED --- Comment #8 from PJ Fanning --- POI needs commons-io 2.16.1. https://poi.apache.org/changes.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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 Henry changed: What|Removed |Added Status|NEEDINFO|NEW -- 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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 --- Comment #7 from Henry --- Created attachment 39862 --> https://bz.apache.org/bugzilla/attachment.cgi?id=39862&action=edit stack_trace.txt stacktrace 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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 --- Comment #6 from Henry --- Got stacktrace with catching Throwable Error : org.apache.commons.io.output.UnsynchronizedByteArrayOutputStream.builder()Lorg/apache/commons/io/output/UnsynchronizedByteArrayOutputStream$Builder; Consider that I am using commons-io.2.13.0 I attached stacktrace file (stack_trace.txt) -- 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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 --- Comment #5 from PJ Fanning --- Why don't you try catching Throwable? Even for debugging purposes. Btw this is not a bug, it is a request for random people to debug your code for you and that is not what bugzilla is for. -- 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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 --- Comment #4 from Henry --- (In reply to PJ Fanning from comment #3) > can you provide the actual stack trace? > > Are you using a build tool - eg Gradle? Build tools are good at sorting out > dependencies. -this is not possible, it never enters the "catch" only the "finally" of the try/catch/finally block -we use maven, I also attached the list of dependencies used, and there are those indicated by apache-poi documentation for version 5.2.4 -- 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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 PJ Fanning changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #3 from PJ Fanning --- can you provide the actual stack trace? Are you using a build tool - eg Gradle? Build tools are good at sorting out dependencies. -- 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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 --- Comment #2 from Henry --- Java version openjdk version "1.8.0_402" OpenJDK Runtime Environment (build 1.8.0_402-b06) OpenJDK 64-Bit Server VM (build 25.402-b06, mixed mode) -- 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 69304] error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 --- Comment #1 from Henry --- Created attachment 39861 --> https://bz.apache.org/bugzilla/attachment.cgi?id=39861&action=edit part of the source 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 69304] New: error creating an instance of XSSFWorkbook
https://bz.apache.org/bugzilla/show_bug.cgi?id=69304 Bug ID: 69304 Summary: error creating an instance of XSSFWorkbook Product: POI Version: unspecified Hardware: Other OS: Linux Status: NEW Severity: major Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: hens...@hotmail.com Target Milestone: --- Created attachment 39860 --> https://bz.apache.org/bugzilla/attachment.cgi?id=39860&action=edit list_dependency When I instantiate the XSSFWorkbook class, an error occurs that is not caught by any try/catch/exception. This only allows you to enter the "finally" section but not the catch. I have verified that I am using the correct libraries based on https://poi.apache.org/changes.html for version 5.2.4 I have verified that I am using the correct libraries based on https://poi.apache.org/changes.html for version 5.2.4 I attach file list_dependency.txt, with the list of libraries used -- 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 69303] RangeCopier.copyRange doesn't check merged ranges
https://bz.apache.org/bugzilla/show_bug.cgi?id=69303 Piotr Wilkin changed: What|Removed |Added OS||All CC||piotr.wil...@syndatis.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 69303] New: RangeCopier.copyRange doesn't check merged ranges
https://bz.apache.org/bugzilla/show_bug.cgi?id=69303 Bug ID: 69303 Summary: RangeCopier.copyRange doesn't check merged ranges Product: POI Version: 5.2.3-FINAL Hardware: PC Status: NEW Severity: normal Priority: P2 Component: SS Common Assignee: dev@poi.apache.org Reporter: piotr.wil...@syndatis.com Target Milestone: --- If you use RangeCopier to copy ranges within the same spreadsheet and there's at least one merged range, it will fail because copyRange does not check if the merged range is within the tilePatternRage. -- 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 59687] XSSFSheet.RemoveRow doesn't handle row gaps properly when removing row comments (typo)
https://bz.apache.org/bugzilla/show_bug.cgi?id=59687 --- Comment #2 from Godrej Tiara --- Your take on this subject is truly refreshing. It adds a new layer of understanding to the conversation. Well done! https://www.godrejtiara.info/ -- 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 69266] File Corruption when Modifying Page Setup in Existing .xlsx Sheets
https://bz.apache.org/bugzilla/show_bug.cgi?id=69266 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from Dominik Stadler --- Can you please specify which version of Apache POI you are using. If not the latest one, does it still happen with the latest version 5.3.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 68778] POI 3.5.4 "Fontconfig head is null, check your fonts or fonts configuration"
https://bz.apache.org/bugzilla/show_bug.cgi?id=68778 --- Comment #13 from Hani Naguib --- Not sure this is related by I get the same exception although with a different call stack. java.lang.RuntimeException: Fontconfig head is null, check your fonts or fonts configuration at java.desktop/sun.awt.FontConfiguration.getVersion(Unknown Source) ~[na:na] at java.desktop/sun.awt.FontConfiguration.readFontConfigFile(Unknown Source) ~[na:na] at java.desktop/sun.awt.FontConfiguration.init(Unknown Source) ~[na:na] at java.desktop/sun.awt.X11FontManager.createFontConfiguration(Unknown Source) ~[na:na] at java.desktop/sun.font.SunFontManager$2.run(Unknown Source) ~[na:na] at java.desktop/sun.font.SunFontManager$2.run(Unknown Source) ~[na:na] at java.base/java.security.AccessController.doPrivileged(Unknown Source) ~[na:na] at java.desktop/sun.font.SunFontManager.(Unknown Source) ~[na:na] at java.desktop/sun.awt.FcFontManager.(Unknown Source) ~[na:na] at java.desktop/sun.awt.X11FontManager.(Unknown Source) ~[na:na] at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:na] at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) ~[na:na] at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) ~[na:na] at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Unknown Source) ~[na:na] at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source) ~[na:na] at java.desktop/sun.font.FontManagerFactory$1.run(Unknown Source) ~[na:na] at java.base/java.security.AccessController.doPrivileged(Unknown Source) ~[na:na] at java.desktop/sun.font.FontManagerFactory.getInstance(Unknown Source) ~[na:na] at java.desktop/java.awt.Font.getFont2D(Unknown Source) ~[na:na] at java.desktop/java.awt.Font.canDisplayUpTo(Unknown Source) ~[na:na] at java.desktop/java.awt.font.TextLayout.singleFont(Unknown Source) ~[na:na] at java.desktop/java.awt.font.TextLayout.(Unknown Source) ~[na:na] at org.apache.poi.ss.util.SheetUtil.getCellWidth(SheetUtil.java:262) ~[poi-5.3.0.jar:5.3.0] at org.apache.poi.ss.util.SheetUtil.getCellWidth(SheetUtil.java:223) ~[poi-5.3.0.jar:5.3.0] at org.apache.poi.ss.util.SheetUtil.getColumnWidthForRow(SheetUtil.java:399) ~[poi-5.3.0.jar:5.3.0] at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:318) ~[poi-5.3.0.jar:5.3.0] at org.apache.poi.ss.util.SheetUtil.getColumnWidth(SheetUtil.java:295) ~[poi-5.3.0.jar:5.3.0] at org.apache.poi.xssf.usermodel.XSSFSheet.autoSizeColumn(XSSFSheet.java:497) ~[poi-ooxml-5.3.0.jar:5.3.0] at org.apache.poi.xssf.usermodel.XSSFSheet.autoSizeColumn(XSSFSheet.java:479) ~[poi-ooxml-5.3.0.jar:5.3.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 69294] Getting 'functionMetadata.txt' not found error in 5.2.5
https://bz.apache.org/bugzilla/show_bug.cgi?id=69294 PJ Fanning changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from PJ Fanning --- We publish jars and they have this file in it. If you don't want to use the jars that we produce then use Gradle to build from source. https://poi.apache.org/devel/index.html If you have more complicated, non-standard build needs - then use stackoverflow.com to ask questions about those build tools. -- 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 69294] Getting 'functionMetadata.txt' not found error in 5.2.5
https://bz.apache.org/bugzilla/show_bug.cgi?id=69294 Rakhi Barayanan changed: What|Removed |Added Severity|normal |critical -- 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 69294] New: Getting 'functionMetadata.txt' not found error in 5.2.5
https://bz.apache.org/bugzilla/show_bug.cgi?id=69294 Bug ID: 69294 Summary: Getting 'functionMetadata.txt' not found error in 5.2.5 Product: POI Version: 5.3.0-FINAL Hardware: PC OS: Linux Status: NEW Severity: normal Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: rakhi.naraya...@gmail.com Target Milestone: --- I am getting the following error java.lang.IllegalStateException: resource 'functionMetadata.txt' not found org.apache.poi.ss.formula.function.FunctionMetadataReader.readResourceFile(FunctionMetadataReader.java:88) org.apache.poi.ss.formula.function.FunctionMetadataReader.createRegistry(FunctionMetadataReader.java:75) org.apache.poi.ss.formula.function.FunctionMetadataRegistry.getInstance(FunctionMetadataRegistry.java:46) org.apache.poi.ss.formula.function.FunctionMetadataRegistry.lookupIndexByName(FunctionMetadataRegistry.java:86) org.apache.poi.ss.formula.ptg.AbstractFunctionPtg.isBuiltInFunctionName(AbstractFunctionPtg.java:124) org.apache.poi.ss.formula.FormulaParser.function(FormulaParser.java:1338) org.apache.poi.ss.formula.FormulaParser.parseNonRange(FormulaParser.java:927) org.apache.poi.ss.formula.FormulaParser.parseRangeable(FormulaParser.java:583) org.apache.poi.ss.formula.FormulaParser.parseRangeExpression(FormulaParser.java:327) org.apache.poi.ss.formula.FormulaParser.parseSimpleFactor(FormulaParser.java:1579) org.apache.poi.ss.formula.FormulaParser.percentFactor(FormulaParser.java:1537) org.apache.poi.ss.formula.FormulaParser.powerFactor(FormulaParser.java:1524) org.apache.poi.ss.formula.FormulaParser.Term(FormulaParser.java:1898) org.apache.poi.ss.formula.FormulaParser.additiveExpression(FormulaParser.java:2025) org.apache.poi.ss.formula.FormulaParser.concatExpression(FormulaParser.java:2009) org.apache.poi.ss.formula.FormulaParser.comparisonExpression(FormulaParser.java:1966) org.apache.poi.ss.formula.FormulaParser.intersectionExpression(FormulaParser.java:1939) org.apache.poi.ss.formula.FormulaParser.unionExpression(FormulaParser.java:1920) org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:2067) org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:175) org.apache.poi.xssf.usermodel.XSSFCell.convertSharedFormula(XSSFCell.java:449) org.apache.poi.xssf.usermodel.XSSFCell.getCellFormula(XSSFCell.java:418) org.apache.poi.xssf.usermodel.XSSFCell.getCellFormula(XSSFCell.java:391) com.peoplesoft.pt.psspreadsheet.impl.PSFTWorkBookImpl.loadFormulas(PSFTWorkBookImpl.java:233) com.peoplesoft.pt.psspreadsheet.WorkbookManager.loadFormulas(WorkbookManager.java:183) com.peoplesoft.pt.psspreadsheet.WorkbookManager.openWorkbook(WorkbookManager.java:217) I could find the txt file exist in my source code,but after creating the jar and used it in generating excel..this is coming as a runtime exception.But this work fine if I use the jar directly from the poi site. -- 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 69288] SXSSFSheet constructor unnecessarily rethrows NoClassDefFoundError on Android
https://bz.apache.org/bugzilla/show_bug.cgi?id=69288 Dominik Stadler changed: What|Removed |Added Resolution|--- |WONTFIX Status|NEW |RESOLVED --- Comment #5 from Dominik Stadler --- Thanks for the idea, the poi-on-android project now incorporated this idea to make SXSSF bascially work, see https://github.com/centic9/poi-on-android/commit/d309159aabd3ea3a8d85282db509cbdf6fb0be65 Closing this here then. -- 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 69288] SXSSFSheet constructor unnecessarily rethrows NoClassDefFoundError on Android
https://bz.apache.org/bugzilla/show_bug.cgi?id=69288 --- Comment #4 from samo.re...@gmail.com --- Wait, I found a funny workaround. I created three mock files: AffineTransform.java > package java.awt.geom; > > import java.awt.font.FontRenderContext; > > /** > * Just an empty class, so we can have a correct {@link FontRenderContext} > constructor > */ > public class AffineTransform { > > } FontRenderContext.java > package java.awt.font; > > import java.awt.geom.AffineTransform; > > public class FontRenderContext { > public FontRenderContext(AffineTransform o, boolean a, boolean b) { > //You can't crash here yet! If you do, a static field in SheetUtil > will fail to load. > //Then next time SheetUtil will have to be accessed, a > NoClassDefFoundError("SheetUtil") > //will be thrown! > } > } TextLayout.java > package java.awt.font; > > import java.text.AttributedCharacterIterator; > > public class TextLayout { > public TextLayout(AttributedCharacterIterator iterator, FontRenderContext > fontRenderContext) { > //This is called in: > //SXSSFSheet.java:106 > //AutoSizeColumnTracker.java:117 > //SheetUtil.java:353 > //This tricks SXSSFSheet constructor into not creating > AutoSizeColumnTracker. > throw new NoClassDefFoundError("X11FontManager"); > } > } It works. The comments in FontRenderContext mean that the my previous proposed fix of changing the if condition probably won't work. And as far as I'm concerned, this fully solves our issue. If someone else stumbles upon this thread, the code will hopefully help them. -- 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 69288] SXSSFSheet constructor unnecessarily rethrows NoClassDefFoundError on Android
https://bz.apache.org/bugzilla/show_bug.cgi?id=69288 Dominik Stadler changed: What|Removed |Added Status|NEEDINFO|NEW --- Comment #3 from Dominik Stadler --- I will take a look at adjusting the if for future versions. FYI, LePat/poi-on-android is a fork of the original repository centic9/poi-on-android which is more up-to-date. See https://github.com/centic9/poi-on-android/issues/89#issuecomment-946851257 for the summary why the changes from the repository of LePat were not integrated. -- 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 69288] SXSSFSheet constructor unnecessarily rethrows NoClassDefFoundError on Android
https://bz.apache.org/bugzilla/show_bug.cgi?id=69288 --- Comment #2 from samo.re...@gmail.com --- > https://github.com/centic9/poi-on-android/ I am aware of that project. We don't use it anymore though. It's a bit finicky to get it to work, especially the shadowJar Gradle plugin. It turns out XLSX import/export works well without it anyway. You only need to use the Aalto XML library and run these commands: System.setProperty( "org.apache.poi.javax.xml.stream.XMLInputFactory", "com.fasterxml.aalto.stax.InputFactoryImpl" ); System.setProperty( "org.apache.poi.javax.xml.stream.XMLOutputFactory", "com.fasterxml.aalto.stax.OutputFactoryImpl" ); System.setProperty( "org.apache.poi.javax.xml.stream.XMLEventFactory", "com.fasterxml.aalto.stax.EventFactoryImpl" ); > Can you state which version of POI you use and how you run Apache POI on > Android here? This is our version catalog. I just upgraded from 5.2.5 to 5.3.0. The issue persists though. aalto-xml = { module = "com.fasterxml:aalto-xml", version = "1.3.3" } poi-ooxml = { module = "org.apache.poi:poi-ooxml", version = "5.3.0" } xmlbeans = { module = "org.apache.xmlbeans:xmlbeans", version = "5.2.1" } I found this commit that claims to fix the issue of the missing FontRenderContext class: https://github.com/LePat/poi-on-android/commit/d38372bd33860088c533f0838ee8830b3a945859 But I'm not sure how they got it to work - it seems like java.awt.geom.AffineTransform class is still missing. Given that: 1) POI works well on Android without issues 2) We can set column widths statically 3) The commit above claims to have fixed the NoClassDefFoundError error It seems like only changing the if condition on SXSSFSheet.java:111 would fix the streaming APIs on Android. Maybe the new condition could even be if(!e.getMessage().contains(".awt."))? -- 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 69288] SXSSFSheet constructor unnecessarily rethrows NoClassDefFoundError on Android
https://bz.apache.org/bugzilla/show_bug.cgi?id=69288 Dominik Stadler changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from Dominik Stadler --- Thanks for the detailed note, sounds like something that we can easily adjust here. But please note that Apache POI is not officially supported on Android because there are a number of additional pitfalls you may encounter due to missing or different APIs there. Can you state which version of POI you use and how you run Apache POI on Android here? FYI, there is a project at https://github.com/centic9/poi-on-android/ which shows how some things can be circumvented, but even there not everything is handled fully. -- 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 69288] New: SXSSFSheet constructor unnecessarily rethrows NoClassDefFoundError on Android
https://bz.apache.org/bugzilla/show_bug.cgi?id=69288 Bug ID: 69288 Summary: SXSSFSheet constructor unnecessarily rethrows NoClassDefFoundError on Android Product: POI Version: unspecified Hardware: Other OS: other Status: NEW Severity: normal Priority: P2 Component: SXSSF Assignee: dev@poi.apache.org Reporter: samo.re...@gmail.com Target Milestone: --- In the SXSSFSheet constructor, there is this line: _autoSizeColumnTracker = new AutoSizeColumnTracker(this); On Android this throws NoClassDefFoundError: java.lang.NoClassDefFoundError: Failed resolution of: Ljava/awt/font/FontRenderContext; at org.apache.poi.ss.util.SheetUtil.(SheetUtil.java:98) at org.apache.poi.xssf.streaming.AutoSizeColumnTracker.(AutoSizeColumnTracker.java:117) at org.apache.poi.xssf.streaming.SXSSFSheet.(SXSSFSheet.java:106) at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:694) at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:688) ... This is understandable, Android doesn't have AWT classes. There is a try/catch around this line, but the check inside is probably too strict: try { _autoSizeColumnTracker = new AutoSizeColumnTracker(this); } catch (UnsatisfiedLinkError | NoClassDefFoundError | InternalError | // thrown when no fonts are available in the workbook IndexOutOfBoundsException e) { // only handle special NoClassDefFound if (!e.getMessage().contains("X11FontManager")) { // close temporary resources when throwing exception in the constructor _writer.close(); throw e; } LOG.atWarn() .withThrowable(e) .log("Failed to create AutoSizeColumnTracker, possibly due to fonts not being installed in your OS"); } The exception is caught, but then rethrown. If the if condition was changed to: if (!e.getMessage().contains("X11FontManager") && !e.getMessage().contains("FontRenderContext")) { then we might be able to use the streaming APIs on Android. -- 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 69277] Issue with Date Validation in HSSF (.xls) Files
https://bz.apache.org/bugzilla/show_bug.cgi?id=69277 Matafagafo changed: What|Removed |Added CC||matafag...@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 69277] New: Issue with Date Validation in HSSF (.xls) Files
https://bz.apache.org/bugzilla/show_bug.cgi?id=69277 Bug ID: 69277 Summary: Issue with Date Validation in HSSF (.xls) Files Product: POI Version: unspecified Hardware: PC OS: Mac OS X 10.1 Status: NEW Severity: normal Priority: P2 Component: HSSF Assignee: dev@poi.apache.org Reporter: nikknp.du...@gmail.com Target Milestone: --- I have encountered an issue while attempting to apply date validation constraints in HSSF (.xls) files using the Apache POI library. When creating a date validation using the DataValidationHelper.createDateConstraint method, the validation fails with an error: “Failed to parse date using specified format.” This error occurs despite using valid date formats and properly converting dates to Excel’s numeric format. While the same code functions correctly in XSSF (.xlsx) files, it seems that HSSF does not correctly handle date formats or the underlying numeric representation of dates when setting up data validation. This issue affects the ability to create consistent date validation across .xls and .xlsx files, which is critical for applications that need to support both formats. I would appreciate it if this issue could be investigated and addressed in future releases. Thank you for your attention to this matter. Exception - Exception in thread "main" java.lang.RuntimeException: Failed to parse date '45292.0' using specified format 'java.text.SimpleDateFormat@f67a0200' at org.apache.poi.hssf.usermodel.DVConstraint.convertDate(DVConstraint.java:263) at org.apache.poi.hssf.usermodel.DVConstraint.createDateConstraint(DVConstraint.java:192) at org.apache.poi.hssf.usermodel.HSSFDataValidationHelper.createDateConstraint(HSSFDataValidationHelper.java:47) at coldfusion.excel.Driver.main(Driver.java:52) Caused by: java.text.ParseException: Unparseable date: "45292.0" at java.base/java.text.DateFormat.parse(DateFormat.java:399) at org.apache.poi.hssf.usermodel.DVConstraint.convertDate(DVConstraint.java:261) ... 3 more Code to reproduce - public static void main(String[] args) throws ParseException { // Create a new workbook and sheet HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet("Hyperlink Example"); // Create a row and a cell HSSFRow row = sheet.createRow(0); HSSFCell cell = row.createCell(0); // Create a hyperlink CreationHelper createHelper = workbook.getCreationHelper(); Hyperlink hyperlink = createHelper.createHyperlink(HyperlinkType.EMAIL); hyperlink.setLabel("mylabel"); hyperlink.setAddress("http://www.example.com";); DataValidationHelper validationHelper = sheet.getDataValidationHelper(); // Set the date format you want String dateFormat = "-MM-dd"; SimpleDateFormat sdf = new SimpleDateFormat(dateFormat); // Define start and end dates for validation String startDate = "2024-01-01"; String endDate = "2024-12-31"; // Convert dates to Excel date values using DateUtil double startDateExcel = DateUtil.getExcelDate(sdf.parse(startDate)); double endDateExcel = DateUtil.getExcelDate(sdf.parse(endDate)); // Create the data validation constraint DataValidationConstraint constraint = validationHelper.createDateConstraint( OperatorType.BETWEEN, String.valueOf(startDateExcel), String.valueOf(endDateExcel), dateFormat ); // Define the cell range to apply the validation (e.g., A1:A10) CellRangeAddressList addressList = new CellRangeAddressList(0, 9, 0, 0); // Create the data validation object DataValidation validation = validationHelper.createValidation(constraint, addressList); // Add the validation to the sheet sheet.addValidationData(validation); // Set the label and the hyperlink cell.setCellValue("Click here"); cell.setHyperlink(hyperlink); // Get the cell value and hyperlink address String cellValue = cell.getStringCellValue(); Hyperlink cellHyperlink = cell.getHyperlink(); String hyperlinkAddress = cellHyperlink.getAddress(); HyperlinkType hyperlinkType = cellHyperlink.getType(); System.out.println("Cell Value: " + cellValue); System.out.println("Hyperlink Address: " + hyperlinkAddress); System.out.println("Hyperlink type: " + hyperlinkType.toString()); // even though I gave type as Email in line 35, hyperlink type shows as URL here System.out.println("Hyperlink label: " + cellHyperlink.getLabel());
[Bug 69265] Hyperlink type provided during hyperlink creation not same as the type retrieved from Cell.getHyperlink() or sheet.getHyperlinkList()
https://bz.apache.org/bugzilla/show_bug.cgi?id=69265 nikknp.du...@gmail.com changed: What|Removed |Added Status|NEEDINFO|NEW -- 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 69265] Hyperlink type provided during hyperlink creation not same as the type retrieved from Cell.getHyperlink() or sheet.getHyperlinkList()
https://bz.apache.org/bugzilla/show_bug.cgi?id=69265 --- Comment #2 from nikknp.du...@gmail.com --- Code to reproduce - public class Driver { public static void main(String[] args) { // Create a new workbook and sheet HSSFWorkbook workbook = new HSSFWorkbook(); HSSFSheet sheet = workbook.createSheet("Hyperlink Example"); // Create a row and a cell HSSFRow row = sheet.createRow(0); HSSFCell cell = row.createCell(0); // Create a hyperlink CreationHelper createHelper = workbook.getCreationHelper(); Hyperlink hyperlink = createHelper.createHyperlink(HyperlinkType.EMAIL); hyperlink.setLabel("mylabel"); hyperlink.setAddress("http://www.example.com";); // Set the label and the hyperlink cell.setCellValue("Click here"); cell.setHyperlink(hyperlink); // Get the cell value and hyperlink address String cellValue = cell.getStringCellValue(); Hyperlink cellHyperlink = cell.getHyperlink(); String hyperlinkAddress = cellHyperlink.getAddress(); HyperlinkType hyperlinkType = cellHyperlink.getType(); System.out.println("Cell Value: " + cellValue); System.out.println("Hyperlink Address: " + hyperlinkAddress); System.out.println("Hyperlink type: " + hyperlinkType.toString()); // even though I gave type as Email in line 35, hyperlink type shows as URL here System.out.println("Hyperlink label: " + cellHyperlink.getLabel()); } } -- 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 69267] New: Inconsistent Behavior in Grouping and Ungrouping Columns in Apache POI
https://bz.apache.org/bugzilla/show_bug.cgi?id=69267 Bug ID: 69267 Summary: Inconsistent Behavior in Grouping and Ungrouping Columns in Apache POI Product: POI Version: unspecified Hardware: PC OS: Mac OS X 10.1 Status: NEW Severity: normal Priority: P2 Component: POI Overall Assignee: dev@poi.apache.org Reporter: nikknp.du...@gmail.com Target Milestone: --- I encountered an issue while working with Apache POI to programmatically group and ungroup columns in an Excel sheet. The problem arises when attempting to first group multiple sets of columns (e.g., columns 1-3, 7-10, and 10-11) and then ungroup them immediately afterward. Despite using the ungroupColumn method to remove the grouping, the resulting Excel file still shows grouped columns or exhibits unexpected behavior, such as the persistence of collapsed groups or partial ungrouping. The expected behavior is that the resulting file should have no grouped columns after the ungrouping operation is applied. This issue impacts the accuracy and reliability of generating Excel files with dynamic grouping and ungrouping requirements. The code used to reproduce this issue is as follows: import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import java.io.FileOutputStream; import java.io.IOException; public class GroupUngroupColumnsExample { public static void main(String[] args) { // Create a new workbook and a sheet Workbook workbook = new XSSFWorkbook(); Sheet sheet = workbook.createSheet("Example Sheet"); // Group columns 1-3 (index 0-2) sheet.groupColumn(0, 2); // Group columns 7-10 (index 6-9) sheet.groupColumn(6, 9); // Group columns 10-11 (index 9-10) sheet.groupColumn(9, 10); // Now ungroup the columns // Ungroup columns 1-3 (index 0-2) sheet.ungroupColumn(0, 2); // Ungroup columns 7-10 (index 6-9) sheet.ungroupColumn(6, 9); // Ungroup columns 10-11 (index 9-10) sheet.ungroupColumn(9, 10); // Write the output to a file try (FileOutputStream fileOut = new FileOutputStream("UngroupedColumns.xlsx")) { workbook.write(fileOut); } catch (IOException e) { e.printStackTrace(); } // Close the workbook try { workbook.close(); } catch (IOException e) { e.printStackTrace(); } System.out.println("Excel file generated successfully."); } } -- 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 69265] Hyperlink type provided during hyperlink creation not same as the type retrieved from Cell.getHyperlink() or sheet.getHyperlinkList()
https://bz.apache.org/bugzilla/show_bug.cgi?id=69265 Matafagafo changed: What|Removed |Added CC||matafag...@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 69266] File Corruption when Modifying Page Setup in Existing .xlsx Sheets
https://bz.apache.org/bugzilla/show_bug.cgi?id=69266 Matafagafo changed: What|Removed |Added CC||matafag...@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 69265] Hyperlink type provided during hyperlink creation not same as the type retrieved from Cell.getHyperlink() or sheet.getHyperlinkList()
https://bz.apache.org/bugzilla/show_bug.cgi?id=69265 PJ Fanning changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from PJ Fanning --- Can you please provide a reproducible test 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 69266] New: File Corruption when Modifying Page Setup in Existing .xlsx Sheets
https://bz.apache.org/bugzilla/show_bug.cgi?id=69266 Bug ID: 69266 Summary: File Corruption when Modifying Page Setup in Existing .xlsx Sheets Product: POI Version: unspecified Hardware: PC OS: Mac OS X 10.1 Status: NEW Severity: normal Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: nikknp.du...@gmail.com Target Milestone: --- When using Apache POI to modify the page setup of an existing .xlsx sheet, specifically setting the “Fit to Page” options (setFitWidth and setFitHeight), the resulting file becomes corrupted and cannot be opened by Excel. This issue occurs when reading an existing .xlsx file, applying the “Fit to Page” settings, and then saving the modified sheet to a new file. The corruption seems to stem from the way POI handles the modification of print setup options in sheets that already have pre-existing configurations, leading to invalid or incomplete file structures in the output .xlsx file. Steps to Reproduce: 1. Open an existing .xlsx file using Apache POI. 2. Access a sheet and modify the page setup by enabling “Fit to Page” and setting both width and height to 1. 3. Save the modified sheet to a new .xlsx file. 4. Attempt to open the newly saved file in Excel. Java Code - String inputFilePath = "/Users/username/Downloads/SpreadsheetSetFitToPageRead.xlsx"; String outputFilePath = "/Users/username/Downloads/SpreadsheetSetFitToPageReadTrue.xlsx"; try (FileInputStream fis = new FileInputStream(new File(inputFilePath)); Workbook workbook = WorkbookFactory.create(fis)) { // Get the first sheet from the workbook (or specify the sheet index/name) Sheet sheet = workbook.getSheetAt(0); // Set Fit to Page options sheet.setFitToPage(true); PrintSetup printSetup = sheet.getPrintSetup(); printSetup.setFitWidth((short) 1); // Fit to 1 page wide printSetup.setFitHeight((short) 1); // Fit to 1 page tall // Write the modified workbook to a new file try (FileOutputStream fos = new FileOutputStream(new File(outputFilePath))) { workbook.write(fos); } System.out.println("Sheet modifications are saved successfully in " + outputFilePath); } catch (IOException e) { e.printStackTrace(); } -- 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 69265] Hyperlink type provided during hyperlink creation not same as the type retrieved from Cell.getHyperlink() or sheet.getHyperlinkList()
https://bz.apache.org/bugzilla/show_bug.cgi?id=69265 nikknp.du...@gmail.com changed: What|Removed |Added Version|unspecified |5.3.0-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 69265] New: Hyperlink type provided during hyperlink creation not same as the type retrieved from Cell.getHyperlink() or sheet.getHyperlinkList()
https://bz.apache.org/bugzilla/show_bug.cgi?id=69265 Bug ID: 69265 Summary: Hyperlink type provided during hyperlink creation not same as the type retrieved from Cell.getHyperlink() or sheet.getHyperlinkList() Product: POI Version: unspecified Hardware: PC OS: Mac OS X 10.1 Status: NEW Severity: normal Priority: P2 Component: HSSF Assignee: dev@poi.apache.org Reporter: nikknp.du...@gmail.com Target Milestone: --- When creating a hyperlink in Apache POI, the hyperlink type specified during the creation process does not always match the type retrieved later using Cell.getHyperlink() or Sheet.getHyperlinkList(). This discrepancy causes issues where the expected hyperlink type (such as URL, Email, File, or Document) differs from the type actually stored and retrieved, leading to potential confusion and unexpected behavior in applications relying on consistent hyperlink type management. -- 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 69252] 澳门新葡京百家乐在线开户
https://bz.apache.org/bugzilla/show_bug.cgi?id=69252 PJ Fanning changed: What|Removed |Added OS||All Status|NEW |RESOLVED Resolution|--- |INVALID -- 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 69253] 澳门新葡京百家乐在线开户
https://bz.apache.org/bugzilla/show_bug.cgi?id=69253 PJ Fanning changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |INVALID -- 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 58552] NPE at XWPFStyles.getUsedStyleList()
https://bz.apache.org/bugzilla/show_bug.cgi?id=58552 Bug 58552 depends on bug 65099, which changed state. Bug 65099 Summary: NPE in XWPFStyle.getUsedStyleList(XWPFStyle style, List usedStyleList) https://bz.apache.org/bugzilla/show_bug.cgi?id=65099 What|Removed |Added Status|NEEDINFO|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 65099] NPE in XWPFStyle.getUsedStyleList(XWPFStyle style, List usedStyleList)
https://bz.apache.org/bugzilla/show_bug.cgi?id=65099 PJ Fanning changed: What|Removed |Added Status|NEEDINFO|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 65099] NPE in XWPFStyle.getUsedStyleList(XWPFStyle style, List usedStyleList)
https://bz.apache.org/bugzilla/show_bug.cgi?id=65099 PJ Fanning changed: What|Removed |Added CC||ggg...@yandex.ru --- Comment #5 from PJ Fanning --- *** Bug 58552 has been marked as a duplicate of this bug. *** -- 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 58552] NPE at XWPFStyles.getUsedStyleList()
https://bz.apache.org/bugzilla/show_bug.cgi?id=58552 PJ Fanning changed: What|Removed |Added Resolution|--- |DUPLICATE Status|NEW |RESOLVED --- Comment #2 from PJ Fanning --- Seems like this was also reported as https://bz.apache.org/bugzilla/show_bug.cgi?id=65099 and fixed in 2021. *** This bug has been marked as a duplicate of bug 65099 *** -- 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 65099] NPE in XWPFStyle.getUsedStyleList(XWPFStyle style, List usedStyleList)
https://bz.apache.org/bugzilla/show_bug.cgi?id=65099 PJ Fanning changed: What|Removed |Added Blocks||58552 Referenced Bugs: https://bz.apache.org/bugzilla/show_bug.cgi?id=58552 [Bug 58552] NPE at XWPFStyles.getUsedStyleList() -- 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 58552] NPE at XWPFStyles.getUsedStyleList()
https://bz.apache.org/bugzilla/show_bug.cgi?id=58552 PJ Fanning changed: What|Removed |Added Depends on||65099 Referenced Bugs: https://bz.apache.org/bugzilla/show_bug.cgi?id=65099 [Bug 65099] NPE in XWPFStyle.getUsedStyleList(XWPFStyle style, List usedStyleList) -- 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 69253] 澳门新葡京百家乐在线开户
https://bz.apache.org/bugzilla/show_bug.cgi?id=69253 rummybo changed: What|Removed |Added OS||All --- Comment #1 from rummybo --- https://rummybo.com/ https://rummybo.com/blog/53.html https://rummybo.com/blog/54.html https://rummybo.com/blog/18.html https://rummybo.com/blog/19.html https://rummybo.com/blog/20.html https://rummybo.com/blog/21.html https://rummybo.com/blog/22.html https://rummybo.com/blog/23.html https://rummybo.com/blog/24.html https://rummybo.com/blog/25.html https://rummybo.com/blog/26.html https://rummybo.com/blog/27.html https://rummybo.com/blog/28.html https://rummybo.com/blog/29.html https://rummybo.com/blog/30.html https://rummybo.com/blog/31.html https://rummybo.com/blog/32.html https://rummybo.com/blog/33.html https://rummybo.com/blog/34.html https://rummybo.com/blog/35.html https://rummybo.com/blog/36.html https://rummybo.com/blog/37.html https://rummybo.com/blog/38.html https://rummybo.com/blog/39.html https://rummybo.com/blog/40.html https://rummybo.com/blog/41.html https://rummybo.com/blog/42.html https://rummybo.com/blog/43.html https://rummybo.com/blog/44.html https://rummybo.com/blog/45.html https://rummybo.com/blog/46.html https://rummybo.com/blog/47.html https://rummybo.com/blog/48.html https://rummybo.com/blog/49.html https://rummybo.com/blog/50.html https://rummybo.com/blog/51.html https://rummybo.com/blog/52.html https://rummybo.com/blog/53.html https://rummybo.com/blog/54.html https://rummybo.com/blog/55.html https://rummybo.com/blog/56.html https://rummybo.com/blog/57.html https://rummybo.com/blog/58.html https://rummybo.com/blog/59.html https://rummybo.com/blog/60.html https://rummybo.com/blog/61.html https://rummybo.com/blog/62.html https://rummybo.com/blog/63.html https://rummybo.com/blog/64.html https://rummybo.com/blog/65.html https://rummybo.com/blog/66.html https://rummybo.com/blog/67.html https://rummybo.com/blog/68.html https://rummybo.com/blog/69.html https://rummybo.com/blog/70.html https://rummybo.com/blog/71.html https://rummybo.com/blog/72.html https://rummybo.com/blog/73.html https://rummybo.com/blog/74.html https://rummybo.com/blog/75.html https://rummybo.com/blog/76.html https://rummybo.com/blog/77.html https://rummybo.com/blog/78.html https://rummybo.com/blog/79.html https://rummybo.com/blog/80.html https://rummybo.com/blog/81.html https://rummybo.com/blog/82.html https://rummybo.com/blog/83.html https://rummybo.com/blog/84.html https://rummybo.com/blog/85.html https://rummybo.com/blog/86.html https://rummybo.com/blog/87.html https://rummybo.com/blog/88.html https://rummybo.com/blog/89.html https://rummybo.com/blog/90.html https://rummybo.com/blog/91.html https://rummybo.com/blog/92.html https://rummybo.com/blog/93.html https://rummybo.com/blog/94.html https://rummybo.com/blog/95.html https://rummybo.com/blog/96.html https://rummybo.com/blog/97.html https://rummybo.com/blog/98.html https://rummybo.com/blog/99.html https://rummybo.com/blog/100.htm https://rummybo.com/blog/101.html https://rummybo.com/blog/102.html https://rummybo.com/blog/103.html https://rummybo.com/blog/104.html https://rummybo.com/blog/105.html https://rummybo.com/blog/106.html https://rummybo.com/blog/107.html https://rummybo.com/blog/108.html https://rummybo.com/blog/109.html https://rummybo.com/blog/110.html https://rummybo.com/blog/111.html https://rummybo.com/blog/112.html https://rummybo.com/blog/113.html https://rummybo.com/blog/114.html https://rummybo.com/blog/115.html https://rummybo.com/blog/116.html https://rummybo.com/blog/117.html https://rummybo.com/blog/118.html https://rummybo.com/blog/119.html https://rummybo.com/blog/120.html https://rummybo.com/blog/121.html https://rummybo.com/blog/122.html https://rummybo.com/blog/123.html https://rummybo.com/blog/124.html https://rummybo.com/blog/125.html https://rummybo.com/blog/126.html https://rummybo.com/blog/127.html https://rummybo.com/blog/128.html https://rummybo.com/blog/129.html https://rummybo.com/blog/130.html https://rummybo.com/blog/131.html https://rummybo.com/blog/132.html https://rummybo.com/blog/133.html https://rummybo.com/blog/134.html https://rummybo.com/blog/ https://rummybocom.blogspot.com/2024/05/indias-most-trusted-rummy-app.html https://rummybocom.blogspot.com/2024/05/rummybocom-indian-rummy-gives-away-51.html https://rummybocom.blogspot.com/2024/05/blog-post.html https://rummybocom.blogspot.com/2024/05/thomas-and-uber-cup-final-china-womens.html https://rummybocom.blogspot.com/2024/05/india-witnesses-wedding-like-no-other.html https://rummybocom.blogspot.com/2024/05/snowboard-size-explained-what-size.html https://rummybo.com/how-to-play-rummy-online/index.html https://rummybo.com/rummy-offers/index.html https://rummybo.com/refer-and-earn-rummy/index.html https://rummybo.com/rummy-leaderboards/index.html https://rummybo.com/blog/ https
[Bug 69253] New: 澳门新葡京百家乐在线开户
https://bz.apache.org/bugzilla/show_bug.cgi?id=69253 Bug ID: 69253 Summary: 澳门新葡京百家乐在线开户 Product: POI Version: 5.3.x-dev Hardware: PC Status: NEW Severity: normal Priority: P2 Component: HDGF Assignee: dev@poi.apache.org Reporter: wxingxing...@gmail.com Target Milestone: --- https://1433123.com/"; title="澳门新葡京AG">澳门新葡京AG| https://1433123.com/"; title="澳门新葡京真人免费玩">澳门新葡京真人免费玩| https://1433123.com/"; title="澳门新葡京真人免费开户">澳门新葡京真人免费开户| https://1433123.com/"; title="新葡京游戏">新葡京游戏| https://1433123.com/"; title="新葡京游戏官网">新葡京游戏官网| https://1433123.com/"; title="新葡京游戏代理">新葡京游戏代理| https://1433123.com/"; title="新葡京游戏开户">新葡京游戏开户| https://1433123.com/"; title="新葡京游戏网址">新葡京游戏网址| https://1433123.com/"; title="新葡京游戏赚钱">新葡京游戏赚钱| https://1433123.com/"; title="新葡京游戏官方">新葡京游戏官方| https://1433123.com/"; title="新葡京游戏登入">新葡京游戏登入| https://1433123.com/"; title="新葡京真人荷官">新葡京真人荷官| https://1433123.com/"; title="新葡京试玩">新葡京试玩| https://1433123.com/"; title="新葡京免费开户">新葡京免费开户| https://1433123.com/"; title="新葡京免费代理">新葡京免费代理| https://1433123.com/"; title="新葡京试玩账号">新葡京试玩账号| https://1433123.com/"; title="新葡京真人">新葡京真人| https://1433123.com/"; title="新葡京真人网站">新葡京真人网站| https://1433123.com/"; title="新葡京真人在线游戏">新葡京真人在线游戏| https://1433123.com/"; title="新葡京真人在线">新葡京真人在线| https://1433123.com/"; title="新葡京真人游戏">新葡京真人游戏| https://1433123.com/"; title="新葡京真人官网">新葡京真人官网| https://1433123.com/"; title="新葡京真人开户">新葡京真人开户| https://1433123.com/"; title="新葡京真人代理">新葡京真人代理| https://1433123.com/"; title="新葡京真人百家乐">新葡京真人百家乐| https://1433123.com/"; title="新葡京真人百家乐开户">新葡京真人百家乐开户| https://1433123.com/"; title="新葡京真人百家乐代理">新葡京真人百家乐代理| https://1433123.com/"; title="新葡京真人百家乐游戏">新葡京真人百家乐游戏| https://1433123.com/"; title="新葡京真人百家乐官网">新葡京真人百家乐官网| https://1433123.com/"; title="新葡京娱乐城官方网站">新葡京娱乐城官方网站| https://1433123.com/"; title="新葡京百家乐">新葡京百家乐| https://1433123.com/"; title="新葡京百家乐开户">新葡京百家乐开户| https://1433123.com/"; title="新葡京百家乐代理">新葡京百家乐代理| https://1433123.com/"; title="新葡京百家乐官网">新葡京百家乐官网| https://1433123.com/"; title="新葡京百家乐游戏">新葡京百家乐游戏| https://1433123.com/"; title="新葡京百家乐在线">新葡京百家乐在线| https://1433123.com/"; title="新葡京百家乐在线开户">新葡京百家乐在线开户| https://1433123.com/"; title="新葡京百家乐在线代理">新葡京百家乐在线代理| https://1433123.com/"; title="澳门新葡京游戏官网">澳门新葡京游戏官网| https://1433123.com/"; title="澳门新葡京游戏代理">澳门新葡京游戏代理| https://1433123.com/"; title="澳门新葡京游戏开户">澳门新葡京游戏开户| https://1433123.com/"; title="澳门新葡京游戏网址">澳门新葡京游戏网址| https://1433123.com/"; title="澳门新葡京游戏赚钱">澳门新葡京游戏赚钱| https://1433123.com/"; title="澳门新葡京游戏官方">澳门新葡京游戏官方| https://1433123.com/"; title="澳门新葡京游戏登入">澳门新葡京游戏登入| https://1433123.com/"; title="澳门新葡京免费开户">澳门新葡京免费开户| https://1433123.com/"; title="澳门新葡京免费代理">澳门新葡京免费代理| https://1433123.com/"; title="澳门新葡京试玩账号">澳门新葡京试玩账号| https://1433123.com/"; title="澳门新葡京真人网站">澳门新葡京真人网站| https://1433123.com/"; title="澳门新葡京真人在线游戏">澳门新葡京真人在线游戏| https://1433123.com/"; title="澳门新葡京真人在线">澳门新葡京真人在线| https://1433123.com/"; title="澳门新葡京真人官网">澳门新葡京真人官网| https://1433123.com/"; title="澳门新葡京真人开户">澳门新葡京真人开户| https://1433123.com/"; title="澳门新葡京真人代理">澳门新葡京真人代理| https://1433123.com/"; title="澳门新葡京真人百家乐">澳门新葡京真人百家乐| https://1433123.com/"; title="澳门新葡京真人百家乐开户">澳门新葡京真人百家乐开户| https://1433123.com/"; title="澳门新葡京真人百家乐代理">澳门新葡京真人百家乐代理| https://1433123.com/"; title="澳门新葡京真人百家乐游戏">澳门新葡京真人百家乐游戏| https://1433123.com/"; title="澳门新葡京真人百家乐官网">澳门新葡京真人百家乐官网| https://1433123.com/"; title="澳门新葡京娱乐城官方网站">澳门新葡京娱乐城官方网站| https://1433123.com/"; title="澳门新葡京百家乐">澳门新葡京百家乐| https://1433123.com/"; title="澳门新葡京百家乐开户">澳门新葡京百家乐开户| https://1433123.com/"; title="澳门新葡京百家乐代理">澳门新葡京百家乐代理| https://1433123.com/"; title="澳门新葡京百家乐官网">澳门新葡京百家乐官网| https://1433123.com/"; title="澳门新葡京百家乐游戏">澳门新葡京百家乐游戏| https://1433123.com/"; title="澳门新葡京百家乐在线">澳门新葡京百家乐在线| https://1433123.com/"; title="澳门新葡京百家乐在线开户">澳门新葡京百家乐在线开户| https://1433123.com/"; title="澳门新葡京百家乐在线代理">澳门新葡京百家乐在线代理| https://1433123.com/"; title="新葡京">新葡京| https://1433123.com/"; title="新葡京真人官方">新葡京真人官方| https://1433123.com/"; title="新葡京游戏规则">新葡京游戏规则| -- 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