In my Linking External Workbooks subject, I was coming up with a lot of "Invalid sheetIndex: -1" errors, which I was able to trace to a sheet named "This-Hyphenated-Name With Spaces Too".
If I change it to "ThisHyphenatedNameWithSpacesToo" the link now works, and this is something I've found consistently across POI: No spaces or special characters (except underscore, I think). But if I use the WorkbookUtil createSafeSheetName function and pass it "This-Hyphenated-Name With Space", it comes back with "This-Hyphenated-Name With Space". Sure enough, by the rules, that should be legit. So, what am I missing? Is it just that it's one thing to create references and another to read them? -- *Blake Watson* *PNMAC* Application Development Manager 5898 Condor Drive Moorpark, CA 93021 (805) 330.4911 x7742 [email protected] <[email protected]> www.PennyMacUSA.com <http://www.pennymacusa.com/>
