Description: I open with LibreOffice an .xls file created with Microsoft Excel. The file contains 4 graphs. LibreOffice opens .xls as Calc. 2 of the graphs are OK, but 2 are distorted. I tried different LibreOffice versions on diff. pc-s. Again, the same file in Microsoft Excel is OK, but in LibreOffice is unusable. I am happy to provide the file, but do not see this option. Steps to Reproduce: 1.Read the file that I will provide 2. 3. Actual Results: obviously incorrect graph Expected Results: obviously correct graph Reproducible: Always User Profile Reset: No Additional Info: I will try to attach the file using the "Add an Attachment" option I see below. If it won't work I can e-mail the file. Thanks.
Created attachment 170972 [details] file with the graph that fails the file I am trying to attach is 375K. Not sure that your attachment tool will allow this. I can mail the file. Thanks.
(In reply to Michael from comment #1) > Created attachment 170972 [details] > file with the graph that fails I don't see the bug. Third and fourth chart in Sheet2 contain a data range Third Chart: $Sheet2.$A$2380:$B$5190 Fourth Chart: $Sheet2.$A$3592:$B$5042 But starting in row 4069 there are **no** x-values, while there are y-values up to row 5270. No x-values are taken as "0" and hence you get date 1899-12-30 (which is based on default calc settings day 0). Adapt data ranges to be last row Third Chart: $Sheet2.$A$2380:$B$4068 Fourth Chart: Fourth Chart: $Sheet2.$A$3592:$B$4068
OK, but if you open the same in MicroSoft Excel you will see that the graph just stops where the x-data is not entered yet, which is the user intention that Excel understands. There must be consistency between the applications. So my complaint may be qualified not as a bug but as an enhancement request, to make LibreOffice consistent with MS Office. Thanks.
The change in importance accordantly. And while editing the chart. Menu/Format/Format Selection enabling en Plot Options 'Leave gap' instead of 'Assume zero' seems to work.
Dear Michael, 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 INSUFFICIENTDATA 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 MassPing-NeedInfo-Ping
Dear Michael, 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-FollowUp
Created attachment 176103 [details] reply to your last email Dear Team, I have re-tested with the same file that I submitted to you originally in LO version 7.2.2.2. Nothing has changed; the graph is distorted. Your original reply was that it was not a bug, but the distortion was because column A is not completed with data within the selected range. This is correct, but, to compare, Excel does understand that A is not fully filled and does not try to draw beyond what is filled. LO does not understand this and creates the distortion. It is up to you to decide if you want LibreOffice to be as smart as Excel is. For me, I just dropped LO and use Excel. Thank you and please do not contact me again about this. Michael
Editing the data series there is an option 'Plot missing values - Leave gap', that I think gives what you want.