poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 45206] New: sumproduct formula returning #VALUE
Date Sun, 15 Jun 2008 00:12:41 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=45206

           Summary: sumproduct formula returning #VALUE
           Product: POI
           Version: unspecified
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: kayamkulamkochunni@gmail.com


The following example is not an array product. When you create an excel file
and use the following forumula, we see a #VALUE. However if you click on the
cell and press enter, the number gets populated. I am guessing this is some
kind of bug related to the unique way this formula works. 

=SUMPRODUCT(('SHEET1'!C3:C751=Summary!F22)*('SHEET1'!D3:D751=Summary!G22),'SHEET1'!AF3:AF751)


-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

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


Mime
View raw message