poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 53314] Invalid Formula Cell Reference for named ranges referring to whole columns
Date Thu, 31 May 2012 08:20:06 GMT

--- Comment #8 from Mark B <markbrdsly@tiscali.co.uk> ---

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message