smartview number to word loses number formatting — 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

smartview number to word loses number formatting

Received Response
41
Views
1
Comments
edited Feb 12, 2024 5:14PM in EPM Platform and Freeform 1 comment

Summary:

When retrieving a numeric value in Smartview, copying the datapoint and pasting it into Word, the formatting is not retained.

Content :

Steps:

  1. ad hoc sheet in Excel Smartview
  2. styles are on Excel Formatting
  3. Number looks like € 1.125 in Excel
  4. Excel Smartview / Edit / Copy
  5. Word Smartview / Edit / Paste
  6. Refresh document
  7. Number retrieved: 1125,00000000
  8. Toggle Field Code shows the following
Toggle Field Code: {= HsGetValue("", "Years#2022", "Period#December", "Account#investeringsverplichtingen voor de aanschaf van vaste activa")|SmartView17074724504|_ [$€-813] * #.##0_ ;_ [$€-813] * -#.##0_ ;_ [€] * "-"??_ ;_ @_ |||}


When selecting the Update Field then I get an error message, but still keeps refreshing correctly.

!Syntax Error, (

This question looks very much like

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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