Can you create a simple file in Excel and set your formula with BDP to a cell.
Then create the same output using POI.
Unzip these two files and use diff to find what differs. This should give you
an idea what is missing.
As a quick solution, try just to set the formula string omitting all other
attributes:
newCell.getCTCell().addNewF().setStringValue(cell.getCellFormula());
Yegor
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!
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
