If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
Thank you for sending the settings files. I discussed this with Erik, and we determined it is due to a combination of your Windows regional settings and the data being compared.
The Data Compare looks at the first two lines of text and determines the column types (text, date, etc). If the column types are different, then BC treats the first line as a header. If the column types are the same, then it treats them both as data.
In the files you sent, the first line in column 9 is "1937-07-26". With your Windows regional settings (short date format yyyy-mm-dd), this is detected as a date. The second line is "1937-1943", which is detected as text. Because the data types are different, BC treats the first line as a header.
On a default US English system (our office test systems), the short date format is M/d/yyyy, so column 9 for both lines is detected as text. This makes BC treat the first line as data.
Because column 9 in your files doesn't use a consistent format, you'll need to edit the Data Compare file format and change the "First line contains" setting to "Cell data".
Make sure your "File Info" header is enabled (under the View menu). It includes a format dropdown that can be used on-the-fly to view your files using a different file format.
BC v4.0.7 build 19761
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
The reason you are still not seeing what you want is that you only changed the format for the left side, but you need to change it for the right side as well. You can change both at the same time by using the "Data Format" toolbar button picker instead of the file info pickers.
> The reason you are still not seeing what you want is that you only
> changed the format for the left side
Well yes, but I didn't see the expected effect on the left side.
I.e. I changed the left "First line contains" to "Cell data" and yet still the left side interpreted the first line as "Column names". This surely is not WAD.
> change it for the right side as well.
Thanks - that worked.
> You can change both at the same time by using the "Data Format"
> toolbar button picker instead of the file info pickers.
Thanks. Note: this doesn't work after I only change the left side - the format menu already shows my "Cell data" format active and clicking it again has no effect. I suggest if the UI cannot handle showing mixed format, it should show no format. Else at least a click on the one shown selection should be accepted.
The column names are filled in from either the left or right file. If the right file has column names, then they will be used for the both the left and right side.
For the Data Format change issue, we'll have it fixed in the next release. In the current version, if you click to focus on the other side, then change the Data Format, it should work correctly.
Comment