0

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.

screenshot

I wonder if anyone has encountered this issue and can advise me.

Z.Lin
  • 28,055
  • 6
  • 54
  • 94
Or Rosenblum
  • 13
  • 4
  • Inserted image from link. – Z.Lin Sep 08 '17 at 15:17
  • What import settings did you use when opening the file? For one thing, it looks like you told Calc to split based on spaces -- was this intentional? Please give specific examples of the desired results versus actual results. Such as, "XXYY was split into two columns XX and YY, but it should be in a single column." Additionally, tell the version of OpenOffice. Regarding column titles, show how they look in the .csv file when viewed with a text editor, and describe how they should look in Calc. – Jim K Sep 08 '17 at 21:48
  • the columns category dont showed ( like- Line, Rank, atc.. ). column D is mutual to column C and E. from column c it need to be one line. for example row 1: column D need to be "range check". column x need to be: "range check might fail, .... ". – Or Rosenblum Sep 10 '17 at 10:32

0 Answers0