Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: tokens and scientific notation

tokens and scientific notation 5 years 3 months ago #59438

  • tapirul
  • tapirul's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 6
  • Karma: 0
hello all,

i don't know if this can be considered a bug (guess not) but i run into this recently.

i've created a random table of tokens on my survey, limited to 5 characters, and then downloaded them as .csv into excel, to be sent to each individual participant. to my surprise some tokens did not download correctly, the reason being that Excel interpreted them as scientific notation, so (for example) the token 497e6 was recorded by Excel as 497000000.

i've manually changed the tokens back.

what would be a good practice to avoid that?

thanks a lot
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.263 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form