Sounds like a bug in the formula parser to me. Could you open a bug with a unit test and relevant example workbook to reproduce this issue? If you have time to look through the code to see why this is breaking it would expedite a resolution. Otherwise, someone else may have time to find out why hyphenated sheet names are not getting processed correctly.
On Oct 11, 2016 3:16 PM, "Blake Watson" <[email protected]> wrote: > 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/> >
