Geek Answers Handbook

Can I copy an Excel formula using an office add-in?

I managed to create a fully functioning taskbar add-in for Excel 2013 using Visual Studio Pro 2013, and I have many test functions that all work well, such as adding data, creating bindings, creating tables, etc. Now I want to do something very simple in Excel that adds to a new column and then copies the column to the left of it into a new column. In excel, this will copy the whole formula, and cell reference links that are relational will be well wrapped in the new column. (For example, A1 could become = B1) Is there a way to do this using javascript? The only alternative I can come up with is to add an empty column to the new column and recreate all the information and formulas from scratch in javascript, and then add the formatting, which is an extremely long alternative for something that Excel does so well with a simple copy and paste (special) thanks Stu

+4
source share
1 answer

Thank you for posting your question here. Unfortunately, a copy and a special paste are not yet available. But we recognize the importance of this API and study it. I'm afraid while we study this, you will have to rebuild the column using JavaScript. But be sure to check out dev.office.com and the developer blogs as we are actively working on adding additional APIs to Excel.

If you have other API requests, you can send them to officepdev.uservoice.com.

Thanks Sky

+1
source

More articles:


All Articles