Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
HsSetValue is submitting other non-selected worksheet — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

HsSetValue is submitting other non-selected worksheet

Received Response
10
Views
12
Comments
edited Aug 2, 2018 2:36AM in Essbase 12 comments

Summary

HsSetValue is submitting other non-selected worksheet

Content

Hi,

Target Application: HFM 11.1.2.3.501.4628

SmartView version: 11.1.2.5.620 (Build 122)

OS version: Windows 10

Excel version: Microsoft Office 365 ProPlus Version 1701 (Build 7766.2096)

I have:

  • 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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!