Comment on Real Struggle đ
Fuck_u_spez_@sh.itjust.works â¨2⊠â¨days⊠agoYou canât increase the decimal precision beyond the limits of the available data which I think is what OPâs coworker wasnât understanding â unless Iâm the one who misunderstood.
The coworker rounded the numerical data during the conversion from xlsx to csv meaning there was less data in the exported csv than in the original Excel file. They seemed to think the data did still exist in the csv but it was being hidden and that they could simply change the precision to unhide it.
Dave@lemmy.nz â¨2⊠â¨days⊠ago
Ahhh, the excel format keeps the precision but changes the display to 1 decimal. When exported to CSV, only that 1 decimal is exported, so you canât bring back what isnât there. But the original file still has it.
I understand now, thanks! Definitely a coworker problem not an Excel problem then.
deo@lemmy.dbzer0.com â¨2⊠â¨days⊠ago
Nope. Still an excel problem. Why should changing a display option alter the underlying data on export?
Dave@lemmy.nz â¨2⊠â¨days⊠ago
Well, thatâs a good point. However, if I wanted to export a CSV with only one decimal place, it would be mighty annoying if changing it to one in Excel didnât save it like that in the CSV. Unless there was another option to control that.