poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sam Maina" <sma...@knovel.com>
Subject HYPERLINK formula problems
Date Wed, 25 Feb 2004 21:23:03 GMT
I am having problems with the HSSFCell setCellFormula() method. I guess
the question is: Is there a limitation on the number of characters that
can  be used with the HYPERLINK formula?
 
This link works:
"HYPERLINK("http://www.knovel.com/knovel2/Show_HotLink.jsp?RecordID=2087
40003
<http://www.knovel.com/knovel2/Show_HotLink.jsp?RecordID=208740003&LinkI
D=208747112&SetID=5412523&Maina=small_structure\>
&LinkID=208747112&SetID=5412523&Maina=small_structure\",\"view link\")"
 
 but this one does not.
"HYPERLINK(\"http://www.knovel.com/knovel2/Show_HotLink.jsp?SpaceID=1011
0
<http://www.knovel.com/knovel2/Show_HotLink.jsp?SpaceID=10110&NodeID=188
4630966&RecordID=208740003&LinkID=208747112&SetID=5412523&Maina=small_st
ructure\>
&NodeID=1884630966&RecordID=208740003&LinkID=208747112&SetID=5412523&Mai
na=small_structure\",\"view link\")";
 
Sam Maina

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message