Thanks Chris, I just pasted a very long URL directly into excel and it worked just fine. The URLs am using are dynamically built and am wondering if this is a bug in POI.
Sam Maina Web Developer Knovel Corporation (607) 773 1840 ext 670 [EMAIL PROTECTED] -----Original Message----- From: Chris Cheshire [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 1:49 PM To: POI Users List Subject: Re: HYPERLINK formula problems Sam, There are a couple of options here, depending on what level access you have to the application you are linking to. 1) Is the URL a static URL, and not dynamically built? If so, make a "tiny url" (www.tinyurl.com) out of it, and insert it into the cell 2) If you can modify the web application without disrupting it, change it so the URLs are smaller. However, if both of these situations don't apply, then you are stuck because if Excel won't accept the long URL, then POI won't help either :( Chris Sam Maina wrote: > 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=20 8 >>7 >>40003 >><http://www.knovel.com/knovel2/Show_HotLink.jsp?RecordID=208740003&Lin k > > 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=10 1 > > 10 > <http://www.knovel.com/knovel2/Show_HotLink.jsp?SpaceID=10110&NodeID=1 > 88 > >>4630966&RecordID=208740003&LinkID=208747112&SetID=5412523&Maina=small_ >>s > > t > >>ructure\> >>&NodeID=1884630966&RecordID=208740003&LinkID=208747112&SetID=5412523&M >>a > > 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] > > > --------------------------------------------------------------------- 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]
