You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2011/02/10 19:14:20 UTC

DO NOT REPLY [Bug 50755] New: getCellFormula throws Not implemented yet on 2nd use of =WORKDAY()

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

           Summary: getCellFormula throws Not implemented yet on 2nd use
                    of =WORKDAY()
           Product: POI
           Version: 3.7
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: dread@hp.com


Created an attachment (id=26634)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=26634)
sample .xlsx containing workday formula on a few rows

Similar to Bug 46537, but with what I think is a native Excel formula, WORKDAY.
This code (copied from that bug, but modified slightly), and the attached file,
should demonstrate the problem:

Sheet sheet = wb.getSheet("Sheet1");
for(Row aRow : sheet)
{
    Cell cell = aRow.getCell(1);
    String formula = cell.getCellFormula();
    System.out.println("formula: " + formula);
}

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


DO NOT REPLY [Bug 50755] getCellFormula throws Not implemented yet on 2nd use of =WORKDAY()

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=50755

Nick Burch <ni...@alfresco.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #1 from Nick Burch <ni...@alfresco.com> 2011-02-10 13:22:22 EST ---
WORKDAY is not supported yet. You'll need to add support for it, then please
send in a patch

If you're not sure how to go about adding a new function, please ask on the dev
list.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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