1. A row has smart markers in some of the columns and has formulas defined for the other columns. If I load multiple row data using designer.Process() by setting a datatable as the datasource, how do I get the formulas/validations etc to be retained for the corresponding cell in the new rows that get created as a result.
2. I have an excel file which has smart markers defined in some of the sheets. Can I load data using the designer as well as by not using the designer (for other sheets or columns which do not have smart markers) simultaneously.
3. A cell has a validation defined to pick from a list. How do I define a smart marker for that cell
3. How do I copy a row or a cell (which has formula defined in it) and paste (or insert) it in a location of choice and also preserve the formula.