Slice created template contains undelete-able hidden worksheetes
Version Information (please complete the following information):
- Operating System: [Windows 10 ]
- TM1 Version: [PA 2.0.9.15]
- Browser: [N/A]
- Arc clients: [Desktop]
- Arc Version: [3.4]
- Excel Version: [Office 365 64 bit]
Describe the bug
When creating templates using Slice, it always contain a hidden worksheet, which will be causing issues when performing export from TM1Web, that it would display 2 worksheets instead of 1.
On the workbook, trying to unhide the template but it is not possible to unhide anything.
The unnecessary worksheet is causing exporting from TM1Web would easily hitting TM1Web's limitation while it is not yet close to the limit.
To Reproduce
Steps to reproduce the behavior:
- Create a template, maybe with SUBNM or something with Picklist.
- Upload to TM1 via Slice
- Open in TM1Web
- Export (Slice/Snapshot)
Expected behavior
Options:
- Allow us to delete the hidden worksheet manually before upload.
- Slice does not create additional worksheet.
- While upload to TM1, Slice automatically delete the Slice created hidden worksheet. (Similar to delete the unnecessary rows for AF before upload)