Created attachment 141653 [details] contains the graphs that are rendered in the wrong position Document origin: Charts in the attached calc-doc were copied from another file (which in turn was imported from a MS Excel .xls sheet) (with "paste special", option "Star Object Descriptor (XML)"); sheet1 "misure" is a perfect copy of part of the original sheet, while sheet2 "calcoli" doesn't contain formulae, because I only needed to prepare the thing for printing. Then I have modified page breaks with "Menu -> View -> Page break" mode. Issue: All the charts are rendered in the wrong position when: "printing to file" (PDF), "all sheets", from the print dialog. It seems that only vertical position is affected, while horizontally the charts are in the right place; however it should be noted that they are next to the left margin and some unwanted movement to the left could be constrained because of this. See attached output PDF. The anchor setting of the charts is "to cell"; setting their anchor to "to page" apparently fixes the problem. This doesn't happen in a Writer document, however it is possible that I didn't test Writer thoroughly. https://bugs.documentfoundation.org/show_bug.cgi?id=113143 may be related.
Created attachment 141654 [details] PDF output showing wrong position of charts
I can confirm with Version: 6.1.0.0.alpha1+ Build ID: 653e58f9eb3d4ee61d8103993cdff2660c9127a5 CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; regression
In my case, if I print to PDF using 'Page Break Preview' the chart overlaps the cells bellow... Reproduced in Version: 6.1.0.0.alpha1+ Build ID: 43af818557904450b13839350c65ad865b9ee9d2 CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: group and Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a) @Raal, why is it a regression ?
Created attachment 141834 [details] How I looks for me in LibreOffice 6.1 master
Created attachment 141846 [details] The original source of the faulty document data Since I wasn't able to reproduce the issue building a chart in a new, blank, simple document: I post here the original .xls file, from where the .ods I first posted was derived by copy-paste. Printing this one to PDF, the charts are all offset by some pixels; a screenshot will follow. (The issue here isn't as evident as before, but since this is the source of my data, it may be relevant).
Created attachment 141847 [details] Comparison preview-vs-PDF of the xls source Images explain better than a million words. You can see (right window) the chart in the PDF is shifted upwards a bit, if compared to the preview (left window). Don't ask me what the blue bar is... I dare say it wasn't there while editing in some version of MS Excel.
Today I tried to export a .ps file, with the "Print...-> Print to file" dialog. The same issue occours as with PDF's. Maybe it's relevant. Version: 6.0.4.2, from x64 Arch Linux official repo.
Hmm, I could repro with 4.3.0.0, but not with 3.5.0 (on Win) with attachment 141846 [details]
Bibisected on Linux with 43all to range https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=b67a51b40a4876f4bd97a2917103112006710b0c...c33019b36d613f951787ce9836e34d74bfbd6a1b At least it has many commits from Kohei.
Dear Lorenzo Chiola, 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 http://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
Created attachment 152634 [details] New ods - pdf chart position comparison Version: 6.2.4.2.0+ Build ID: 6.2.4-1 CPU threads: 4; OS: Linux 5.1; UI render: default; VCL: gtk3; Locale: it-IT (it_IT.UTF-8); UI-Language: en-US Calc: threaded Arch Linux libreoffice-fresh package When I open the ODS file the chart is slightly offset downwards. In the PDF exported from the ODS file, the chart is slightly more offset downwards. The attachment is a screenshot of the ODS view and of the PDF side by side. In the screenshot the second chart in the file is shown; the first is offset by similar amounts in the same direction. I tried to reposition both charts, but I'm not able to select and move either.
Created attachment 152636 [details] New comparison preview-vs-PDF of the xls source Version: 6.2.4.2.0+ Build ID: 6.2.4-1 CPU threads: 4; OS: Linux 5.1; UI render: default; VCL: gtk3; Locale: it-IT (it_IT.UTF-8); UI-Language: en-US Calc: threaded Arch Linux libreoffice-fresh package Now the blue bar on top of the chart is gone, which is good. The chart is slightly offset upwards in the rendered PDF when compared to the XLS viewed in LibreOffice. The amount is similar to the screenshot in comment 11.
Dear Lorenzo Chiola, 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
Dear Lorenzo Chiola, 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