SUMPRODUCT does not readily produce correct value

I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.

Posted on 2007-06-12 17:19:32-07 by ccbc

It is required to perform a dummy update to the cell before Excel will compute/display correct result. The problem was oberved with MS Excel 2002 and 2007, although each version had unique reactions. Open Office, on the other hand, has no problem displaying the correct result right from the start, without intervention. Thought the problem might be the entire column range, so tried variations: in the write_formula call: =SUMPRODUCT((DATA!K:K>=DATEVALUE("1/01/2007"))*(DATA!K:K<DATEVALUE("2/01/2007"))*(LEFT(DATA!D:D,3)="3.1")) =SUMPRODUCT((DATA!K2:K200>=DATEVALUE("3/01/2007"))*(DATA!K2:K200<DATEVALUE("4/01/2007"))*(LEFT(DATA!D:D,3)="3.0")) =SUMPRODUCT((DATA!K2:K200>=DATEVALUE("1/01/2007"))*(DATA!K2:K200<DATEVALUE("2/01/2007"))*(LEFT(DATA!D2:D200,3)="3.0"))

Direct Responses: 5444 | Write a response

Posted on 2007-06-14 22:20:53-07 by jmcnamara in response to 5424

Re: SUMPRODUCT does not readily produce correct value

Hi,

Can you please post your question to the Spreadsheet::WriteExcel Google-Group.

And can you format it as a small self contained example program. This will help me to respond more quickly. See the bug_report.pl program as an example.

Thank you,

John.
--

Direct Responses: Write a response