Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

HypRetrieveRange - Excel Formatting not retained

edited Aug 2, 2018 2:36AM in Essbase 1 comment

Summary

HypRetrieveRange - Excel Formatting not retained

Content

I am using the Smartview API to connect a sheet and retrieve data from the cube.  The connection works, data retrieves but it retrieves using Cell Styles instead of Excel Formatting.  I have tried the various codes to set the formatting (HypSetGlobalOptions etc), which do set the formatting to Excel Formatting, but it still retrieves using styles.  Is there another VBA code that sets the options for the multi-grid retrieval? Or are there options somewhere else that need to be changed?

SV Version: 11.1.2.5.610

Connection Type: Essbase

Office: 2013 64 bit

I have tried:

  '  x = HypSetGlobalOption(1, True)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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