Description: When column chart with datetime X values is created, X values are grouped by date and it's impossible to change this. Chart works as expected if convert datetime to text with TEXT() function. Sample file is attached. Steps to Reproduce: 1. Create spreadsheet 2. Fill one column by 30 datetime values incremented by 1 hour, second column – by any numbers 3. Select values in two column, create column chart. Actual Results: Only two columns in the chart Expected Results: 30 columns in the chart. Reproducible: Always User Profile Reset: No Additional Info: If copy datetime values to another column with conversion to text (TEXT() function) and use them as X values, chart looks right.
Created attachment 143013 [details] Sample file
Created attachment 143014 [details] Sample file screenshot
I was able to reproduce the bug in the following (Windows 8.1): Version: 6.0.5.2 (x64) Build ID: 54c8cbb85f300ac59db32fe8a675ff7683cd5a16 CPU threads: 4; OS: Windows 6.3; UI render: GL; Locale: en-US (en_US); Calc: CL and Version: 6.2.0.0.alpha0+ Build ID: b1740fba0d1e6e3d69c3781734509317f42a0e4f CPU threads: 4; OS: Windows 6.3; UI render: GL; TinderBox: Win-x86@42, Branch:master, Time: 2018-06-15_08:49:04 Locale: en-US (en_US); Calc: CL Probably unrelated, but I couldn't save my test file after I created the chart and tried to save. (6.0.5.2). In my attachment, I include the error just in case it's been seen before and might be helpful with another bug. For now, I'll assume it was some random thing on my computer.
Created attachment 143149 [details] Results and error Shows the reproduction of bug as well as error that appeared when I tried to save the test file after creating the chart.
Also reproduced in LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4 @Markus, I thought you could be interested in this issue...
Still reproducible in 6.3 (Debian GNU\Linux).
Created attachment 153699 [details] picture of X axys scale dialog Automatic detection of date is the expected result. If you want X axys data to be treated as text : Edit the chart, right clic on X axys, choose "format axys", select "text" instead of "automatic" in the 1st tab of the dialog. see attachment.
Comment on attachment 153699 [details] picture of X axys scale dialog Hmmmm. Works. But WHY???? Why if I have datetime column, it is recognized as date? Why switch controlling this is located at the tab 'Scale'? This is completely crazy behaviour for me...
Dear Yauhen Kharuzhy, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
This bug is still reproducible in: Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 9e8c1da64fa8a520730ce0aea0f7199cd75c892f CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Dear Yauhen Kharuzhy, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still reproducible with same conditions in 7.6.4.1
(In reply to Xisco Faulí from comment #5) > Also reproduced in > > LibreOffice 3.3.0 The chart exhibits the bug on fileopen in OOo 3.3, but double-clicking it (or creating it from scratch) sets it back to the original text scale. Issue started in 3.4, when date scales started being supported. This is actually a duplicate of bug 68679. *** This bug has been marked as a duplicate of bug 68679 ***