XSSF Cell setCellFormula corrupts the Excel file

[Shuichen Zhang <zh...@yahoo.com>]

Hi all,
 
The POI xssf turns my hyerlink value below to a shared forumla that corrupts the Excel file. Does anyone know why and how I can prevent this happening?
 
POIs turns the valid hyperlink in a cell (under XML component file):
<c r="L12" s="130" t="str">
<f>HYPERLINK("C:\test\file_name.java","file_name.java")</f>
<v>file_name.java</v> 
</c>
 
To a shared formula, which does not exist in the "calcChain" XML component that corrupts the Excel file:
<c r="L12" s="130" t="str">
<f t="shared" si="3" /> 
<v>file_name.java</v> 
</c>
 
PS: I am using Cell setCellFormula() method to set up the hyperlink.
 
Thanks,
ShuiChen
 

Re: XSSF Cell setCellFormula corrupts the Excel file

[Mark Beardsley <ma...@tiscali.co.uk>]

I do not know why this function is failing you but do know that there are
other ways to create hyperlinks. Take a look here -
http://poi.apache.org/spreadsheet/quick-guide.html#Hyperlinks

Yours

Mark B



--
View this message in context: http://apache-poi.1045710.n5.nabble.com/XSSF-Cell-setCellFormula-corrupts-the-Excel-file-tp5712164p5712177.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org