I am running a tool in Jenkins, which reads a .csv file. The computer I'm using doesn't have Microsoft Office installed, just OpenOffice.
Compared to Excel, OpenOffice opens this file in a strange view, for example:
- connects a few columns to one column;
- splits one line to many columns;
- does not show columns titles.
I wonder if anyone has encountered this issue and can advise me.