Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

i don't know why spreadsheet applications don't standardise on a file extension that they won't screw with. call it csf or something. treat it like pure CSV except don't interpret =/@ or any of the other weirdness. basically just interpret all fields as plain strings as default [even if they look like numbers]. this way everything is backwards compatible old 'weird CSV' files still work and those that care about their users can use .csf and the files won't endanger their users.


Yeah or they could just make "mangle my CSV files" an option buried in the config somewhere. I'd even open up regedit.


That would make safety an "opt in" measure, it should be "opt out" instead. Make the CSV format stop interpreting formulas unless you specifically ask it to. Most people don't put formulas in their CSV files anyway.


The CSV format doesn't interpret anything, it's spreadsheet applications doing that.


Sorry if I was unclear, that was exactly what I meant - applications that open CSV files.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: