my spreadsheet contains 5 charts. I recently revised three of them to add a new data series. I inserted the revised charts using the provided chart wizard. Two of my charts remain unchanged. There is no problem with the unchanged charts. The new charts do not update correctly. The old charts track five data series. The new charts track six data series. Five of the data series in the new charts duplicate five data series in the old charts. Only one data series in the new charts is new information. One data series is common to all of the five charts. It is a date. I format that date day month, year (i.e. 8 Dec, 15). The date information is moved from a line at the top of my spread sheet to the first column in each of five data tables. This is accomplished by an update macro I wrote for this related purposes. I've used this macro in various iterations of my spreadsheet with reasonable success over the last several years, dating back to Open Office. Here is the problem. When I run the macro, after all of the new data is properly in place, everything appears to function correctly; that is until I look at the x axis data on the charts. On the two old charts the new date appears and functions correctly. On the new charts the date information is displayed as a five digit date code. (i.e. 42303 instead of the corresponding date in October 2015). I've tried a number of work arounds for this problem. All of them are a bit cumbersome. Some of them were a complete waste of time. I finally hit on one that is only somewhat inconvenient and yields a satisfactory result. I go to the data table that one of the new charts tracks. I copy date information from an earlier cell in the table and paste in place of the latest date. Then I correct the data to reflect the latest date. That eliminates the five digit code from the x axis, changing it to the date format I prefer. The I copy and paste the new data to the data table for the other two affected charts. At that point the problem is corrected until the next time I update the spread sheet. Please excuse the length of my description Of the problem. I prefer to be thorough.
Please attach a test file (without any confidential data) and describe a clear step by step scenario to reproduce the problem. Best regards. JBF
Created attachment 121862 [details] The subject spread sheet
(In reply to Jean-Baptiste Faure from comment #1) > Please attach a test file (without any confidential data) and describe a > clear step by step scenario to reproduce the problem. > > Best regards. JBF I have attached a test file sans confidential information. The version of Libre Office I am currently using is 4.4.3.2 release. If you need any further information, please place a request here. I intend to track progress on this bug every weekday. Best Regards, RLP
You mix text and dates. In you "date" column, you have text values ((i.e. 8 Dec, 15) at the beginning of the column and true dates at the end. First 2 charts have X axis have scale type as text, others set at "automatic". First 2 chart may have been created wuth an old OOo version (older than 3.2 I think). In older version, line chart do not support date scale. Don't mix text and numeric data. It always lead to surprising result...
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team Sun, 11 Sep 2016 21:43:24 +0200
Dear Bug Submitter, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-20161010