i did as u recommended. This is my formulas: <xml-fragment t="shared" ref="Q2:Q9" ca="1" si="1" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships";>IF(ISNUMBER(BDP($B2,$Q$1)*$R2),BDP($B2,$Q$1)*$R2, 0)</xml-fragment> <xml-fragment t="shared" ref="T2:U21" ca="1" si="2" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships";>BDP($C2,T$1)</xml-fragment>
i make as: newCell.getCTCell().setF(oldCell.getCTCell().getF()); but when i open the document, Microsoft Excel says me that i have a wrong data (Удаленные записи: Сведения о ячейках из части /xl/worksheets/sheet1.xml) and dont' display anything in new row! may i have to set something else? Thanks! -- View this message in context: http://apache-poi.1045710.n5.nabble.com/POI-3-7-can-t-get-formula-tp3246256p3248022.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
