poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 59652] New: FormulaParseException from whitespace
Date Wed, 01 Jun 2016 18:25:18 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=59652

            Bug ID: 59652
           Summary: FormulaParseException from whitespace
           Product: POI
           Version: 3.14-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: scott.paffrath@gmail.com

Both HSSF and XSSF throw this exception now when there is whitespace between
elements and closing parenthesis. I jumped from 3.12 to 3.14 so not sure if
this was in 3.13 or not.

    public static void main(String[] args)
    {
        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet sheet = wb.createSheet();
        Row row = sheet.createRow(0);

        Cell cell = row.createCell(0);
        cell.setCellFormula("(4 + 2)"); // This works

        cell = row.createCell(1);
        cell.setCellFormula("( 4 + 2)"); // This works

        cell = row.createCell(2);
        cell.setCellFormula("(4 + 2 )"); // FormulaParseException
    }

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