Hi All, I am using excel.link to work seemslessly with Excel.
In addition to values, like numbers and strings, I would like to insert a full operational formula into a cell. xlc["G14"] <- print(paste("=G9*100/G6"), quote = FALSE) The strings is put into the cell, but the cell is not evaluated. Thus the string is show as result of the computation. If I open that cell b pressing "F2" or by double-clicking the cell and pressing RETURN will start the evaluation of the expession. xlc["G14"] <- parse("=G9*100/G6") # does not run How can I put a formula into Excel that is evaluated right away? Kind regards Georg ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.