https://issues.apache.org/bugzilla/show_bug.cgi?id=53314
--- Comment #8 from Mark B <[email protected]> --- Peter, Do not know if I am missing something very obvious and would like to ask you to run a quick test for me please. When you call the getRefersToFormula() method on the Name object, then you would expect to get back a String that looks something like this - 'Sheet1!$A:$A' - if the whole of Column A on Sheet1 had been 'named' by the user. Then, if you pass this String to the constructor of the AreaReference class, you expect to see an exception thrown at that point. Can I ask you to run your code again but with a single addition? Strip the sheet name away from the reference before passing that String to the AreaReference class constructor. So, rather than pass this String 'Sheet1!$A:$A', make your code pass just this please '$A:$A'. My tests indicate that it is the presence of the sheet part that causes the exception to be thrown and I will need to dig around further to nail the problem down. For now, you might be able to run your application by stripping off the sheet part - for both rows and columns hopefully as I have not tested the former yet. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
