5 ms·
My only serious gripe with OnlyOffice is that when opening a CSV, you have to choose an encoding and delimiter, and there is no way to set a default. You must c
by dhc02 3y ago
My only serious gripe with OnlyOffice is that when opening a CSV, you have to choose an encoding and delimiter, and there is no way to set a default. You must click twice, in two places, every single time you open a CSV.
- Hitton 3y agoI've just tried opening csv in LibreOffice and it asked me for it too. However sane options were already selected so it was just one additional click.
- PrayagBhakar 3y agoYou have to do this with Excel as well to avoid your data automagically being formatted and/or truncated.
- ale42 3y agoSo true... opening a CSV in Excel is like playing the lottery. Sometimes it opens fine, sometimes not, it even depends on the character encoding of the CSV and whether you double-click the file, open it or drag it inside Excel. Sometimes you get the "import text file" window where you have to choose the delimiter, sometimes everything gets in a single column, and sometimes you get what you want.
- ElectricalUnion 3y agoCSV is not a standard (rfc4180 exists but only very few things actually pay attention to it) so no behavior is a sane behavior when trying to import it.
- stonogo 3y agoYou sound like a C compiler. "This is technically undefined behavior so whatever" is not a useful guiding principle for user interfaces.
- ElectricalUnion 3y agoA normal user interface would guide you away from using CSV in the first place. In almost all situations where one could use CSV, a better, more structured, more standards-compliant, more optimized file format (like a SQLite database) would be a better choice.
- stonogo 3y agoIn situations where people are opening a CSV file in an office-suite spreadsheet app, they probably didn't generate the data themselves. Lecturing them about how their spreadsheet should have been a database isn't likely to help, and describing SQLite's file format, which is well-documented but not a standard, as "more standards-compliant" than a file format with an actual RFC is bordering on ridiculous.
- ElectricalUnion 3y agoThe Library of Congress, an agency of the legislative branch of the U.S. government thinks that SQLite3 [1] is a acceptable database format. The Library of Congress has a small amount of SQLite files in its collections. The Library of Congress also cites CSV [2], Comma Separated Values, as strictly specified in RFC 4180 as a acceptable dataset format. No other types of free-form CSV that aren't variants compliant with 4180 are accepted, and it also says that documentation and metadata needs to be supplied with additional separated archives in supported data formats. The Library of Congress has 0 CSVs in its collections, and as a result no experience actually handling it. I believe that if a widespread format such as CSVs have 0 files added to a reasonably well known and encompassing collection of human artifacts related to culture even with its ubiquity, it's a telltale sign that it isn't a standard at all. [1] https://www.loc.gov/preservation/digital/formats/fdd/fdd000461.shtml https://www.loc.gov/preservation/digital/formats/fdd/fdd0004... [2] https://www.loc.gov/preservation/digital/formats/fdd/fdd000323.shtml https://www.loc.gov/preservation/digital/formats/fdd/fdd0003...
- stonogo 3y ago
- tbeiwhsj 3y ago[dead]