Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

jxlsUtils has error, jxls2.12.0 depend on org.apache.poi4.1.2 which is conflict to org.apache.poi5.0.0 #235

Closed
littlehBinBin opened this issue Mar 15, 2023 · 3 comments
Closed

jxlsUtils has error, jxls2.12.0 depend on org.apache.poi4.1.2 which is conflict to org.apache.poi5.0.0 #235

littlehBinBin opened this issue Mar 15, 2023 · 3 comments
Assignees
@SoltauFintel

Comments

@littlehBinBin
Copy link

image

Caused by: java.lang.NoSuchMethodError: org.openxmlformats.schemas.spreadsheetml.x2006.main.CTRst.xgetT()Lorg/openxmlformats/schemas/officeDocument/x2006/sharedTypes/STXstring;
@littlehBinBin littlehBinBin added the bug Something isn't working label Mar 15, 2023
@SoltauFintel
Copy link
Member

JXLS class PoiCellData calls cell.setCellType(getPoiCellType(targetCellType)); and setCellType is marked for removal in POI 5. We should change that.

@leonate see chat

@SoltauFintel
Copy link
Member

see PR #246

@SoltauFintel SoltauFintel removed the bug Something isn't working label May 18, 2023
@SoltauFintel SoltauFintel self-assigned this May 18, 2023
@SoltauFintel SoltauFintel mentioned this issue May 18, 2023
Merged
@Sivakumar-finoli Sivakumar-finoli mentioned this issue May 26, 2023
Closed
SoltauFintel added a commit that referenced this issue Jun 29, 2023
@SoltauFintel
#235 POI 5.2.3 (#247)
7ab4de7 
* To Support latest version of Apache Poi
1. Modified POM dependencies of Apache POI to 5.2.3 from 4.1.2
2. Removed dependency ooxml-schemas & added dependency of poi-ooxml
3. Updated commons-compress version to 1.22 from 1.21
4. Modified code to remove usage of deprecated functions - setCellType, cellTypeEnum & getFontIndexAsInt
5. Ensured that all the test cases pass - Double Value in IssueB116Test had to be changed
6. Changed project version to 2.13.0-SNAPSHOT

* Removed Duplicate dependency of slf4j.version
* Change Gradle file dependencies - Not Tested
* Update XlsCommentAreaBuilder.java
* Typo
* remove not called method, version 2.13.0 also for Gradle
* set to pull_request only, so we don't have 4 checks

---------

Co-authored-by: Sivakumar
@SoltauFintel
Copy link
Member

We advise against using POI 5.2.3. POI 5.2.2 can be used. An Apache POI bug ticket 66687 has been created.

SoltauFintel added a commit that referenced this issue Jul 14, 2023
@SoltauFintel
#235 POI 5.2.2
3a44f64 
- PR #257
- Don't use 5.2.3!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@SoltauFintel SoltauFintel

Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@SoltauFintel @littlehBinBin