[Bug 62969] HYPERLINK() function needs a way to return link reference when display label is also specified

2019-03-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62969 --- Comment #6 from Greg Woolsey --- I also came up with a workaround hack just now that I'll document here in case others find it helpful. I had a Cell, whose formula was HYPERLINK(...). It sometimes had one arg, sometimes two. Parsing the

[Bug 62969] HYPERLINK() function needs a way to return link reference when display label is also specified

2018-12-20 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62969 Dominik Stadler changed: What|Removed |Added Severity|normal |enhancement -- You are receiving

[Bug 62969] HYPERLINK() function needs a way to return link reference when display label is also specified

2018-12-03 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62969 --- Comment #5 from PJ Fanning --- My suggestion was to have `public Hyperlink getHyperlink()` which I think is better than `public String getAddress()` because Hyperlink as all the Hyperlink data (URL, display name, etc). -- You are

Re: [Bug 62969] HYPERLINK() function needs a way to return link reference when display label is also specified

2018-12-02 Thread Greg Woolsey
That replacement method is no longer available, and the maps appear to be static, so making a change would affect all threads, so I don't like that option. Perhaps a separate override map local to an evaluator instance would be a possibility, but then it would need to be available in the proper

[Bug 62969] HYPERLINK() function needs a way to return link reference when display label is also specified

2018-12-01 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62969 --- Comment #3 from Dominik Stadler --- Created attachment 36288 --> https://bz.apache.org/bugzilla/attachment.cgi?id=36288=edit Workaround by overloading FunctionEval.functions I had the same problem some time ago and used a workaround by

[Bug 62969] HYPERLINK() function needs a way to return link reference when display label is also specified

2018-11-30 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62969 --- Comment #2 from Greg Woolsey --- Testing in Excel 2016/Office 365 shows that a cell with a formula containing the HYPERLINK() function anywhere in the formula converts the entire cell value to a link. If there is additional formula

[Bug 62969] HYPERLINK() function needs a way to return link reference when display label is also specified

2018-11-30 Thread bugzilla
https://bz.apache.org/bugzilla/show_bug.cgi?id=62969 --- Comment #1 from Greg Woolsey --- Current thinking involves augmenting FormulaEvaluator with a flag (or facility for multiple flags, perhaps an EnumMap?) to control which value is returned by the function in that invocation/evaluation. The