Try wrapping it in SUM()
-----Original Message-----
From: mouss4rs [mailto:[email protected]]
Sent: Thursday, March 01, 2012 10:57 AM
To: [email protected]
Subject: How to write the Formula of division with 2007 excel files and
POI
Hi,
Everything is said in the subject.
I would like to divide the contents of a cell by the other one.
I do this:
row2.setRowNum(20);
cell2 = row2.createCell(8);
*cell2.setCellFormula("I3/B3");* cellStyle = wb2.createCellStyle();
AND I WHEN I OPEN MY FILE
http://apache-poi.1045710.n5.nabble.com/file/n5528227/erreur.jpg
I READ THIS:
This cell(unit) is inconsistent with the formula of column.
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/How-to-write-the-Formula-of-divisi
on-with-2007-excel-files-and-POI-tp5528227p5528227.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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
