Some formulas calc'd, others not

[Calvin]

I am writing a script to convert a plain-text report to Excel but when
I open it in Excel not all of the formulas calculate. In the table
there are some base data, SUMIF()s to give a summation for the table,
and then some formulas that build percents off of the SUMIF()s and
base data. Every single cell is correct as far as what it contains
(data, formulas) and the percentage formulas calculate correctly.
However, the intermediate SUMIF()s show a value of 0 (zero).

If I [F2], [Enter] in a non-calc'd cell then Excel calcs the formula
correctly without having made any actual changes. I tried to bump
Excel by turning Calculation to Manual but that made no change.
Another change I made was to add the formulas after the base data but
that also made no difference.

[Calvin]

More info: changing the SUMIFs to plain SUMs worked as expected. I'm
using the latest Spreadsheet::WriteExcel from cpan and opening them in
Excel 2003 SP3.

[jmcnamara]

On Oct 13, 7:18 pm, Calvin <mandtpr...@gmail.com> wrote:
> I am writing a script to convert a plain-text report to Excel but when
> I open it in Excel not all of the formulas calculate.

Hi Calvin,

It is probably the same parser bug that you may have seen in other
posts here. Search for store_formula and see if that fix works for
you.

If not, post a small example and I'll have a look.

John.
--