Results 1 to 2 of 2
  1. #1
    rogerl is offline Member
    Join Date
    Jun 2012
    Posts
    1
    Rep Power
    0

    Default Do HSSF & XSSF support in-memory formula evaluation?

    Hi,

    I understand that POI HSSF & XSSF components allow one to create and read excel files. They do not support in-memory formula evaluation. In other words, in order to find the SUM of a range, one has to create an Excel file, launch Excel to read the file and calculate the SUM, then save the file. When POI reads the file back, it can access the calculated SUM.

    Is my understanding correct?

    Thanks in advance.

    - roger

  2. #2
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,091
    Rep Power
    20

    Default Re: Do HSSF & XSSF support in-memory formula evaluation?

    Nope.
    As the documentation for formula's clearly states:
    "The code currently provides implementations for all the arithmatic operators. It also provides implementations for approx. 140 built in functions in Excel."

    Also, Excel does not store the reuslts of a formula. That would make no sense.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Similar Threads

  1. Replies: 3
    Last Post: 06-28-2012, 12:33 PM
  2. Spanish supoprt in formula evaluation
    By ARANATE in forum Apache POI
    Replies: 0
    Last Post: 04-16-2012, 05:41 PM
  3. HSSF: Html to Text conversion
    By xtech in forum Advanced Java
    Replies: 1
    Last Post: 04-17-2008, 08:45 AM
  4. APACHE HSSF on Netbeans
    By dgajudo in forum NetBeans
    Replies: 2
    Last Post: 12-10-2007, 04:04 AM
  5. Autofilter and POI-HSSF
    By nefarius in forum JDBC
    Replies: 0
    Last Post: 09-23-2007, 03:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •