this post was submitted on 05 Feb 2026
663 points (99.0% liked)
Memes
14617 readers
1994 users here now
Post memes here.
A meme is an idea, behavior, or style that spreads by means of imitation from person to person within a culture and often carries symbolic meaning representing a particular phenomenon or theme.
An Internet meme or meme, is a cultural item that is spread via the Internet, often through social media platforms. The name is by the concept of memes proposed by Richard Dawkins in 1972. Internet memes can take various forms, such as images, videos, GIFs, and various other viral sensations.
- Wait at least 2 months before reposting
- No explicitly political content (about political figures, political events, elections and so on), !politicalmemes@lemmy.ca can be better place for that
- Use NSFW marking accordingly
Laittakaa meemejä tänne.
- Odota ainakin 2 kuukautta ennen meemin postaamista uudelleen
- Ei selkeän poliittista sisältöä (poliitikoista, poliittisista tapahtumista, vaaleista jne) parempi paikka esim. !politicalmemes@lemmy.ca
- Merkitse K18-sisältö tarpeen mukaan
founded 3 years ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
That’s actually pretty terrible. Can you load the csv and then save it again as an xls? Once it’s loaded, why does it care what the source format was?
the original doc has the math, the csv only has the pre-calculated numbers
you cant recover lost data by just resaving in another format lol
As soon as you convert from an .XLS file to a .CSV file, the data and sig figs used to display that data are saved while the math formulas used to calculate that data are erased.
This means that when you try to go from .CSV to .XLS, Excel doesn't know the original formula that created the data to then be able to display more decimal points. The formula is absolutely necessary to change sig figs of displayed data.
The only other way I can think of that would allow one to change sig figs in .CSV data is if the .XLS file was converted with like the maximum number of sig figs displayed, or let's say 10-20. Then in a .CSV, you can modify the sig figs to something less, like 0-20.
But I want to say that if you save that .CSV file after the sig fig change, where you original converted it with 10-20 sig figs but then changed them to 0-20, the .CSV overwrites the data and you lose the sig figs that you concatenated.
Result: adding decimal points in a .CSV isn't possible.
I think you misunderstood the problem.
Is the problem that someone else is wrong and we want to relish in the agony of dealing with it?