Graphics

 View Only
  • 1.  Datalinq and Excel decimal issue

    Posted 03-17-2016 17:16
    I apologize if this is covered elsewhere. I didn't have any luck finding it.

    We have a datalinq issue...in excel our box one stat box reads .900 and in Xpressions it gives us a .9 with no zeros. I can't seem to figure out why this is happening. All the stats with numbers other than 0 are working correctly.

    Any help would be appreciated!


  • 2.  RE: Datalinq and Excel decimal issue

    Posted 03-24-2016 20:07
    I assume if a cell has .123 it works fine? But .100 does not?

    This script on the text object OnSetText should fix it:

    dim num as double
    num = val(Text)
    Text = num.ToString("0.000#")
    #XPression


  • 3.  RE: Datalinq and Excel decimal issue

    Posted 02-23-2017 07:30
    Thanks Garner, I just encountered the same problem, did a search and your script fixed it for me.
    #XPression