[Bug 66679] Cells without explicit style use column style as default
https://bz.apache.org/bugzilla/show_bug.cgi?id=66679 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 66682] Boolean formula not handled in binary eventmodel
https://bz.apache.org/bugzilla/show_bug.cgi?id=66682 Dominik Stadler changed: What|Removed |Added Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #2 from Dominik Stadler --- This seems to have been applied via r1910951 -- 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 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 66791] getting java.lang.NoSuchFieldError: RAW_XML_FILE_HEADER
https://bz.apache.org/bugzilla/show_bug.cgi?id=66791 Dominik Stadler changed: What|Removed |Added Resolution|--- |WORKSFORME Status|NEEDINFO|RESOLVED --- Comment #6 from Dominik Stadler --- This is very likely a problem with the local environment and different versions of some jar/class-files, so we likely cannot "fix" anything here. Please reopen with more information and a standalone reproducing code-sample if you are confident it is an actual problem in Apache POI itself. -- 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 OS||All Status|NEW |NEEDINFO --- Comment #1 from Dominik Stadler --- Can you provide some self-sufficient sample code which creates the file and then demonstrates the problem? Or at least a sample file? This would make it much easier for others to reproduce the issue. -- 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] New: Exception on loading Excel xslx-file with cell comment
https://bz.apache.org/bugzilla/show_bug.cgi?id=66827 Bug ID: 66827 Summary: Exception on loading Excel xslx-file with cell comment Product: POI Version: 5.2.3-FINAL Hardware: PC Status: NEW Severity: normal Priority: P2 Component: POI Overall Assignee: dev@poi.apache.org Reporter: mg.fo...@jdotsoft.com Target Milestone: --- Steps to reproduce: 1. Create cell comment in Excel. 2. Example xl/comment1.xml extracted from xslx (formatted): http://schemas.openxmlformats.org/spreadsheetml/2006/main;> Author AGNC via Excel 3. Load this Excel file via POI. 4. Exception thrown on loading this cell comment: Exception in thread "Thread-2" org.apache.xmlbeans.impl.values.XmlValueOutOfRangeException: string value 'Text' is not a valid enumeration value for ST_ObjectType in namespace urn:schemas-microsoft-com:office:excel at org.apache.xmlbeans.impl.values.JavaStringEnumerationHolderEx.set_text(JavaStringEnumerationHolderEx.java:40) at org.apache.xmlbeans.impl.values.XmlObjectBase.update_from_wscanon_text(XmlObjectBase.java:1121) at org.apache.xmlbeans.impl.values.XmlObjectBase.check_dated(XmlObjectBase.java:1250) at org.apache.xmlbeans.impl.values.JavaStringEnumerationHolderEx.getEnumValue(JavaStringEnumerationHolderEx.java:60) at com.microsoft.schemas.office.excel.impl.CTClientDataImpl.getObjectType(CTClientDataImpl.java:14177) at org.apache.poi.xssf.usermodel.XSSFVMLDrawing.matchCommentShape(XSSFVMLDrawing.java:304) at org.apache.poi.xssf.usermodel.XSSFVMLDrawing.findCommentShape(XSSFVMLDrawing.java:285) at org.apache.poi.xssf.model.CommentsTable.findCellComment(CommentsTable.java:198) at org.apache.poi.xssf.usermodel.XSSFSheet.getCellComment(XSSFSheet.java:813) at org.apache.poi.xssf.usermodel.XSSFCell.getCellComment(XSSFCell.java:1010) . . . -- 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 66791] getting java.lang.NoSuchFieldError: RAW_XML_FILE_HEADER
https://bz.apache.org/bugzilla/show_bug.cgi?id=66791 --- Comment #5 from Nick Burch --- https://poi.apache.org/help/faq.html has some code you can use to track down additional POI jars files you may have forgotten about -- 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 66791] getting java.lang.NoSuchFieldError: RAW_XML_FILE_HEADER
https://bz.apache.org/bugzilla/show_bug.cgi?id=66791 --- Comment #4 from Srinivas --- I have checked multiple times my classpath and I do not see any duplicates, is there any other thing I can check on this? Thanks for you quick responses. -- 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 66791] getting java.lang.NoSuchFieldError: RAW_XML_FILE_HEADER
https://bz.apache.org/bugzilla/show_bug.cgi?id=66791 --- Comment #3 from PJ Fanning --- POI 3.17 is 6 years old. It is no longer supported. This sort of problem with NoSuchFieldError is most commonly caused by users having multiple conflicting copies of the same jar(s) on their classpaths. -- 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 66791] getting java.lang.NoSuchFieldError: RAW_XML_FILE_HEADER
https://bz.apache.org/bugzilla/show_bug.cgi?id=66791 --- Comment #2 from Srinivas --- Yes, poi-ooxml-3.17.jar was added to my classpath -- 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 66791] getting java.lang.NoSuchFieldError: RAW_XML_FILE_HEADER
https://bz.apache.org/bugzilla/show_bug.cgi?id=66791 PJ Fanning changed: What|Removed |Added OS||All Status|NEW |NEEDINFO --- Comment #1 from PJ Fanning --- do you have poi-ooxml-3.17.jar on your classpath? -- 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 66791] New: getting java.lang.NoSuchFieldError: RAW_XML_FILE_HEADER
https://bz.apache.org/bugzilla/show_bug.cgi?id=66791 Bug ID: 66791 Summary: getting java.lang.NoSuchFieldError: RAW_XML_FILE_HEADER Product: POI Version: unspecified Hardware: PC Status: NEW Severity: normal Priority: P2 Component: POIFS Assignee: dev@poi.apache.org Reporter: srinivas.siddamn...@gmail.com Target Milestone: --- while creating excel document using poi 3.17 library, getting below error tack Trace java.lang.NoSuchFieldError: RAW_XML_FILE_HEADER at org.apache.poi.poifs.filesystem.FileMagic.(FileMagic.java:42) at org.apache.poi.openxml4j.opc.internal.ZipHelper.openZipStream(ZipHelper.java:208) at org.apache.poi.openxml4j.opc.ZipPackage.(ZipPackage.java:98) at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:324) at org.apache.poi.util.PackageHelper.open(PackageHelper.java:37) at org.apache.poi.xssf.usermodel.XSSFWorkbook.(XSSFWorkbook.java:295) I have added all the below libraries to my classpath: ooxml-schemas-1.3.jar poi-3.17.jar poi-ooxml_schemas-3.17.jar commons-codec-1.10.jar commons-logging-1.2.jar commons-collections4-4.1.jar curvesapi-1.04.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 66675] Save not happening in work book showing A part with the name '/docProps/core.xml' already exists
https://bz.apache.org/bugzilla/show_bug.cgi?id=66675 PJ Fanning changed: What|Removed |Added Severity|blocker |normal --- Comment #6 from PJ Fanning --- have a look at the comment from 2023-07-12 12:30:54 UTC -- 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 66675] Save not happening in work book showing A part with the name '/docProps/core.xml' already exists
https://bz.apache.org/bugzilla/show_bug.cgi?id=66675 --- Comment #5 from Prabhakaran --- Any luck/update? -- 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 66705] New: Slide Transitions not working XSLF Slide
https://bz.apache.org/bugzilla/show_bug.cgi?id=66705 Bug ID: 66705 Summary: Slide Transitions not working XSLF Slide Product: POI Version: unspecified Hardware: Macintosh OS: Mac OS X 10.1 Status: NEW Severity: major Priority: P2 Component: XSLF Assignee: dev@poi.apache.org Reporter: eric.may...@gmail.com Target Milestone: --- I'm attempting to use POI to manage slide transitions. Using this: > final XSLFSlide slide; > slide.getXmlObject().getTransition(); Always returns null, even when I know my slide has a transition in it. I notice this in my VALID (source) PPT XML: > >xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006;> >xmlns:p159="http://schemas.microsoft.com/office/powerpoint/2015/09/main; > Requires="p159"> > > > > > > > > > > > When I use POI to add a transition, it adds this as a node: > slide.getXmlObject().addNewTransition().setAdvTm(1000); > PPT reads is as corrupted, has to repair it, and it loses it. I believe the format has changed and I could use help navigating it. I was hoping you could help me either work around it or show me what I'm doing wrong. Eric -- 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] New: Combination of XSSF and SXSSF may result in invalid files
https://bz.apache.org/bugzilla/show_bug.cgi?id=66687 Bug ID: 66687 Summary: Combination of XSSF and SXSSF may result in invalid files Product: POI Version: 5.2.3-FINAL Hardware: PC Status: NEW Severity: normal Priority: P2 Component: SXSSF Assignee: dev@poi.apache.org Reporter: martin.schloe...@x-map.de Target Milestone: --- Created attachment 38600 --> https://bz.apache.org/bugzilla/attachment.cgi?id=38600=edit Test case to produce a file that Excel will have trouble with When mixing XSSF and SXSSF and not creating XSSF cells in the correct order, the resulting file will contain the broken cell order, leading Excel to display a repair option and losing data. This is achieved by adding XSSF cells and then adding new rows with SXSSF, thus bypassing both mechanisms that would have sorted the cells. I assume calling XSSFRow.onDocumentWrite for the sorting even when dimensionOverride is set would fix the issue. -- 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 66675] Save not happening in work book showing A part with the name '/docProps/core.xml' already exists
https://bz.apache.org/bugzilla/show_bug.cgi?id=66675 --- Comment #4 from PJ Fanning --- added r1910949 -- 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 66675] Save not happening in work book showing A part with the name '/docProps/core.xml' already exists
https://bz.apache.org/bugzilla/show_bug.cgi?id=66675 Prabhakaran 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 66675] Save not happening in work book showing A part with the name '/docProps/core.xml' already exists
https://bz.apache.org/bugzilla/show_bug.cgi?id=66675 Prabhakaran changed: What|Removed |Added Severity|normal |blocker Priority|P2 |P1 -- 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 65510] Add support for XLSB Short Cell Records
https://bz.apache.org/bugzilla/show_bug.cgi?id=65510 Dominik Stadler changed: What|Removed |Added OS||All --- Comment #3 from Dominik Stadler --- Hi, thanks for the offer of helping out with this feature. Please take a look at https://poi.apache.org/devel/index.html for documentation of retrieving and building the source code of Apache POI. Please use the mailing list listed at https://poi.apache.org/help/index.html for questions/discussion of implementation details. Finally https://poi.apache.org/devel/guidelines.html describes some best-practices when contributing 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 66682] Boolean formula not handled in binary eventmodel
https://bz.apache.org/bugzilla/show_bug.cgi?id=66682 PJ Fanning changed: What|Removed |Added OS||All --- Comment #1 from PJ Fanning --- linking to https://github.com/apache/poi/pull/485 so people are aware of the PR -- 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 66682] New: Boolean formula not handled in binary eventmodel
https://bz.apache.org/bugzilla/show_bug.cgi?id=66682 Bug ID: 66682 Summary: Boolean formula not handled in binary eventmodel Product: POI Version: unspecified Hardware: PC Status: NEW Severity: normal Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: tmo...@spatial.ca Target Milestone: --- Created attachment 38598 --> https://bz.apache.org/bugzilla/attachment.cgi?id=38598=edit Excel binary format spreadsheet containing boolean formula When reading a binary excel file (xlsb) using the eventmodel cells that are of type BrtFmlaBool are not handled in the XSSFBSheetHandler.handleRecord method. The consequence is that these cell will always yield an empty value regardless of the evaluation of the formula. The easy fix is to add a cell handler for this record type. Fortunately the existing handler for BrtCellBool does what is needed, so adding a single line with an additional case label does the job: case BrtCellBool: case BrtFmlaBool: handleBoolean(data); break; Sample spreadsheet attached that contains cells showing this 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 65510] Add support for XLSB Short Cell Records
https://bz.apache.org/bugzilla/show_bug.cgi?id=65510 opeongo changed: What|Removed |Added OS|Mac OS X 10.1 |Windows 10 --- Comment #2 from opeongo --- I have an itch here and I am willing to take a kick at it. I am completely new to the POI code base. Can anyone give me some pointers to help me get up the learning curve, such as where to look to add the short record, debug tools to dump out files, etc. -- 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 66679] New: Cells without explicit style use column style as default
https://bz.apache.org/bugzilla/show_bug.cgi?id=66679 Bug ID: 66679 Summary: Cells without explicit style use column style as default Product: POI Version: 5.2.3-FINAL Hardware: PC Status: NEW Severity: normal Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: martin.schloe...@x-map.de Target Milestone: --- Created attachment 38597 --> https://bz.apache.org/bugzilla/attachment.cgi?id=38597=edit Cell D3 doesn't have "s" attribute and falls back to column style. When a cell has no style of its own, but the column has a style set, POI will return the column style when Cell.getCellStyle() is called. While this does sound reasonable, the problem is that this is different from what Excel displays. Excel will show "Standard" style on these cells. This is potentially caused by Bug 56011. These cells can be created in Excel by setting a style on a column and then deleting a cell on it and moving trailing cells (without style) to the left. The result will be a cell with no style. The only workaround is to explicitly set "Standard" format on this cell. See cell D3 in attached Test.xslx. My understanding is that Excel uses the column style only to initialize new cells, e.g. when a row is inserted. When cells get moved around they keep their style and fall back to default style in case they have no style set. NB: I'm using the german version of Excel and some terms may be different. -- 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 66675] Save not happening in work book showing A part with the name '/docProps/core.xml' already exists
https://bz.apache.org/bugzilla/show_bug.cgi?id=66675 --- Comment #3 from Prabhakaran --- Hi please find the attached file,we have developing new POC using apache POI so there is no Test case, this is actual code. Note:the file directly get it from POWER BI api, if we have download the file then save as manually after checking it will work properly but our requirement handle the input file dynamically(runtime) so that time i have faced that error. its not related to file issue -- 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 66675] Save not happening in work book showing A part with the name '/docProps/core.xml' already exists
https://bz.apache.org/bugzilla/show_bug.cgi?id=66675 --- Comment #2 from Prabhakaran --- Created attachment 38596 --> https://bz.apache.org/bugzilla/attachment.cgi?id=38596=edit Input 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 66644] Make Apache POI binaries reproducible
https://bz.apache.org/bugzilla/show_bug.cgi?id=66644 --- Comment #5 from PJ Fanning --- added r1910760 -- 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 66661] Issue with table formulas being modified by POI
https://bz.apache.org/bugzilla/show_bug.cgi?id=1 PJ Fanning changed: 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 62181] A part with the name '/xl/sharedStrings.xml' already exists : Packages shall not contain equivalent part names and package implementers shall neither create nor recognize packages with equ
https://bz.apache.org/bugzilla/show_bug.cgi?id=62181 PJ Fanning changed: What|Removed |Added Resolution|--- |FIXED Status|NEW |RESOLVED --- Comment #1 from PJ Fanning --- I made the shared string loading work around the issue - r1910759 -- 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 65916] IndexOutOfBoundsException - Workbook.write()
https://bz.apache.org/bugzilla/show_bug.cgi?id=65916 PJ Fanning changed: What|Removed |Added OS|Mac OS X 10.1 |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 62181] A part with the name '/xl/sharedStrings.xml' already exists : Packages shall not contain equivalent part names and package implementers shall neither create nor recognize packages with equ
https://bz.apache.org/bugzilla/show_bug.cgi?id=62181 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 66675] Save not happening in work book showing A part with the name '/docProps/core.xml' already exists
https://bz.apache.org/bugzilla/show_bug.cgi?id=66675 PJ Fanning changed: What|Removed |Added Severity|blocker |normal OS||All Status|NEW |NEEDINFO --- Comment #1 from PJ Fanning --- That code is not a test case - where does inputFile param come from? You will need to provide the 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 66675] New: Save not happening in work book showing A part with the name '/docProps/core.xml' already exists
https://bz.apache.org/bugzilla/show_bug.cgi?id=66675
Bug ID: 66675
Summary: Save not happening in work book showing A part with
the name '/docProps/core.xml' already exists
Product: POI
Version: 5.2.3-FINAL
Hardware: PC
Status: NEW
Severity: blocker
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: prabhu...@gmail.com
Target Milestone: ---
Created attachment 38595
--> https://bz.apache.org/bugzilla/attachment.cgi?id=38595=edit
This attachment shows the error
Hi
I am using apche poi ooxm-5.2.3 version and i was tried older version also.
I have used apache poi for reading the xlsx sheets and removing the selected
tabs that is working fine after deletion the save not happen it throwing the
following error.
org.apache.poi.openxml4j.exceptions.InvalidOperationException: A part with the
name '/docProps/core.xml' already exists : Packages shall not contain
equivalent part names and package implementers shall neither create nor
recognize packages with equivalent part names. [M1.12]
at
org.apache.poi.openxml4j.opc.OPCPackage.addPackagePart(OPCPackage.java:947)
at
org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:547)
at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1496)
at org.apache.poi.ooxml.POIXMLDocument.write(POIXMLDocument.java:227)
at
com.simplilearn.mavenexample.Authentication.getWorkbook(Authentication.java:691)
at
com.simplilearn.mavenexample.Authentication.exportToFile(Authentication.java:656)
at com.simplilearn.mavenexample.App.main(App.java:29)
So as per my understanding whenever edit happens using the apche poi it try to
create new OPC package part checks existing part so that time the error
displayed.
For testing purpose i have deleted the package part then it was allowed for
SAVE.
The JAVA code is pretty straight forward.
try {
ByteArrayOutputStream bos = new ByteArrayOutputStream();
XSSFWorkbook testWorkBook = new XSSFWorkbook(inputfile);
testWorkBook.removeSheetAt(0);
testWorkBook.write(bos);
}
catch(Exception e) {
e.printStackTrace();
}
Observations:
1.Once opened XLSX even without change also not allowed for save
2.The part name removal working only for windows Environment not LINUX server
--
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 62181] A part with the name '/xl/sharedStrings.xml' already exists : Packages shall not contain equivalent part names and package implementers shall neither create nor recognize packages with equ
https://bz.apache.org/bugzilla/show_bug.cgi?id=62181 Prabhakaran changed: What|Removed |Added CC||prabhu...@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 65916] IndexOutOfBoundsException - Workbook.write()
https://bz.apache.org/bugzilla/show_bug.cgi?id=65916
--- Comment #14 from moimoi.chk ---
sorry miss
public Iterator cellIterator() {
Iterator originalIterator = (Iterator)(Iterator)_cells.values().iterator();
return new Iterator() {
Cell lastNext = null;
@Override
public boolean hasNext() {
return originalIterator.hasNext();
}
@Override
public Cell next() {
return lastNext = originalIterator.next();
}
@Override
public void remove() {
removeCellWithoutRemoveFromList(lastNext);
originalIterator.remove();
}
};
}
--
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 65916] IndexOutOfBoundsException - Workbook.write()
https://bz.apache.org/bugzilla/show_bug.cgi?id=65916
--- Comment #13 from moimoi.chk ---
package org.apache.poi.xssf.usermodel;
XSSFRow
=
change
=
public Iterator cellIterator() {
Iterator originalIterator = (Iterator)(Iterator)_cells.values().iterator();
return new Iterator() {
Cell lastNext = null;
@Override
public boolean hasNext() {
return originalIterator.hasNext();
}
@Override
public Cell next() {
return lastNext = originalIterator.next();
}
@Override
public void remove() {
removeCellWithoutRemoveFromList(lastNext);
}
};
}
=
change
=
public void removeCell(Cell cell) {
removeCellWithoutRemoveFromList(cell);
_cells.remove(cell);
}
=
add
=
private void removeCellWithoutRemoveFromList(Cell cell) {
if (cell.getRow() != this) {
throw new IllegalArgumentException("Specified cell does not belong
to this row");
}
//noinspection SuspiciousMethodCalls
if(!_cells.containsValue(cell)) {
throw new IllegalArgumentException("the row does not contain this
cell");
}
XSSFCell xcell = (XSSFCell)cell;
if(xcell.isPartOfArrayFormulaGroup()) {
xcell.setCellFormula(null); // to remove the array formula
}
if(cell.getCellType() == CellType.FORMULA) {
_sheet.getWorkbook().onDeleteFormula(xcell);
}
// Performance optimization for bug 57840: explicit boxing is slightly
faster than auto-unboxing, though may use more memory
final Integer colI = Integer.valueOf(cell.getColumnIndex()); // NOSONAR
// also remove the corresponding CTCell from the _row.cArray,
// it may not be at the same position right now
// thus search for it
int i = 0;
for (CTCell ctCell : _row.getCArray()) {
if(ctCell == ((XSSFCell)cell).getCTCell()) {
_row.removeC(i);
}
i++;
}
}
--
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 65916] IndexOutOfBoundsException - Workbook.write()
https://bz.apache.org/bugzilla/show_bug.cgi?id=65916 --- Comment #12 from moimoi.chk --- package org.apache.poi.xssf.usermodel; XSSFRow -- 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 65916] IndexOutOfBoundsException - Workbook.write()
https://bz.apache.org/bugzilla/show_bug.cgi?id=65916
--- Comment #11 from moimoi.chk ---
When you do a remove operation with an iterator, it is not enough to simply
remove it from the list.
It must be done as in the following code.
The following modification is not a clean fix, but it works.
package org.apache.poi.xssf.usermodel;
public Iterator cellIterator() {
Iterator originalIterator = (Iterator)(Iterator)_cells.values().iterator();
return new Iterator() {
Cell lastNext = null;
@Override
public boolean hasNext() {
return originalIterator.hasNext();
}
@Override
public Cell next() {
return lastNext = originalIterator.next();
}
@Override
public void remove() {
Cell cell = lastNext;
if (cell.getRow() != XSSFRow.this) {
throw new IllegalArgumentException("Specified cell does not
belong to this row");
}
//noinspection SuspiciousMethodCalls
if(!_cells.containsValue(cell)) {
throw new IllegalArgumentException("the row does not
contain this cell");
}
XSSFCell xcell = (XSSFCell)cell;
if(xcell.isPartOfArrayFormulaGroup()) {
xcell.setCellFormula(null); // to remove the array formula
}
if(cell.getCellType() == CellType.FORMULA) {
_sheet.getWorkbook().onDeleteFormula(xcell);
}
// Performance optimization for bug 57840: explicit boxing is
slightly faster than auto-unboxing, though may use more memory
final Integer colI = Integer.valueOf(cell.getColumnIndex()); //
NOSONAR
XSSFCell removed = (XSSFCell) cell;
// also remove the corresponding CTCell from the _row.cArray,
// it may not be at the same position right now
// thus search for it
int i = 0;
for (CTCell ctCell : _row.getCArray()) {
if(ctCell == removed.getCTCell()) {
_row.removeC(i);
}
i++;
}
originalIterator.remove();
}
};
}
--
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 65916] IndexOutOfBoundsException - Workbook.write()
https://bz.apache.org/bugzilla/show_bug.cgi?id=65916
--- Comment #10 from moimoi.chk ---
↑The comment up is a mistake.
The correct answer is that this problem occurs when "the iterator deletes even
one cell".
=
OK case
Remove empty row
=
fun clearAll(sheet: Sheet) {
val itr = sheet.rowIterator()
while (itr.hasNext()) {
val row = itr.next()
if (row.rowNum >= 4) {
clearRow(row)
itr.remove()// remove empty row
}
}
}
fun clearRow(row: Row) {
val itr = row.cellIterator()
while (itr.hasNext()) {
itr.next()
itr.remove()
}
}
=
NG case 1
Leave at least one cell in the row
=
fun clearAll(sheet: Sheet) {
val itr = sheet.rowIterator()
while (itr.hasNext()) {
val row = itr.next()
if (row.rowNum >= 4) {
if (clearRow(row)) {
itr.remove()// remove empty row
}
}
}
}
fun clearRow(row: Row): Boolean {
// count cell
var itr = row.cellIterator()
var cellCount = 0
while (itr.hasNext()) {
itr.next()
cellCount++
}
if (cellCount == 0) {
return true
}
// leave one cell and delete the rest
val keepTarget = Random().nextInt(cellCount)
itr = row.cellIterator()
var i = 0
while (itr.hasNext()) {
itr.next()
if (i++ != keepTarget) {
itr.remove()
cellCount--
}
}
assert(cellCount == 1)
return false
}
=
NG case 2
Delete only one cell at most
=
fun clearAll(sheet: Sheet) {
val itr = sheet.rowIterator()
while (itr.hasNext()) {
val row = itr.next()
if (row.rowNum >= 4) {
clearRow(row)
}
}
}
fun clearRow(row: Row) {
val itr = row.cellIterator()
if (itr.hasNext()) {
itr.next()
itr.remove()
}
}
--
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 65916] IndexOutOfBoundsException - Workbook.write()
https://bz.apache.org/bugzilla/show_bug.cgi?id=65916
--- Comment #9 from moimoi.chk ---
Hey Tom!
This problem seems to occur when there is an empty line in the iterator.
=
Examples of okay case1
remove empty row
=
fun clearAll(sheet: Sheet) {
val itr = sheet.rowIterator()
while (itr.hasNext()) {
val row = itr.next()
if (row.rowNum >= 4) {
clearRow(row)
itr.remove()// remove empty row
}
}
}
fun clearRow(row: Row) {
val itr = row.cellIterator()
while (itr.hasNext()) {
itr.next()
itr.remove()
}
}
=
Examples of okay case2
Leave at least one cell in the row
=
fun clearAll(sheet: Sheet) {
val itr = sheet.rowIterator()
while (itr.hasNext()) {
val row = itr.next()
if (row.rowNum >= 4) {
clearRow(row)
}
}
}
fun clearRow(row: Row) {
// count cell
var itr = row.cellIterator()
var cellCount = 0
while (itr.hasNext()) {
itr.next()
cellCount++
}
if (cellCount == 0) {
return
}
// leave one cell and delete the rest
val keepTarget = Random().nextInt(cellCount)
itr = row.cellIterator()
var i = 0
while (itr.hasNext()) {
itr.next()
if (i++ != keepTarget) {
itr.remove()
cellCount--
}
}
assert(cellCount == 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 65916] IndexOutOfBoundsException - Workbook.write()
https://bz.apache.org/bugzilla/show_bug.cgi?id=65916 --- Comment #8 from moimoi.chk --- This link is an excel file, but it might open in Google Spreadsheet on its own. It would be better to save the file directly as an excel file if possible, but if not, I think it is possible to reproduce it by [File]->[Download]->[.elsx] -- 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 65916] IndexOutOfBoundsException - Workbook.write()
https://bz.apache.org/bugzilla/show_bug.cgi?id=65916
--- Comment #7 from moimoi.chk ---
Hey Tom!
Several years have passed and I had no choice but to return to help with this
problem^^/!
ExcelFile:
https://docs.google.com/spreadsheets/d/15yg4CwC_MBHOmjArTOJFumzCe6bz0Aic/edit?usp=sharing=114966700205032259907=true=true
package test
import com.true_stage.truexcel.excel.Aggregate
import org.apache.poi.ss.usermodel.*
import java.io.File
import java.io.FileOutputStream
fun main(vararg args: String) {
val book = WorkbookFactory.create(File("/Users/takano/test.xlsx"))
// create sheet
val baseSheetIndex = book.getSheetIndex("base")
if (baseSheetIndex == -1) {
throw Exception()
}
val sheet = book.cloneSheet(baseSheetIndex)
val newSheetIndex = book.getSheetIndex(sheet)
book.setSheetName(newSheetIndex, "TomRiddle")
// issue point
clearAll(sheet)
// write as other file
write(book, File("/Users/takano/garbage.xlsx"))
}
fun write(workbook: Workbook, file: File): String? {
var out: FileOutputStream? = null
return try {
out = file.outputStream()
workbook.write(out)
file.absolutePath
} catch (e: Exception) {
null
} finally {
out?.close()
}
}
fun clearAll(sheet: Sheet) {
val itr = sheet.rowIterator()
while (itr.hasNext()) {
val row = itr.next()
if (row.rowNum >= 4) {
clearRow(row)
}
}
}
fun clearRow(row: Row) {
val itr = row.cellIterator()
while (itr.hasNext()) {
itr.next()
itr.remove()
}
}
--
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 --- Comment #4 from PJ Fanning --- We can live without that DSTAMP in the Version.java template. With xmlbeans, I created a new buildinfo file that gets published separately to Maven. See last June 17-19 commits in https://github.com/apache/xmlbeans/commits/trunk. I'm reluctant to do the same in POI because of the multiple modules. -- 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
--- Comment #3 from Dominik Stadler ---
FYI, a simple re-build did not show any difference when using diffoscope:
for i in `find build -name *.jar`;do echo $i `basename $i`;diffoscope
--progress --text - $i /tmp/`basename $i`;done
build/dist/maven/poi-excelant/poi-excelant-5.2.4-SNAPSHOT.jar
poi-excelant-5.2.4-SNAPSHOT.jar
build/dist/maven/poi-ooxml-lite-agent/poi-ooxml-lite-agent-5.2.4-SNAPSHOT.jar
poi-ooxml-lite-agent-5.2.4-SNAPSHOT.jar
build/dist/maven/poi/poi-5.2.4-SNAPSHOT.jar poi-5.2.4-SNAPSHOT.jar
build/dist/maven/poi-examples/poi-examples-5.2.4-SNAPSHOT.jar
poi-examples-5.2.4-SNAPSHOT.jar
build/dist/maven/poi-integration/poi-integration-5.2.4-SNAPSHOT.jar
poi-integration-5.2.4-SNAPSHOT.jar
build/dist/maven/poi-ooxml/poi-ooxml-5.2.4-SNAPSHOT.jar
poi-ooxml-5.2.4-SNAPSHOT.jar
build/dist/maven/poi-ooxml-full/poi-ooxml-full-5.2.4-SNAPSHOT-sources.jar
poi-ooxml-full-5.2.4-SNAPSHOT-sources.jar
build/dist/maven/poi-ooxml-full/poi-ooxml-full-5.2.4-SNAPSHOT.jar
poi-ooxml-full-5.2.4-SNAPSHOT.jar
build/dist/maven/poi-scratchpad/poi-scratchpad-5.2.4-SNAPSHOT.jar
poi-scratchpad-5.2.4-SNAPSHOT.jar
build/dist/maven/poi-ooxml-lite/poi-ooxml-lite-5.2.4-SNAPSHOT.jar
poi-ooxml-lite-5.2.4-SNAPSHOT.jar
As we control the version of Java that is used even using Java 17 did not
result in any change in the binaries.
Remaining issues that I can think of:
1)
There will be a change when the build is run on a different date because of
this in poi/build.gradle
* content = content.replace("@DSTAMP@", new Date().format('MMdd'))
--
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 65916] IndexOutOfBoundsException - Workbook.write()
https://bz.apache.org/bugzilla/show_bug.cgi?id=65916 --- Comment #6 from PJ Fanning --- I added r1910569 that proves creating 2 rows with same row num does not cause an exception. -- 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 65916] IndexOutOfBoundsException - Workbook.write()
https://bz.apache.org/bugzilla/show_bug.cgi?id=65916 --- Comment #5 from PJ Fanning --- r.naujack - could you provide a fuller example? 2 lines with no idea what classesyou used is not 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 65916] IndexOutOfBoundsException - Workbook.write()
https://bz.apache.org/bugzilla/show_bug.cgi?id=65916 r.naujack+...@quotas.de 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 65916] IndexOutOfBoundsException - Workbook.write()
https://bz.apache.org/bugzilla/show_bug.cgi?id=65916 --- Comment #4 from r.naujack+...@quotas.de --- I had this problem in a sheet with a duplicate created row: final Row h1Row = sheet.createRow(2); final Row h2Row = sheet.createRow(2); It works with versions <= 4.10. Using the correct creation final Row h1Row = sheet.createRow(2); final Row h2Row = sheet.createRow(3); all works fine -- 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 62429] Not Able to read 2016 MS-Excel file Containing TreeMap using InputStreamReader JAVA
https://bz.apache.org/bugzilla/show_bug.cgi?id=62429 Bug 62429 depends on bug 66650, which changed state. Bug 66650 Summary: add chartEx schema to poi-ooxml-full https://bz.apache.org/bugzilla/show_bug.cgi?id=66650 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 66650] add chartEx schema to poi-ooxml-full
https://bz.apache.org/bugzilla/show_bug.cgi?id=66650 PJ Fanning changed: What|Removed |Added Resolution|--- |FIXED 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 66661] Issue with table formulas being modified by POI
https://bz.apache.org/bugzilla/show_bug.cgi?id=1 --- Comment #3 from PJ Fanning --- added r1910561 -- 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 66663] org.springframework.web.util.NestedServletException handler dispatch failed Could not initialize class sun.awt.X11FontManager
https://bz.apache.org/bugzilla/show_bug.cgi?id=3 --- Comment #3 from Shubham patil --- Appreciated, Thanks for the quick response. I have added Djava.awt.headless=true line and rerun my application but facing other issue. .. Now I am getting java.lang.UnsatisfiedLink Error usr/pkg/java/openjdk7/jre/lib/amd64 libfontmanager.so Shared object libfreetype.so.7" not found. Kindly help -- 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 66663] org.springframework.web.util.NestedServletException handler dispatch failed Could not initialize class sun.awt.X11FontManager
https://bz.apache.org/bugzilla/show_bug.cgi?id=3 PJ Fanning changed: What|Removed |Added Resolution|--- |INVALID Status|NEW |RESOLVED --- Comment #2 from PJ Fanning --- This is a bug tracker. If you have usage problems, stackoverflow.com is a better solution. There are plenty of questions on there already about X11 setup. -- 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 66663] org.springframework.web.util.NestedServletException handler dispatch failed Could not initialize class sun.awt.X11FontManager
https://bz.apache.org/bugzilla/show_bug.cgi?id=3 --- Comment #1 from sfis...@gmail.com --- you might need to pass -Djava.awt.headless=true to the jvm launched inside the docker image -- 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 66663] New: org.springframework.web.util.NestedServletException handler dispatch failed Could not initialize class sun.awt.X11FontManager
https://bz.apache.org/bugzilla/show_bug.cgi?id=3 Bug ID: 3 Summary: org.springframework.web.util.NestedServletException handler dispatch failed Could not initialize class sun.awt.X11FontManager Product: POI Version: 5.2.2-FINAL Hardware: Other OS: Linux Status: NEW Severity: blocker Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: shubhampaydo...@gmail.com Target Milestone: --- I am using jdk 11 and Apache poi 5.2.0 lib. I am getting org.springframework.web.util.NestedServletException handler dispatch failed Could not initialize class sun.awt.X11FontManager exception when I am running my Excel utility application in docker environment. Kindly help me on this. 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 47950] No case insensitivity handling for OLE2 entry names
https://bz.apache.org/bugzilla/show_bug.cgi?id=47950 --- Comment #12 from Tim Allison --- Ugh, ugh, ugh. Ross Johnson. Please forgive me. -- 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 47950] No case insensitivity handling for OLE2 entry names
https://bz.apache.org/bugzilla/show_bug.cgi?id=47950 --- Comment #11 from Tim Allison --- I opened: https://github.com/apache/poi/pull/477 The one challenge is that we do rely on case sensitivity for "Book" vs "BOOK". We use the former as an indicator of the old excel format, and the latter can occur in some regular xls Crystal reports... So there are some less than great workaround to get everything to work. If there's a simpler way of doing this and/or of identifying the old excel formats, that'd be great. -- 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 66661] Issue with table formulas being modified by POI
https://bz.apache.org/bugzilla/show_bug.cgi?id=1 --- Comment #2 from PJ Fanning --- Thanks ManiacTwister. We do need to make POI changes. PR 269 has got some problems. -- 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 66661] Issue with table formulas being modified by POI
https://bz.apache.org/bugzilla/show_bug.cgi?id=1 --- Comment #1 from ManiacTwister --- Thanks for your effort. I can confirm using the workaround `setCellFormulaValidation(false)` fixes the problem for my testcase as well as for my real use case. Let me know if i can help/test anything to fix the issue. -- 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 66661] New: Issue with table formulas being modified by POI
https://bz.apache.org/bugzilla/show_bug.cgi?id=1 Bug ID: 1 Summary: Issue with table formulas being modified by POI Product: POI Version: 5.2.3-FINAL Hardware: All OS: All Status: NEW Severity: normal Priority: P2 Component: XSSF Assignee: dev@poi.apache.org Reporter: fannin...@yahoo.com Target Milestone: --- See https://lists.apache.org/thread/92wn25sjkbqo0rp8hlnkpb66lb84 reproduction code is in https://github.com/ManiacTwister/poi-table-bisect A formula like `SUBTOTAL(109,Table1[Heading2])` can get overwritten by POI and become `SUBTOTAL(109,Sheet0!B2:B6)`. One way to avoid this is to call this API on XSSFWorkbook. https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFWorkbook.html#setCellFormulaValidation-boolean- Setting it to false will stop POI rerendering your formulas. It is suspected that https://github.com/apache/poi/pull/269 may be making this cell formula rerendering worse for this scenario. -- 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 47950] No case insensitivity handling for OLE2 entry names
https://bz.apache.org/bugzilla/show_bug.cgi?id=47950 --- Comment #10 from Tim Allison --- Ross Spencer recently raised an issue on Tika on this topic: https://issues.apache.org/jira/browse/TIKA-4091 I might take a 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 66653] XDDFValueAxis setMajorUnit gets an exception on execution
https://bz.apache.org/bugzilla/show_bug.cgi?id=66653 --- Comment #2 from PJ Fanning --- poi--oxml defaults to having a dependency on poi-ooxml-lite. poi-ooxml-lite is a subset of poi-ooxml-full. poi-ooxml-lite only has the most commonly used XMLBeans for POI. poi-ooxml-full is big so that's why we default to poi-ooxml-lite. If you choose to use poi-ooxml-full, it is a good idea to exclude poi-ooxml-lite. I've made a change to POI so that v5.2.4 will put that missing staxisunit6cc7type.xsb in poi-ooxml-lite. -- 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 66653] XDDFValueAxis setMajorUnit gets an exception on execution
https://bz.apache.org/bugzilla/show_bug.cgi?id=66653 jrme...@comcast.net changed: What|Removed |Added Resolution|--- |INFORMATIONPROVIDED 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 66653] XDDFValueAxis setMajorUnit gets an exception on execution
https://bz.apache.org/bugzilla/show_bug.cgi?id=66653
jrme...@comcast.net changed:
What|Removed |Added
OS||All
--- Comment #1 from jrme...@comcast.net ---
further searching online found a similar bug resolved by including
poi-ooxml-full in my Gradle dependencies:
dependencies
{
implementation 'org.apache.poi:poi:5.2.2'
implementation 'org.apache.poi:poi-ooxml-full:5.2.2'
implementation 'org.apache.poi:poi-ooxml:5.2.2'
}
My code works now.
Sorry for the false alarm.
--
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 66653] New: XDDFValueAxis setMajorUnit gets an exception on execution
https://bz.apache.org/bugzilla/show_bug.cgi?id=66653
Bug ID: 66653
Summary: XDDFValueAxis setMajorUnit gets an exception on
execution
Product: POI
Version: unspecified
Hardware: Macintosh
Status: NEW
Severity: normal
Priority: P2
Component: XDDF
Assignee: dev@poi.apache.org
Reporter: jrme...@comcast.net
Target Milestone: ---
The following code works in 4.1.2. It does not work in 5.0.0 or higher:
XDDFValueAxis xAxis = chart.createValueAxis(AxisPosition.BOTTOM);
XDDFValueAxis yAxis = chart.createValueAxis(AxisPosition.LEFT);
xAxis.setTitle("Seconds Into Run");
double xAxisMajorUnits = 300.0;
xAxis.setMajorUnit(xAxisMajorUnits);
It gets this exception when executing
Exception in thread "main" org.apache.xmlbeans.SchemaTypeLoaderException:
XML-BEANS compiled schema: Could not locate compiled schema resource
org/apache/poi/schemas/ooxml/system/ooxml/staxisunit6cc7type.xsb
(org.apache.poi.schemas.ooxml.system.ooxml.staxisunit6cc7type) - code 0
at org.apache.xmlbeans.impl.schema.XsbReader.(XsbReader.java:63)
at
org.apache.xmlbeans.impl.schema.SchemaTypeSystemImpl.resolveHandle(SchemaTypeSystemImpl.java:931)
at
org.apache.xmlbeans.SchemaComponent$Ref.getComponent(SchemaComponent.java:111)
at org.apache.xmlbeans.SchemaType$Ref.get(SchemaType.java:1072)
at
org.apache.xmlbeans.impl.schema.SchemaPropertyImpl.getType(SchemaPropertyImpl.java:85)
at
org.apache.xmlbeans.impl.schema.SchemaTypeImpl.createAttributeType(SchemaTypeImpl.java:1055)
at
org.apache.xmlbeans.impl.values.XmlObjectBase.create_attribute_user(XmlObjectBase.java:898)
at org.apache.xmlbeans.impl.store.Xobj.getUser(Xobj.java:1598)
at
org.apache.xmlbeans.impl.store.Xobj.add_attribute_user(Xobj.java:2167)
at
org.openxmlformats.schemas.drawingml.x2006.chart.impl.CTAxisUnitImpl.setVal(CTAxisUnitImpl.java:67)
at
org.apache.poi.xddf.usermodel.chart.XDDFValueAxis.setMajorUnit(XDDFValueAxis.java:154)
at
FilesToExcel.AWSCloudwatchTSVToExcel.writeToExcel(AWSCloudwatchTSVToExcel.java:143)
at
FilesToExcel.AWSCloudwatchTSVToExcel.main(AWSCloudwatchTSVToExcel.java:56)
--
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 66650] add chartEx schema to poi-ooxml-full
https://bz.apache.org/bugzilla/show_bug.cgi?id=66650 --- Comment #1 from PJ Fanning --- added r1910433 -- 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 66650] New: add chartEx schema to poi-ooxml-full
https://bz.apache.org/bugzilla/show_bug.cgi?id=66650 Bug ID: 66650 Summary: add chartEx schema to poi-ooxml-full Product: POI Version: 5.2.3-FINAL Hardware: All OS: All Status: NEW Severity: normal Priority: P2 Component: XDDF Assignee: dev@poi.apache.org Reporter: fannin...@yahoo.com Target Milestone: --- also add a XSSFRelation See issue 62429 for necessity to add full support. This change will at least make it easier for users to load up the generated XMLBeans class instances for the chartex data. -- 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 66651] New: References to non existing named cells inside Formulas throws exception even with IF/ISERROR
https://bz.apache.org/bugzilla/show_bug.cgi?id=66651
Bug ID: 66651
Summary: References to non existing named cells inside Formulas
throws exception even with IF/ISERROR
Product: POI
Version: 5.2.3-FINAL
Hardware: PC
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: arieh.kellerm...@profidata.com
Target Milestone: ---
If there is a reference to a non existent named cell in a formula the following
exception is thrown:
"Specified named range 'NAMEVAR' does not exist in the current workbook."
This is also the case if the name is wrapped inside a "ISERROR" or "IFERROR".
There we would expect the same behavior as in Excel, also even if it is just
inserted I'd expect a Name error in the Cell and not a runtime exception,
essentially the same behavior that is present if a formula is set to divide by
0.
Also there if there is a reference to an non existing sheet or external
workbook then one can use:
>FormulaEvaluator#setIgnoreMissingWorkbooks()
to get Excels behavior, but named cells will still fail.
Code to reproduce:
>Workbook workbook = new XSSFWorkbook();
>Cell cell = workbook.createSheet().createRow(0).createCell(0);
>cell.setCellFormula("ISERROR(NAMEVAR)");
--
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 62429] Not Able to read 2016 MS-Excel file Containing TreeMap using InputStreamReader JAVA
https://bz.apache.org/bugzilla/show_bug.cgi?id=62429 PJ Fanning changed: What|Removed |Added Depends on||66650 Referenced Bugs: https://bz.apache.org/bugzilla/show_bug.cgi?id=66650 [Bug 66650] add chartEx schema to poi-ooxml-full -- 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 66650] add chartEx schema to poi-ooxml-full
https://bz.apache.org/bugzilla/show_bug.cgi?id=66650 PJ Fanning changed: What|Removed |Added Blocks||62429 Referenced Bugs: https://bz.apache.org/bugzilla/show_bug.cgi?id=62429 [Bug 62429] Not Able to read 2016 MS-Excel file Containing TreeMap using InputStreamReader JAVA -- 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 --- Comment #2 from PJ Fanning --- I added r1910364 That is just the tip of the iceberg because we will now need to go through all the jars and see what happens after clean builds - if the jars are the same or if they are different and what are the differences. With our slow and complicated build, that is going to be time consuming and quite tedious. -- 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
--- Comment #1 from PJ Fanning ---
In Gradle, we have
https://docs.gradle.org/current/userguide/working_with_files.html#sec:reproducible_archives
Enabling the configs seems relatively easy. Then, we will need to see if the
output jars are reproducible and work through the issues.
tasks.withType(AbstractArchiveTask).configureEach {
preserveFileTimestamps = false
reproducibleFileOrder = 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 66644] Make Apache POI binaries reproducible
https://bz.apache.org/bugzilla/show_bug.cgi?id=66644 Dominik Stadler changed: What|Removed |Added OS||All 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 66644] New: Make Apache POI binaries reproducible
https://bz.apache.org/bugzilla/show_bug.cgi?id=66644 Bug ID: 66644 Summary: Make Apache POI binaries reproducible Product: POI Version: unspecified Hardware: PC Status: NEW Severity: normal Priority: P2 Component: POI Overall Assignee: dev@poi.apache.org Reporter: dominik.stad...@gmx.at Target Milestone: --- There are various efforts underway to make binaries of open source software reproducible. For Java, there is https://github.com/jvm-repo-rebuild/reproducible-central with tools and procedures to check if Java libraries are reproducible and to see if there are changes necessary to make it reproducible. Let's do a first run with current Apache POI binaries and the tooling to see where we include non-reproducible content. At least the following might pop up: * Version number/build-date injected into sources at build time * generated JavaDoc? * Generated ooxml-sources See the following resources for getting started: * https://github.com/jvm-repo-rebuild/reproducible-central/blob/master/doc/TOOLS.md * https://reproducible-builds.org/docs/jvm/#configuring-build-tools-for-reproducible-builds * -- 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 66629] Formula evaluator returns wrong result form sumif formula
https://bz.apache.org/bugzilla/show_bug.cgi?id=66629 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 66611] XSSFFormulaUtils::updateFormula omits column fixation when only used with column definitions
https://bz.apache.org/bugzilla/show_bug.cgi?id=66611 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 66632] Incorrect default char width in SheetUtil.getDefaultCharWidth()
https://bz.apache.org/bugzilla/show_bug.cgi?id=66632 Dominik Stadler changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #1 from Dominik Stadler --- Good Catch! This is likely one of the reasons why autosized columns often are larger than what Excel or LibreOffice do when you auto-size columns. I was planning to taking a look at why this is the case as it bugs me in some of my use-cases for Apache POI as well. Applied via r1910301 We now use the Math.round(), but maybe we should use the float-value directly and not round to int at all as we later on handle text-width as double anyway. But at least this way should be a bit better in some cases 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 66632] Incorrect default char width in SheetUtil.getDefaultCharWidth()
https://bz.apache.org/bugzilla/show_bug.cgi?id=66632 Dominik Stadler changed: What|Removed |Added Summary|Incorrect dafault char |Incorrect default char |width |width in ||SheetUtil.getDefaultCharWid ||th() -- 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 66632] Incorrect dafault char width
https://bz.apache.org/bugzilla/show_bug.cgi?id=66632 Artem changed: What|Removed |Added Summary|Incorrect char width|Incorrect dafault char ||width -- 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 66632] New: Incorrect char width
https://bz.apache.org/bugzilla/show_bug.cgi?id=66632 Bug ID: 66632 Summary: Incorrect char width Product: POI Version: unspecified Hardware: PC OS: Linux Status: NEW Severity: normal Priority: P2 Component: SS Common Assignee: dev@poi.apache.org Reporter: polyakov0...@bk.ru Target Milestone: --- In class SheetUtil at row 302 "(int)layout.getAdvance()" i think must be "(int)Math.round(layout.getAdvance())" -- 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 66628] Read excel file with restricted access: no such entry: "EncryptionInfo", had: [EncryptedPackage,
https://bz.apache.org/bugzilla/show_bug.cgi?id=66628 PJ Fanning changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #1 from PJ Fanning --- All I can find is https://stackoverflow.com/questions/74155698/issues-when-trying-to-open-an-xlsx-restricted-file-org-apache-poi-openxml4j-exc (first answer). If you can provide a sample file, maybe someone can look at it. The POI Community is no longer very active. -- 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 66629] New: Formula evaluator returns wrong result form sumif formula
https://bz.apache.org/bugzilla/show_bug.cgi?id=66629
Bug ID: 66629
Summary: Formula evaluator returns wrong result form sumif
formula
Product: POI
Version: 5.2.2-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: dev@poi.apache.org
Reporter: bkacper...@stratoflow.com
Target Milestone: ---
Created attachment 38579
--> https://bz.apache.org/bugzilla/attachment.cgi?id=38579=edit
file for demonstrating problem
Hi,
I found a problem with sumif formula evaluation. When I evaluate formula in
cell B1 from attached file it returns unexcpected result of -36197273.86898398.
Same cell displays value -36197273.86898400 when it is opened in excel. I
created simple test that demonstrate this problem:
public void test() {
Resource parseableResource = new
ClassPathResource("ApachePOI-sumif.xlsx");
InputStream parseableInput = parseableResource.getInputStream();
byte[] parseableFile = toByteArray(parseableInput);
Workbook workbook = WorkbookReader.read(parseableFile);
FormulaEvaluator evaluator = workbook.getCreationHelper()
.createFormulaEvaluator();
DataFormatter dataFormatter = new DataFormatter();
Sheet sheet = workbook.getSheetAt(0);
Cell cell = sheet.getRow(0).getCell(1);
assertThat(dataFormatter.formatCellValue(cell, evaluator))
.isEqualTo("-36197273.86898400");
}
This test fails on last assert.
--
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 66628] New: Read excel file with restricted access: no such entry: "EncryptionInfo", had: [EncryptedPackage,
https://bz.apache.org/bugzilla/show_bug.cgi?id=66628 Bug ID: 66628 Summary: Read excel file with restricted access: no such entry: "EncryptionInfo", had: [EncryptedPackage, Product: POI Version: 5.2.2-FINAL Hardware: PC OS: Mac OS X 10.1 Status: NEW Severity: normal Priority: P2 Component: POI Overall Assignee: dev@poi.apache.org Reporter: avinash89.cha...@gmail.com Target Milestone: --- Created attachment 38578 --> https://bz.apache.org/bugzilla/attachment.cgi?id=38578=edit restricted access How do I read an excel with restricted access? Don't mistake this with password protected excel file. I am trying create a java program to read a file where "Full Control" is given only to the owner and "Everyone in my organisation" has read access. Refer to the attached picture. I can open the file in windows as I am a part of "Everyone in my organisation" This request refers to the following topic created on Stackoverflow (more details can be found here): https://stackoverflow.com/questions/47048144/read-excel-file-with-restricted-access-no-such-entry-encryptioninfo-had-e#:~:text=Usually%20an%20EncryptedPackage%20stream%20is%20accompanied%20by%20an,thrown.%20This%20is%20unrelated%20to%20the%20file%20permissons. NOTE: While debugging I also noticed that despite the file being a ".xlsx" file fileMagic returns it as OLE2 format. Is there a possibility to handle sensitivity labels in POI? If no, are there any plans to implement the feature in future? Thanks, Avinash -- 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 66625] Unable to sign a docx file multiple times
https://bz.apache.org/bugzilla/show_bug.cgi?id=66625 Rodrigo changed: What|Removed |Added CC||rcc.d...@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 66625] New: Unable to sign a docx file multiple times
https://bz.apache.org/bugzilla/show_bug.cgi?id=66625 Bug ID: 66625 Summary: Unable to sign a docx file multiple times Product: POI Version: 5.2.3-FINAL Hardware: PC Status: NEW Severity: normal Priority: P2 Component: POIFS Assignee: dev@poi.apache.org Reporter: rcc.d...@gmail.com Target Milestone: --- Created attachment 38573 --> https://bz.apache.org/bugzilla/attachment.cgi?id=38573=edit Code that produces the exception (while executing the second loop block) Hi everyone. I am trying to sign a docx document repeatedly, but I am at a loss. The `setAllowMultipleSignatures` option is allowing me to sign the document multiple times as long as I don't close the package. If I close the package and reopen it to try to sign it again, the following exception is thrown: `java.lang.NullPointerException: Cannot invoke "org.apache.poi.openxml4j.opc.PackagePart.getContentType()" because "pp2" is null at org.apache.poi.poifs.crypt.dsig.facets.OOXMLSignatureFacet.addManifestReferences(OOXMLSignatureFacet.java:176) at org.apache.poi.poifs.crypt.dsig.facets.OOXMLSignatureFacet.addManifestObject(OOXMLSignatureFacet.java:110) at org.apache.poi.poifs.crypt.dsig.facets.OOXMLSignatureFacet.preSign(OOXMLSignatureFacet.java:96) at org.apache.poi.poifs.crypt.dsig.SignatureInfo.preSign(SignatureInfo.java:383) at org.apache.poi.poifs.crypt.dsig.SignatureInfo.confirmSignature(SignatureInfo.java:225)` I am attaching my code. I guess the mere `java.lang.NullPointerException` exception is enough reason to report this as a bug. Any help is appreciated. -- 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 66620] Heap dump when using SXSSF for large XLSX files containing RichTextStrings
https://bz.apache.org/bugzilla/show_bug.cgi?id=66620 --- Comment #2 from PJ Fanning --- You could try poi-shared-strings - it has supports keeping the shared strings in a temp file to avoid the memory overhead. https://github.com/pjfanning/poi-shared-strings. SXSSF sample in https://github.com/pjfanning/poi-shared-strings-sample -- 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 66620] Heap dump when using SXSSF for large XLSX files containing RichTextStrings
https://bz.apache.org/bugzilla/show_bug.cgi?id=66620
--- Comment #1 from Tonny ---
Comment on attachment 38567
--> https://bz.apache.org/bugzilla/attachment.cgi?id=38567
Export of many RichTextStrings with font styles To Excel
>package com.foo.export;
>
>import java.io.FileOutputStream;
>import java.io.OutputStream;
>
>import org.apache.poi.ss.usermodel.CreationHelper;
>import org.apache.poi.ss.usermodel.Font;
>import org.apache.poi.ss.usermodel.IndexedColors;
>import org.apache.poi.ss.usermodel.RichTextString;
>import org.apache.poi.ss.usermodel.Row;
>import org.apache.poi.ss.usermodel.Sheet;
>import org.apache.poi.xssf.streaming.SXSSFCell;
>import org.apache.poi.xssf.streaming.SXSSFWorkbook;
>import org.apache.poi.xssf.usermodel.XSSFFont;
>import org.apache.poi.xssf.usermodel.XSSFWorkbook;
>
>public class ExportToExcelTest {
>
> /**
>* Test which created a number of rows in an Excel document using SXSSF.
>* Each of the RichTextStrings in the cells are unique.
>*
>* The test is used to show that SXSSF can export RichTextString's, but
> it has a problem as
>* it require it to use SharedStringsTable. This cause memory
> consumption to explode as the
>* structure used to store the strings are not cleared for the rows
> which are flushed.
>*/
> public static void main(String[] args) throws Exception {
>
>// final int NUMBER_OF_ROWS_TO_CREATE = 1000; // Works OK
> final int NUMBER_OF_ROWS_TO_CREATE = 60; // Breaks on my
> system as it gives an 'Exception in thread "main" java.lang.OutOfMemoryError:
> Java heap space'
>
> //
> // Create Workbook
> //
>
> // In order to be able to apply font styles on RichTextStrings
> we need to keep the strings in memory.
> // This is a huge disadvantage as the memory consumption will
> increase greatly as the structure containing
> // the strings are not reduced/cleared when the rows are
> flushed.
> SXSSFWorkbook wb = new SXSSFWorkbook(null, 100, false, true);
>// SXSSFWorkbook wb = new SXSSFWorkbook(new XSSFWorkbook(), 100,
>false, true); // Seems to result in the same as the above
>
> //
> // Create fonts used in test
> //
>
> // Create font with font 'Impact' and color dark blue
> XSSFFont font1 = (XSSFFont) wb.createFont();
> font1.setFontName("Impact");
> font1.setColor(IndexedColors.DARK_BLUE.getIndex());
>
> // Crete font with font 'Arial' and color light blue
> XSSFFont font2 = (XSSFFont) wb.createFont();
> font2.setFontName("Arial");
> font2.setColor(IndexedColors.LIGHT_BLUE.getIndex());
>
> // Create bold font
> XSSFFont font_bold = (XSSFFont) wb.createFont();
> font_bold.setBold(true);
>
> // Create italic font
> XSSFFont font_italic = (XSSFFont) wb.createFont();
> font_italic.setItalic(true);
>
> // Create font with double underline and red color
> XSSFFont font5 = (XSSFFont) wb.createFont();
> font5.setUnderline(XSSFFont.U_DOUBLE);
> font5.setColor(IndexedColors.RED.getIndex());
>
> // Create sub script font
> XSSFFont font_sub = (XSSFFont) wb.createFont();
> font_sub.setTypeOffset(Font.SS_SUB);
>
> // Create super script font
> XSSFFont font_super = (XSSFFont) wb.createFont();
> font_super.setTypeOffset(Font.SS_SUPER);
>
> //
> // Create a sheet to put the rows into
> //
> Sheet sheet = wb.createSheet();
>
> //
> // Create X rows with almost the same data
> //
> for (int i = 0; i < NUMBER_OF_ROWS_TO_CREATE; ++i) {
> CreationHelper creationHelper = wb.getCreationHelper();
>
> Row row = sheet.createRow(i);
> int column = 0;
>
> // Create cell for content with RichText in it
> SXSSFCell cell_1 = (SXSSFCell) row.createCell(column++);
>
> // Rich text string with two fonts applied - one used
> in two places
> RichTextString richString =
> creationHelper.createRichTextString("JavaCodePoint " + i);
> richString.applyFont(0, 4,
[Bug 66620] New: Heap dump when using SXSSF for large XLSX files containing RichTextStrings
https://bz.apache.org/bugzilla/show_bug.cgi?id=66620 Bug ID: 66620 Summary: Heap dump when using SXSSF for large XLSX files containing RichTextStrings Product: POI Version: 5.2.3-FINAL Hardware: PC OS: Linux Status: NEW Severity: normal Priority: P2 Component: SXSSF Assignee: dev@poi.apache.org Reporter: t.greger...@elsevier.com Target Milestone: --- Created attachment 38567 --> https://bz.apache.org/bugzilla/attachment.cgi?id=38567=edit Export of many RichTextStrings with font styles To Excel If you create Excel (XLSX) files using SXSSF and you want to have font attributes (e.g. sub and superscript) applied to sub parts of a string then you have to use RichTextStrings. Currently, it is only possible to get it to work with SXSSF if you set the parameter 'useSharedStringTable' to 'true' on the SXSSFWorkbook. Setting 'useSharedStringTable' to 'true' will make it store the strings in memory in a structure which encapsulates the string. The problem is that when the Workbook flush its rows it does not clear the structure containing the string data. Hence, it piles up when you export many rows and may eventually result in a heap dump depending on the number of rows being exported and the available memory. When using SXSSF and 'useSharedStringTable' set to 'true' then it should clear the underlying structure for the rows which has been flushed in order to keep memory consumption low. I've attached a little Java example which can be used to reproduce 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 66590] Number of blocks used by the property table missing from the file header
https://bz.apache.org/bugzilla/show_bug.cgi?id=66590 --- Comment #4 from Emmanuel Bourg --- The fix is incomplete, according to the CFB specification the number of directory sectors must be set to zero for files using the format version 3 (with 512 byte sectors). I'll update the 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 66614] The OFFSET function cannot handle cells after the 257th column
https://bz.apache.org/bugzilla/show_bug.cgi?id=66614 PJ Fanning changed: What|Removed |Added Resolution|--- |FIXED 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 66614] The OFFSET function cannot handle cells after the 257th column
https://bz.apache.org/bugzilla/show_bug.cgi?id=66614 --- Comment #1 from PJ Fanning --- I added r1910049 and will see if this builds ok - I ran some of the tests but will let the CI build do the full check. -- 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 66614] New: The OFFSET function cannot handle cells after the 257th column
https://bz.apache.org/bugzilla/show_bug.cgi?id=66614 Bug ID: 66614 Summary: The OFFSET function cannot handle cells after the 257th column Product: POI Version: 5.2.3-FINAL Hardware: All OS: All Status: NEW Severity: normal Priority: P2 Component: SS Common Assignee: dev@poi.apache.org Reporter: kabeya...@cabinetwork.jp Target Milestone: --- In /java/org/apache/poi/ss/formula/functions/Offset.java There is a line: private static final int LAST_VALID_COLUMN_INDEX = 0xFF; So OFFSET doesn't work if the result column > 0xFF. (Also the rows are restricted to 0x) -- 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 66029] poi 5.0 generated xlsx file RUN TO EMAIL APPENDS .TXT TO OUTPUT
https://bz.apache.org/bugzilla/show_bug.cgi?id=66029 Rakhi Barayanan 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 66029] poi 5.0 generated xlsx file RUN TO EMAIL APPENDS .TXT TO OUTPUT
https://bz.apache.org/bugzilla/show_bug.cgi?id=66029 --- Comment #23 from Rakhi Barayanan --- Hi team, Could see STANDALONE="NO" IN XML BEHIND THE EXCEL OUTPUT FROM latest poi,this also causing corruption issues in the 3rd party applications when accessing the file. Is there a way to remove this? -- 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 66607] Slow method: XSSFSheet.isCellInArrayFormulaContext
https://bz.apache.org/bugzilla/show_bug.cgi?id=66607 PJ Fanning changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED --- Comment #3 from PJ Fanning --- let's close this 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 66612] Macrosheet not found in xslm sheets
https://bz.apache.org/bugzilla/show_bug.cgi?id=66612 --- Comment #4 from 1u...@protonmail.com --- (In reply to PJ Fanning from comment #3) > I tested your xlsm file and this code seems to get the macrosheet part > > String relType = > "http://schemas.microsoft.com/office/2006/relationships/xlMacrosheet;; > PackageRelationshipCollection prc = > workbook.getPackagePart().getRelationships(); > assertNotNull(prc); > assertEquals(6, prc.size()); > PackageRelationshipCollection prc2 = > prc.getRelationships(relType); > assertNotNull(prc2); > assertEquals(1, prc2.size()); > > workbook.getPackage() checks the wrong relationships - you need > workbook.getPackagePart().getRelationships() Thanks, I get macrosheets part like this, but if I try to removeRelationship then document doesn't open. Do you have a solution for that? And yes stackoverflow question is mine. -- 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 66612] Macrosheet not found in xslm sheets
https://bz.apache.org/bugzilla/show_bug.cgi?id=66612 --- Comment #3 from PJ Fanning --- I tested your xlsm file and this code seems to get the macrosheet part String relType = "http://schemas.microsoft.com/office/2006/relationships/xlMacrosheet;; PackageRelationshipCollection prc = workbook.getPackagePart().getRelationships(); assertNotNull(prc); assertEquals(6, prc.size()); PackageRelationshipCollection prc2 = prc.getRelationships(relType); assertNotNull(prc2); assertEquals(1, prc2.size()); workbook.getPackage() checks the wrong relationships - you need workbook.getPackagePart().getRelationships() -- 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 66612] Macrosheet not found in xslm sheets
https://bz.apache.org/bugzilla/show_bug.cgi?id=66612 --- Comment #2 from PJ Fanning --- 1umos - is this you? https://stackoverflow.com/questions/76306947/how-to-get-xlm-macro-sheet-from-excel-with-apache-poi-xssfworkbook Seems similar but seems to suggest that you can get relationships of this type - while maybe running into issues removing 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 66612] Macrosheet not found in xslm sheets
https://bz.apache.org/bugzilla/show_bug.cgi?id=66612 PJ Fanning 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 66612] Macrosheet not found in xslm sheets
https://bz.apache.org/bugzilla/show_bug.cgi?id=66612
--- Comment #1 from PJ Fanning ---
Have you tried
getRelationshipsByType("http://schemas.microsoft.com/office/2006/relationships/xlMacrosheet;)
- from a quick check of the POI code, getRelationshipsByType expects strings
like this - not 'content types'
--
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
