[Libreoffice-bugs] [Bug 136257] Calc loses date/time info in a chart with time axis

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=136257

--- Comment #6 from ZithraMestor at gmail.com ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200830/c883883d/attachment.htm>