[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-dev
Subject:    [Bug 55145] New: #VALUE! error in RANK formula
From:       bugzilla () apache ! org
Date:       2013-06-26 10:52:26
Message-ID: bug-55145-47293 () https ! issues ! apache ! org/bugzilla/
[Download RAW message or body]

https://issues.apache.org/bugzilla/show_bug.cgi?id=55145

            Bug ID: 55145
           Summary: #VALUE! error in RANK formula
           Product: POI
           Version: 3.9
          Hardware: PC
            Status: NEW
          Severity: major
          Priority: P2
         Component: HSSF
          Assignee: dev@poi.apache.org
          Reporter: najh.ru@gmail.com

After executing the code

    public static void main(String args[]) throws IOException {
      //with #VALUE! error (1)
      createExample(new FileOutputStream("1.xls"), new HSSFWorkbook()); 

      //no error           (2)
      createExample(new FileOutputStream("1.xlsx"), new XSSFWorkbook());
    }

    private static void createExample(FileOutputStream file, Workbook wb)
throws IOException {
        Sheet sh = wb.createSheet("sheet");
        Row row = sh.createRow(0);
        Cell cell1 = row.createCell(0);
        cell1.setCellValue(100);
        Cell cell2 = row.createCell(1);
        cell2.setCellFormula("RANK(A1,(A1:A1),0)");
        wb.write(file);
    }


we've got the following result for line (1)
the #VALUE! error in the generated excel file. 
This error could be corrected manually if we position the cursor into the
formula bar and press "Enter".

For line (2) there is no error.

-- 
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

[prev in list] [next in list] [prev in thread] [next in thread]