Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (nike.apache.org: domain of amir.riaz.dwh@gmail.com
 designates 209.85.160.46 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=X8e3+X1G67FF9AnsJunaDXysFOmnkQR4vtCbHpfuzp1nuQHvWz0Uqa46R3x+TD2tFz
         7dZy+zYw7xTTwk/5c0eibX0vb95VI6ud+om8xxkpvaE+7KQsS4ryibCkE6O9Wm8crd1g
         Mj9hM+CjA9CAtxAuHSs5BhZEvRs1AiBk8sScU=
MIME-Version: 1.0
Date: Sat, 9 Jan 2010 17:00:48 +0500
Message-ID: <1d5ba5611001090400y52d7d5e1w558024fa245d035c@mail.gmail.com>
Subject: not able to calculate the formulas properly
From: Amir Riaz <amir.riaz.dwh@gmail.com>
To: user@poi.apache.org
Content-Type: multipart/alternative; boundary=001636b147431754be047cba0e3f

--001636b147431754be047cba0e3f
Content-Type: text/plain; charset=UTF-8

I have the following code to evaluate the formula

switch (cell.getCellType())
        {
            case Cell.CELL_TYPE_FORMULA:
            {
                try
                {
                    CellValue cval = this.evaluator.evaluate(cell);
                    switch (cval.getCellType())
                    {
                        case Cell.CELL_TYPE_NUMERIC:
                        {
                            if (DateUtil.isCellDateFormatted(cell))
                            {

rowData.append(dateFormat.format(cval.getNumberValue()));
                                hasData = true;
                            }
                            else
                            {

rowData.append(numberFormat.format(cval.getNumberValue()));
                                hasData = true;
                            }
                            break;
                        }
                        case Cell.CELL_TYPE_STRING:
                        {

rowData.append(cval.getStringValue().trim().replaceAll("\n", ""));
                            hasData = true;
                            break;
                        }
                        case Cell.CELL_TYPE_BOOLEAN:
                        {
                            rowData.append(cval.getBooleanValue());
                            hasData = true;
                            break;
                        }
                        case Cell.CELL_TYPE_ERROR:
                        {
                            int eval=cval.getErrorValue();
                            if (eval==DIVIDE_BY_ZERO)
                            rowData.append("0");
                            hasData = true;
                            break;
                        }
                        case Cell.CELL_TYPE_BLANK:
                        {
                            rowData.append("");
                            hasData = true;
                            break;
                        }
                    }
                }

after conversion two sheet correct values but the third sheet contain
complex formula and values are not calculate correctly

--001636b147431754be047cba0e3f--