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
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
Perhaps you can attach an example of the spreadsheet with such link?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER