Reading information from Formulas

[Pedro Miguel Ribeiro Martins <pe...@gmail.com>]

Hi everyone:

I need to parse a formula and see which cells it uses.
More concretely, I need to see if any of the cells a formula
uses is empty. How can I do this? I have been checking the 
FormulaParse classes, but it is for POI internal use only and
hard to use.

Can anyone help me?
Thanks in advance:
Pedro Martins

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: Reading information from Formulas

[Jon Svede <js...@yahoo.com>]

Pedro,

I might have some code that would help, let me review it and if it would suit your purpose, I'll forward you the details.

Jon







>________________________________
> From: Pedro Miguel Ribeiro Martins <pe...@gmail.com>
>To: POI Users List <us...@poi.apache.org> 
>Sent: Wednesday, October 17, 2012 8:40 AM
>Subject: Reading information from Formulas
> 
>Hi everyone:
>
>I need to parse a formula and see which cells it uses.
>More concretely, I need to see if any of the cells a formula
>uses is empty. How can I do this? I have been checking the 
>FormulaParse classes, but it is for POI internal use only and
>hard to use.
>
>Can anyone help me?
>Thanks in advance:
>Pedro Martins
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
>For additional commands, e-mail: user-help@poi.apache.org
>
>
>
>