Reading formula with ParseExcel

[Bijitendra Mittra]

Hi,

Is there any plan to support reading formula from a cell rather than
it's final value? This will help me in rewriting XLS files in which
there are columns which contain both formula and user inputs (after
deleting the formula).

Thanks in advance,
Bijit

[jmcnamara]

On Monday, February 27, 2012 11:32:01 AM UTC, Bijitendra Mittra wrote:

Hi,

Is there any plan to support reading formula from a cell rather than
it's final value? This will help me in rewriting XLS files in which
there are columns which contain both formula and user inputs (after
deleting the formula).

Hi,

It is planned but it is non-trivial (it required the formula do be deparsed from binary RPN to the string representation) so it probably won't happen in the short term.

Regards,

John.

-- 

 

Thanks in advance,
Bijit