[Bug 59652] New: FormulaParseException from whitespace

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 59652] New: FormulaParseException from whitespace

Bugzilla from bugzilla@apache.org
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: [hidden email]
          Reporter: [hidden email]

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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 59652] FormulaParseException from whitespace

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=59652

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All
         Depends on|                            |58648
             Status|NEW                         |NEEDINFO

--- Comment #1 from Dominik Stadler <[hidden email]> ---
Sounds like a duplicate of 58648, can you try with a nightly build from
https://builds.apache.org/view/POI/job/POI/lastSuccessfulBuild/artifact/build/dist/
to verify that your cases were also fixed by these changes.

--
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 59652] FormulaParseException from whitespace

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=59652

--- Comment #2 from [hidden email] ---
It is a duplicate and the nightly build fixes it. Thank you.

--
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 59652] FormulaParseException from whitespace

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=59652

Dominik Stadler <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |RESOLVED
         Resolution|---                         |DUPLICATE

--- Comment #3 from Dominik Stadler <[hidden email]> ---
Fixed by the fix for bug 58648.

*** This bug has been marked as a duplicate of bug 58648 ***

--
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 59652] FormulaParseException from whitespace

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=59652
Bug 59652 depends on bug 58648, which changed state.

Bug 58648 Summary: FormulaParser throws exception in parseSimpleFactor() when getCellFormula() is called on a cell and the formula contains spaces between closing parentheses ") )"
https://bz.apache.org/bugzilla/show_bug.cgi?id=58648

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |UNCONFIRMED
         Resolution|FIXED                       |---

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 59652] FormulaParseException from whitespace

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=59652
Bug 59652 depends on bug 58648, which changed state.

Bug 58648 Summary: FormulaParser throws exception in parseSimpleFactor() when getCellFormula() is called on a cell and the formula contains spaces between closing parentheses ") )"
https://bz.apache.org/bugzilla/show_bug.cgi?id=58648

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |FIXED

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]