POI, hyperlinks, and 2^7

As I mentioned earlier, I am using Jakarta POI to create Excel files.

Earlier I warned:

don't use space characters (or commas or pretty much anything else)

limit sheet names to 31 characters

Well today I discovered another unpleasant limitation. The link label must be 127 characters or fewer. If not, POI may throw an exception or create an unreadable file.

I get the feeling that the formula support in POI is still fresh. Hopefully these limitations won't be permanent!

# posted by Jesse Wilson on Monday, November 15, 2004