5 ms·
Excel's handling of CSV's pisses me off. It will modify the actual file when you open it, even if you don't save. The entire office suite is horrible when it c
by Declanomous 10y ago
Excel's handling of CSV's pisses me off. It will modify the actual file when you open it, even if you don't save.
The entire office suite is horrible when it comes to preserving user data though. Access will change sql queries if you look at the code and close the query without saving or modifying anything. It's especially annoying when the query no longer works because Access 'helpfully' removed some parenthesis.
- antisthenes 10y agoDo you know if LibreOffice modifies csv files in this manner, or is it 'safe' ?
- pdwetz 10y agoI've never had it modify an opened file without me explicitly saving it.
- curt15 10y agoWhat happens if you mark the file read-only?
- bartread 10y agoI've never had that happen and I open a lot of CSVs in Excel.
- spollo 10y agoI don't think excel will change the file if you dont save. But, weirdly excels CSV issues are a more mac-specific program. MSFT insists that mac has a different format for csvs and will constantly destroy csvs, change formatting, unquote fields, merge columns together, insert random unicode characters, screwed up line endings, etc if you save on mac and aren't careful. I've actually noticed msft has changed the default csv output format in excel mac twice over the past month (including making the csv default format be TSV??) which is pretty ridiculous. I just want them to comma seperate, quote fields if necessary, and properly escape characters. Don't insert random characters or fuck with encodings. How hard could it be?
- pjmlp 10y ago> MSFT insists that mac has a different format for csvs Mac had a different format for CSVs, and actually Excel started its life as a Mac product.
- WalterBright 10y agoI just write a simple custom program to deal with my CSV's :-)
- jdc0589 10y agoI don't doubt it, but the bit about excel was sarcasm, it doesn't exist in our workflow.