damithc / testrepo3

0 stars 0 forks source link

Multiline question & response could not be display properly in Excel #227

Open damithc opened 10 years ago

damithc commented 10 years ago

From OTS.Nexus on January 07, 2014 16:55:21

If there are multi-line questions and responses, only the first line will be displayed when opened in Excel. It would have no problem if opened as text file.

One way to solve it is that the user has to manually import the data from csv into Excel in order to see the multi-line field properly.

Original issue: http://code.google.com/p/teammatespes/issues/detail?id=1455

damithc commented 10 years ago

From dam...@gmail.com on January 07, 2014 16:10:28

There is a way to handle multiline text in csv files. I think we've already done it for feedback session answers. Maybe we should put those methods in a CsvHelper class? On the other hand, showing the first line only may be enough.

Status: Accepted

damithc commented 10 years ago

From OTS.Nexus on January 08, 2014 00:30:18

The multiple lines are actually displayed correctly in Excel. Just that the default row height made it not viewable.