HsSetValue is submitting other non-selected worksheet
SummaryHsSetValue is submitting other non-selected worksheet
Target Application: HFM 18.104.22.168.501.4628
SmartView version: 22.214.171.124.620 (Build 122)
OS version: Windows 10
Excel version: Microsoft Office 365 ProPlus Version 1701 (Build 7766.2096)
- WorksheetA: HsSetValue is getting numbers by referring to number from WorksheetA only
- WorksheetB: HsSetValue is getting numbers by referring to number from WorksheetB
If I submit WorksheetA (select and open WorksheetA), it will submit WorksheetA and also all HsSetValues that refer to WorksheetA for number.
If I submit WorksheetB (select and open WorksheetB), it will only submit WorksheetB as expected.
Is the behavior that I got from submitting WorksheetA by design or a bug?