[Solved] Data do not populate in separate columns

[sonadam]

Hello,
I downloaded data in the Open Office Calc and the columns did not populate, that is all the data is crammed into the first column. You can see below that all the data is under the Date,"Daily" column. I don't know much about spread sheets but I was told that this should not be happening. Any help available? Thanks, Adam


Date,"Daily Production (kWh)"," End of day meter reading (kWh)"
2016-08-18,0.0,2.09
2016-08-19,31.939000000000004,34.029
2016-08-20,51.38100000000001,85.41000000000001
2016-08-21,46.30399999999999,131.714
2016-08-22,50.066,181.78
2016-08-23,43.0,224.78
2016-08-24,38.91099999999997,263.691
2016-08-25,45.509000000000015,309.2
2016-08-26,50.238000000000056,359.43800000000005
2016-08-27,49.856999999999914,409.29499999999996
2016-08-28,48.48600000000005,457.781
2016-08-29,51.45599999999996,509.23699999999997
2016-08-30,51.28800000000001,560.525
2016-08-31,45.922000000000025,606.447
2016-09-01,49.928,656.375
2016-09-02,41.13799999999992,697.5129999999999
2016-09-03,48.635000000000105,746.148
2016-09-04,50.30799999999999,796.456
2016-09-05,53.38799999999992,849.8439999999999
2016-09-06,52.204000000000065,902.048
2016-09-07,46.843000000000075,948.8910000000001
2016-09-08,20.322999999999865,969.2139999999999
2016-09-09,46.694000000000074,1015.908
2016-09-10,49.40600000000006,1065.314
2016-09-11,49.02800000000002,1114.342
2016-09-12,49.49000000000001,1163.832
2016-09-13,42.2199999999998,1206.052
2016-09-14,32.02600000000007,1238.078
2016-09-15,50.40100000000007,1288.479
2016-09-16,51.423,1339.902
2016-09-17,50.55899999999997,1390.461
2016-09-18,50.240999999999985,1440.702
2016-09-19,49.230999999999995,1489.933
2016-09-20,34.88300000000004,1524.816
2016-09-21,20.2170000000001,1545.0330000000001
2016-09-22,42.19200000000001,1587.2250000000001
2016-09-23,26.329999999999927,1613.555
2016-09-24,48.05600000000004,1661.611
2016-09-25,50.51599999999985,1712.127
2016-09-26,49.29500000000007,1761.422
2016-09-27,27.855000000000018,1789.277
2016-09-28,34.45700000000011,1823.7340000000002

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).

[RusselB]

Where did the data come from?
Is it in a .csv file? If so then you need to specify the Comma separator option in the Text Import Dialog
I would also recommend ensuring the Detect Special Numbers option is checked.
There is the ability to specify the format for the date column, but looking at the data you supplied you shouldn't need to specify this in order for the dates to be read correctly.

[sonadam]

Thanks a lot Russell, I did not have the "Comma Separated" box checked. It worked.
Adam

[keme]

As a side comment, note that those very long numbers may not be exactly represented in Calc (nor in most other popular spreadsheet apps). I assume that the long strings of decimals actually represent rounding errors (they all show a long series of either zeroes or nines), and only 3 decimals or so are significant. In that case, there is no problem with handling the given data correctly.

In the unlikely case that all decimals are significant, you need to use different software to calculate correctly. Calc precision limit is approximately 15 decimal digits.