I have to set up a Java environment to do the unit test. (I'm working Clojure, primarily.) Let me see if I can't get it going along with some other POI-related stuff I'm doing.
On Tue, Oct 11, 2016 at 4:44 PM, Javen O'Neal <javenon...@gmail.com> wrote: > 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" <blake.wat...@pnmac.com> 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 > > blake.wat...@pnmac.com <melanie.petros...@pnmac.com> > > www.PennyMacUSA.com <http://www.pennymacusa.com/> > > > -- *Blake Watson* *PNMAC* Application Development Manager 5898 Condor Drive Moorpark, CA 93021 (805) 330.4911 x7742 blake.wat...@pnmac.com <melanie.petros...@pnmac.com> www.PennyMacUSA.com <http://www.pennymacusa.com/>