|
14
|
Macro Names
|
Macro names are being renamed automatically after running macro through step processor. Reason being is, there are some words reserved by Microsoft Excel. Now when we user any of those names as macro name in excel workbook, and run that macro using 'Run Macro' instruction, then given macro name gets renamed with prefixing _ character.
|
Try to avoid using macro name that is short and alphanumeric. For example, 'ABC123'. 'ABC123' is cell address in Excel 2007. If you have macro with similar kind of name, then please rename it with 'ABC_123'.
|
Limitation of Software at this stage.
|
|
292, 324
|
Excel File Manipulation
|
Due to internal technical issues some of the file instruction fails with either "unidentified" or "unsupported file" error message when excel file type is of *.xlsx or *.xlsm with macro, chart or image in it.
|
Convert file to *.xls. Reupload the file, and run the instruction again.
|
Known Limitation
|
|
460
|
Copy Cell Value
|
Copy cell value copies source range's value as #NAME in target worksheet, when source range contains IFERROR() formula. This is known limitation of the function at the moment. However, please use the suggested workaround until issue has been addressed properly.
|
Instead of using formula as =IFERROR(A1,0), please use =IF(ISERROR(A1),"Has Error",A1).
|
Known Limitation.
|
|
898
|
Command buttons and other ActiveX controls in *.xlsx and *.xlsm files
|
For some Excel files (*.xlsx and *.xlsm) ActiveX controls are removed after the file has been processed by some instructions.
The reason for this is that current versions of Microsoft Excel save ActiveX controls in a non-standardised language called VML, and this language is not supported by the technologies that manipulate the underlying Excel data.
Note that “Form controls” are not impacted by this issue. When adding buttons, list boxes and links to a spreadsheet, you can do this with either ActiveX controls or Excel Form controls. They look and behave similarly, however Form controls will not be impacted by this issue. We advise clients that are manipulating files with controls in them to use Form as opposed to ActiveX controls.
|
Workaround is in two steps.
1. Convert file into *.xls format.
2. Convert ActiveX control to the form control. For example - ActiveX Command button to normal form button, and reconfigure the associated macros.
|
Known Limitation
|
|
1211
|
Excel File Manipulations with OFFSET range
|
Excel file instructions cannot identify the given range that uses the OFFSET function to define the named range.
|
Use alternative formula.
|
In Progress.
|
|
1251
|
Access file manipulation
|
Access instructions are unable to run queries with NZ( ) on access database.
|
Alternative of NZ( ) is IsNull( ) function.
|
Known Limitation
|
| 977 |
PIVOT Tables Drop out |
For excel files, PIVOT tables are removed from file after file has been processed by some instructions. Excel file only preseves data of the PIVOT Tables. |
There are 2 instructions Copy Pivot Table, and Refresh Pivot table available in the Excel instructions library. These two instructions are used to copy pivot table from template file to working file after performing all operations on working file.
|
Fixed by introducing Copy Pivot Table instruction. |