smartview number to word loses number formatting
Summary:
When retrieving a numeric value in Smartview, copying the datapoint and pasting it into Word, the formatting is not retained.
Content :
Steps:
- ad hoc sheet in Excel Smartview
- styles are on Excel Formatting
- Number looks like € 1.125 in Excel
- Excel Smartview / Edit / Copy
- Word Smartview / Edit / Paste
- Refresh document
- Number retrieved: 1125,00000000
- 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
Tagged:
0