You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When passing an url to a hyperlink inside a formula, yarg thinks that cell numbers are being passed to it inside the formula.
How to repeat:
Create single cell xlsx template with value
=ГИПЕРССЫЛКА("${url}";"${caption}")
Add groove script in the report
def result = []
result.add([
'url' : 'http://localhost:8080/app/open?screen=Doc.edit&item=Doc-0cba74d6-678b-7a60-8952-1d8497714784',
'caption' : 'Random'
])
return result
When you run the report, you will get
java.lang.NumberFormatException: For input string: "8497714784"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:583)
at java.lang.Integer.valueOf(Integer.java:766)
at com.haulmont.yarg.formatters.impl.xlsx.CellReference.<init>(CellReference.java:40)
at com.haulmont.yarg.formatters.impl.xlsx.Range.fromCells(Range.java:51)
When passing an url to a hyperlink inside a formula, yarg thinks that cell numbers are being passed to it inside the formula.
How to repeat:
=ГИПЕРССЫЛКА("${url}";"${caption}")
Test project with example
test.zip
The text was updated successfully, but these errors were encountered: