Formula error

[Die Hard]

Hi,

I am able to write the formula's correctly to the Excel files, however
when the formula references another formula cell, the result is
"#VALUE". I will have to manually go to the specific cell and enforce
Excel to parse it. I don't change anything, but need to do a manual
step.

Is there anyway I could do the same directly thru the perl code/
library.

Appreciate your help.

Thanks,
Saeed

[jmcn...@cpan.org]

On Jun 3, 12:45 pm, Die Hard <siha...@gmail.com> wrote:
> Hi,
>
> I am able to write the formula's correctly to the Excel files, however
> when the formula references another formula cell, the result is
> "#VALUE". I will have to manually go to the specific cell and enforce
> Excel to parse it. I don't change anything, but need to do a manual
> step.

Hi,

This is a common problem for certain types of formulas. If you google
in this group you will find some workarounds.

If not then post a small self contained and working example and I will
suggest a workaround.

John.
--