Hi Peter, I am using Rob Laveau plugins called XL Plugin with great success. Pretty simple to use. For example, your formula would translate to this.
$formula:="=("+xlSheetRowColumnToAddress ($sheet;$row;$col;$RowRelative;$ColRelative)+"+"+xlSheetRowColumnToAddress ($sheet;$row;$col;$RowRelative;$ColRelative)+")" xlSheetSetCellFormula ($sheet;$row;3;$formula) I think there is a way to do something similar with Miyako's XLS plugin. Luc Devar ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************