Scheduler
- Fix – REST API call GET or POST with password would always fail with invalid password when task is locked with password.
- Add – Excel Action has new option to Delete Hidden Worksheets. (Note this should only be done if it does not break formula. This enhances data security when you wish to remove Sheets that are not related to the final Excel output.
- Add – Excel Action has new option to override the Active Worksheet
- Add – Excel Action has new option to run Excel as a Service.
Engine
- Change – Company Consolidation in Query Builder sometimes raised a SQL collate error when Database had different Correlate Pages. Previously Sharperlight only applied collate logic to non-Unicode fields but on some environments, this was not enough. Now the logic is applied to all text columns even Unicode columns
Web Channel
- Add – URL Parameter called lockOutputs that allows Writeback Grid Columns to be set as ready only. For example &lockOutputs=Name1+Name2..(n)