jxl jxl keenanbr (Programmer) (OP) 12 Oct 11 10:04 I don't think this is possible but thought I'd ask. A cell's value is calculated based on a formula e.g. A2=A1*3. Change A1 value CODENumber number = new Number(0,0,6); //set A1 to 6workSheet.addCell(number);System.out.println(workSheet.getCell(0,1).getContents()));expect output to be 18 RE: jxl TonHu (Programmer) 13 Oct 11 16:15 Have a look at [url=http://poi.apache.org/]Apache POI[/url], that supports both .xls and .xlsx Excel formats, but also evaluation of most of the Excel functions (but not user-defined-functions)Grab the latest beta (3.8 beta 4) for testing/trying, it's feature rich, quite stable, and will be released quite soon.POI is a little less simple to get implemented then jxl (it has several jars that need to be on the classpath) but it's much more powerful, and actually future-safe, as it's being actively developed, and also supports Office 2007/2010 file formats. RE: jxl keenanbr (Programmer) (OP) 14 Oct 11 03:54 Thanks, I have downloaded it but haven't had a chance to try it yet.