poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 58106] unreadable content after remove formula
Date Fri, 04 Dec 2015 15:39:24 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=58106

Dominik Stadler <dominik.stadler@gmx.at> changed:

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

--- Comment #2 from Dominik Stadler <dominik.stadler@gmx.at> ---
Not sure how we can solve this, it would require to "transpose" the formula
from one Cell to the next one depending on the reference in the Formula of the
removed cell

We can detect this case with the following in XSSFWorkbook.onDeleteFormula(),
but I am not sure how we would go about fixing this :(

    protected void onDeleteFormula(XSSFCell cell){
        if(calcChain != null) {
            // TODO: check for shared formulas!
            CTCellFormula f = cell.getCTCell().getF();
           
if(f.getT().equals(org.openxmlformats.schemas.spreadsheetml.x2006.main.STCellFormulaType.SHARED)
&&
                    f.getRef() != null && 
                    f.getStringValue() != null) {
                // shared formula and needs adjustment as the formula is stored
here...
                System.out.println("Need to adjust for shared formula here!");
            }

            ...
        }
    }

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