I've looked and not found an answer to this yet. I assume the functionality is available right now, though, given the blog from 7 years ago about copy and pasting from Excel.
We have clients who frequently change the formulas they use to calculate quantities and costs based on those quantities, so it's imperative that the formula persist during a copy from their working sheets.
Our worksheet setup is now more aligned to the demo at www.igniteui.com/.../loading-data.
Thank you for posting in the Infragistics community!
I am not sure I understand what you need to achieve completely. I see that you have placed a Spreadsheet on the page, and there is also a workbook defined with JS code, that is visualized by the Spreadsheet.
Do you users need to be able to copy formulas from the Spreadsheet formula bar ? If this is the case, I believe this is currently working fine, which makes me think there is more to your scenario that I am missing. Please provide more details around it in order to make me able to help you.
Looking forward to hearing from you.
Our spreadsheets (to be copied) contain formulas which are not persisted to the columns they appear in. I have enabled the formula bar, but the only way to get the existing formula into the cell is to copy the formula directly (in the formula bar in Excel), one cell at a time. Our customers are expecting to copy thousands of rows at a time for integration into the db.