I suppose the right way to create a "cell" with multiple lines in TSV is to use vertical tab char(11) instead of CRLF, but the last time I checked, Excel doesn't handle VT well. (Numbers does).
for CSV with quotes I published https://github.com/miyako/4d-component-csv which follows the various rules explained here https://en.wikipedia.org/wiki/Comma-separated_values https://tools.ietf.org/html/rfc4180 in any case, it doesn't feel right to pretend that CSV or TSV is an Excel spreadsheet. why not at least use XML, if XLS or XLSX is a bit of an overkill? the method has been around since v2004 (introduction of PROCESS 4D TAGS and DOM/SAX XML commands) ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
