是否可以使用office插件复制excel公式?

I have managed to create a fully functioning task pane add-in for Excel 2013 using Visual Studio Pro 2013 and I have a bunch of test functions that all work nicely, like adding in data, creating bindings, creating tables etc. Now I want to do something that is very simple in Excel, which is add in a new column, then copy the column to the left of it into the new column. In excel this would copy all of the formula and any cell formulas references that are relational would transpose nicely to the new column. (E.g =A1 might become =B1) Is there any way of doing this using javascript? The only alternative I can think of is to add in the new column as a blank column and the rebuild all the information and formulas from scratch in javascript, then add the formatting, which is an extremely long winded alternative for something that Excel does so well with a simple copy and paste (special) thanks StuI have managed to create a fully functioning ta