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
> > "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
> > 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
> > 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/>
Application Development Manager
5898 Condor Drive
Moorpark, CA 93021
(805) 330.4911 x7742