poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 42016] New: - Incorrect formula with auto-fill cells (shared formula)
Date Mon, 02 Apr 2007 04:11:56 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=42016>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND·
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=42016

           Summary: Incorrect formula with auto-fill cells (shared formula)
           Product: POI
           Version: 3.0-dev
          Platform: Other
        OS/Version: other
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: trancongkhanh@gmail.com


When the spreadsheet contains more than 6 shared formula cell, the 
getCellFormula function return incorrect result:
  -C1: A$1+B$1
  -C2 from C2: drag from C1 (autofill)
  - using POI to get cells formula:
    C1: A$1+B$1: fine
    C2: A$2+B$2: OPPS!
    C3: A$3+B$3: OPPS!

The expected result is A$1+B$1 for all C1..C7 cells.
The problem occurs for all POI versions.
Please help me to solve this. All my livehood depend on this. Thanks.

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


Mime
View raw message