Export and show Data round 0.5 to 1

[Steffen-F]

Hey there!

So what did i try?
I used range_ticks 0,12,0.5 to get data.
But when i looked at my data with the implemendet show data button, all numbers were rounded.
So 0.5 went straigt up to 1.
Same diffculties with exporting the data als xls and csv.

But when you look at the detailed data, in formr. numbers are not rounded.

attached ist a survey you can use to reproduce my problem.

Testsheet.xlsx

Greetings Yeso

[cyriltata]

Dear Steffen, I think the formatting happens only at the level of excel and maybe you will need to manually format the cells when you open the file with your spreadsheet client. best Cyril

…

On Thu, Mar 5, 2020 at 11:27 AM Yesowitsch ***@***.***> wrote: Hey there! So what did i try? I used range_ticks 0,12,0.5 to get data. But when i looked at my data with the implemendet show data button, all numbers were rounded. So 0.5 went straigt up to 1. Same diffculties with exporting the data als xls and csv. But when you look at the detailed data, in formr. numbers are not rounded. attached ist a survey you can use to reproduce my problem. Testsheet.xlsx <https://github.com/rubenarslan/formr.org/files/4292374/Testsheet.xlsx> Greetings Steffen — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#442?email_source=notifications&email_token=AARL5Z76OB2XYHGENNPSBETRF55BRA5CNFSM4LCGUVBKYY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4ISXKLNA>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AARL5Z5KFGRY65NY3FXIO5LRF55BRANCNFSM4LCGUVBA> .

[Steffen-F]

Dear Cyril,

Thanks for your answer! I tried a little bit and came to this point:

the following things didn`t help:
Exporting it as pdf and reading it with the Windows10 texteditor. -> Only integers-
opening it in excel and formatting cells to number cells. -> Only integers
Exporting it as csv and opening it in Windows10 texteditor. -> Onyl integers.

Point is: When i go on show results, where formr shows me my results, its only integers aswell.
So maybe its the way, formr stores the data of range_tickes?

Best
Yeso

[cyriltata]

Dear Yeso Can you try using JSON export? best Cyril

…

On Fri, Mar 13, 2020 at 9:28 AM Yesowitsch ***@***.***> wrote: Dear Cyril, the following things didn`t help: Exporting it as pdf and reading it with the Windows10 texteditor. -> Only integers- opening it in excel and formatting cells to number cells. -> Only integers Exporting it as csv and opening it in Windows10 texteditor. -> Onyl integers. Point is: When i go on show results, where formr shows me my results, its only integers aswell. So maybe its the way, formr stores the data of range_tickes? Best Yeso — You are receiving this because you commented. Reply to this email directly, view it on GitHub <#442 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AARL5Z3MCM6KTRC4TIZFYZ3RHHVC3ANCNFSM4LCGUVBA> .

[cyriltata]

Closing this issue as it is stale

[rubenarslan]

I could reproduce this. The number-type items do their own thing determining a result field, which was being overridden by the getResultField function.

@Steffen-F if you lost real data this way, the proper answers should still be recoverable from the "detailed results", which were not affected by this bug.

[Steffen-F]

Hey Ruben,

I did not loose real data, i went over "detailed results" as you mentionend.
Good to hear it was a bug and got fixed!