Bug 68298 - SXSSF hyperlink shows as 0
Summary: SXSSF hyperlink shows as 0
Status: NEEDINFO
Alias: None
Product: POI
Classification: Unclassified
Component: SXSSF (show other bugs)
Version: unspecified
Hardware: PC Linux
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-12-06 07:53 UTC by shadowslayerhero
Modified: 2024-02-25 12:45 UTC (History)
2 users (show)


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description shadowslayerhero 2023-12-06 07:53:26 UTC 
I am using apache poi 3.11, I converted to SXSSF instead of XSSF but I noticed that hyperlink text display is not working and is just showing as `0` but the cell contains the Hyperlink formula.


I Noticed that on MS Excel it displays as 0 but with other software (Open office, online google sheets) I can still see the hyperlink text even with SXSSF
Comment 1 PJ Fanning 2023-12-06 08:39:38 UTC 
POI 3.11 was released in 2014. Please use another version. Version 5.2.5 was released recently. If the issue can be reproduced with a recent version of POI, please reopen this - but provide a full set of steps to reproduce the issue.
Comment 3 shadowslayerhero 2024-01-04 07:17:17 UTC 
Hi, I tried updating my apache poi version from 3.11 to 5.2.5

Gradle Dependencies:

implementation 'org.apache.poi:poi-ooxml:3.11'

to

implementation 'org.apache.poi:poi-ooxml:5.2.5'


I am still encountering the issue when I use SXSSF instead of XSSF
Comment 4 Dominik Stadler 2024-02-25 12:45:50 UTC 
Can you provide sample files and self-sufficient test-code which allows to  reproduce this?