Yes that's was typo. So it would be right to say that Excel formula is limited to a certain length? Does anyone have any idea how I can work around this?
Sam Maina Web Developer Knovel Corporation (607) 773 1840 ext 670 [EMAIL PROTECTED] -----Original Message----- From: Srinadh Karumuri [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 1:02 PM To: POI Users List Subject: Re: HYPERLINK formula problems It's probably a typo but I see that there is a missing '\' in the first link after HYPERLINK( BTW, I copy pasted the second function in excel and it complains that the formula is too long. Hope it helps. Sri At 04:23 PM 2/25/2004, you wrote: >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=208 >7 >40003 ><http://www.knovel.com/knovel2/Show_HotLink.jsp?RecordID=208740003&Link I >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=101 10 <http://www.knovel.com/knovel2/Show_HotLink.jsp?SpaceID=10110&NodeID=188 >4630966&RecordID=208740003&LinkID=208747112&SetID=5412523&Maina=small_s t >ructure\> >&NodeID=1884630966&RecordID=208740003&LinkID=208747112&SetID=5412523&Ma i >na=small_structure\",\"view link\")"; > >Sam Maina --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
