https://bz.apache.org/bugzilla/show_bug.cgi?id=62969
Bug ID: 62969
Summary: HYPERLINK() function needs a way to return link
reference when display label is also specified
Product: POI
Version: 4.0.x-dev
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: greg.wool...@gmail.com
Target Milestone: ---
This function has special behavior in Excel. It is dynamically displayed as a
link, using the first argument as the target and the second, optional one as
the display text. If there is only one argument, the link address is used for
display.
The POI function currently returns the displayed value, which is correct in
most cases, as that's what the user sees as the cell value.
However, if one wants to display the cell contents in some interactive format,
there is currently no way to get the address from the formula in the presence
of a defined display label, other than to read the raw formula string, parse it
for the first function argument, and then evaluate that string as a formula
value.
While that is possible, it is fragile and requires proper handling of the
complex formula syntax in the raw value.
This issue is to track discussion from the related POI Users email list thread,
and document design decisions and implementation.
--
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
