Sheet assign problem
Posted: Fri May 10, 2019 8:03 am
Hi,
i'm using the XLSSpreadSheet component and I want to copy a sheet from XLSSpreadSheet.XLS.Sheets (XSS) to another XLSReadWrite componenet (XLS) through this code:
XLS.Sheets[0].Assign(XSS.XLS.Sheets[0]);
but if the source sheet contains a cell with formula, sheet.assign command raise an error like "Formula is compiled".
Can you help me ?
Thank you very much!
Massimo
i'm using the XLSSpreadSheet component and I want to copy a sheet from XLSSpreadSheet.XLS.Sheets (XSS) to another XLSReadWrite componenet (XLS) through this code:
XLS.Sheets[0].Assign(XSS.XLS.Sheets[0]);
but if the source sheet contains a cell with formula, sheet.assign command raise an error like "Formula is compiled".
Can you help me ?
Thank you very much!
Massimo