MobileRead Forums - View Single Post

BetterRed · 10-15-2018, 03:46 AM

I suspect the problems you perceive are caused by multi-line comments, here is the text for the test.csv shown in Notepad++ (I used a small font to eliminate word wrap)

Click image for larger version

Name: 1.jpg
Views: 79
Size: 228.7 KB
ID: 166929

And here is the same CSV in Excel 365 (2016) - with Autofit Row Height and Column Width set - which looks okay to me.

Click image for larger version

Name: 2.jpg
Views: 76
Size: 350.5 KB
ID: 166930

Having the Comments at the end made easier to 'see' what was happening.

The LF"LF at the end of the lines(records) is making all the cell heights taller. If you replaced them with "LF it may look better, because only true multl-line comments would increase cell height.

BR

10-15-2018, 03:46 AM	#17
BetterRed null operator (he/him) Posts: 21,820 Karma: 30277270 Join Date: Mar 2012 Location: Sydney Australia Device: none	I suspect the problems you perceive are caused by multi-line comments, here is the text for the test.csv shown in Notepad++ (I used a small font to eliminate word wrap) And here is the same CSV in Excel 365 (2016) - with Autofit Row Height and Column Width set - which looks okay to me. Having the Comments at the end made easier to 'see' what was happening. The LF"LF at the end of the lines(records) is making all the cell heights taller. If you replaced them with "LF it may look better, because only true multl-line comments would increase cell height. BR Last edited by BetterRed; 10-15-2018 at 03:54 AM.