Link to home
Start Free TrialLog in
Avatar of abuyusuf
abuyusuf

asked on

Using org.apache.poi to generate Excel spreadsheet - hyperlink throws dialog box

Hi - We are using the org.apache.poi from Java code to generate an excel spreadhseet with two tabs - there is a hyperlink on the first tab which links to the second one - the link argument is defined as follows

String linkFormula = "HYPERLINK(\"#'ERROR REPORT'!B2\", \"Failed Reason\")";

When the hyperlink is clicked we get a dialog box which states 'The document has been modified do you want to save the changes' even though no modifications have been made to the spreadsheet. Is there a way to suppress this dialog box ?

Thanks
Avatar of abuyusuf
abuyusuf

ASKER

Anyone has any ideas on this one ?
Perhaps you can attach an example of the spreadsheet with such link?
ASKER CERTIFIED SOLUTION
Avatar of Mick Barry
Mick Barry
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial