You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2023/12/06 07:53:26 UTC

[Bug 68298] New: SXSSF hyperlink shows as 0

https://bz.apache.org/bugzilla/show_bug.cgi?id=68298

            Bug ID: 68298
           Summary: SXSSF hyperlink shows as 0
           Product: POI
           Version: unspecified
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: SXSSF
          Assignee: dev@poi.apache.org
          Reporter: shadowslayerhero@gmail.com
  Target Milestone: ---

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 68298] SXSSF hyperlink shows as 0

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=68298

PJ Fanning <fa...@yahoo.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |INFORMATIONPROVIDED
             Status|NEW                         |RESOLVED

--- Comment #1 from PJ Fanning <fa...@yahoo.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 68298] SXSSF hyperlink shows as 0

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=68298

--- Comment #2 from PJ Fanning <fa...@yahoo.com> ---
also posted here -
https://stackoverflow.com/questions/77610950/why-do-sxssf-hyperlink-show-as-0-in-excel-but-contains-cell-data-compared-to-xss

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 68298] SXSSF hyperlink shows as 0

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=68298

Dominik Stadler <do...@gmx.at> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |NEEDINFO

--- Comment #4 from Dominik Stadler <do...@gmx.at> ---
Can you provide sample files and self-sufficient test-code which allows to 
reproduce this?

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 68298] SXSSF hyperlink shows as 0

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=68298

Matafagafo <ma...@yahoo.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |matafagafo@yahoo.com

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 68298] SXSSF hyperlink shows as 0

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=68298

shadowslayerhero@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|INFORMATIONPROVIDED         |---
             Status|RESOLVED                    |REOPENED

--- Comment #3 from shadowslayerhero@gmail.com ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 68298] SXSSF hyperlink shows as 0

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=68298

shadowslayerhero@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |shadowslayerhero@gmail.com

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org