Thanks Mark for the quick response.
I did consider going the java regular expression route but then there might
be corner case of the regex matching a string within a normal formula...
which is actually not external... something like the below formula...
=CONCATENATE("abc","def","'[1]Monthly Consolidated'!$C$1")
As you mentioned, I will try to see if I can fine tune regex matching to see
if I can come up with a pattern but if you look at the example above... I
took exactly the example of formula text returned for an external formula
and used it in a simple formula like concatenate(). Though it can be debated
that the above formula is not very useful, I think you follow my broader
point about not being able to identify anything in the formula that seems to
be very unique to have a proper regular expression.
Really appreciate your time... and let me know if you think you have a
regular expression pattern which might resolve only external formulae
uniquely.
Thanks.
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Detect-External-Reference-in-Formula-tp5652011p5652149.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
