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

abuyusuf
abuyusuf used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Anyone has any ideas on this one ?
Awarded 2011
Awarded 2011

Commented:
Perhaps you can attach an example of the spreadsheet with such link?
Java Developer
Top Expert 2010
Commented:
I don't believe there is. Its a new document so it must be saved.
You may be better off having the user download it directly to disk

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial