<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Calc loses date/time info in a chart with time axis"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=136257#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Calc loses date/time info in a chart with time axis"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=136257">bug 136257</a>
from <span class="vcard"><a class="email" href="mailto:ZithraMestor@gmail.com" title="ZithraMestor@gmail.com">ZithraMestor@gmail.com</a>
</span></b>
<pre>This is interesting. I do not see that problem/error!
I think there are 2 things going on. One is the conversion to .xls and the
other is the inclusion of empty cells below the data when composing the chart.
When I downloaded the file that I had uploaded I did not have any problems.
But I checked and the ranges did not include any empty cells in that file,
unlike the file I thought I uploaded.
When I created the example I filled in data cells for 4 rows and kept the
formatting the same up to row 20. Then I select the first 2 columns and rows
#1 up to #20 for the scatter chart. Make chart. Save as .ods. Save as .xls.
Exit. Open .xls. This x-axis corruption is totally reproducible for me.
I suggest taking the .ods file I uploaded, check that formatting is the same in
col 1 up to row 20, deleting the chart, and making a chart using rows up to row
20. Now save as .xls, exit and re edit the .xls file. The x-axis data points
should no longer be times, but should be 1,2,3,4.
Let me know if I can further clarify. Thanks for your help.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>