Created attachment 145415 [details] Spreadsheet contains data and chart. Copying chart to another spreadsheet results in corrupted chart. I have numerical data in four columns. These columns contains references to cells in other columns eg. LOG(C6). Some of the cells that are referenced are blank. This results in ERR:502 (log(0)!). I select the columns and insert a chart: Insert -> Chart -> Line. I select "Lines only". I get a line chart where the parts of the lines that refer to ERR:502-cells are not drawn (This is the desired behaviour). I can copy the chart (Ctrl-C, Ctrl-V) on the same spreadsheet with no corruption. I then paste the chart on another spreadsheet, text document, drawing or presentation. The chart is otherwise identical to the original one except: Only the first part of the line that is non-continuous due to ERR:502-cells is present on the copied chart. The latter parts of the line are not shown. (One of the lines is also non-continuous due to empty cells (no error). This line is copied correctly.) I inspected the copied charts: Right-click -> Data table... The data table does not contain values after the first blank area of the corrupted line. It seems that the data for the line does not get copied after cells that contain ERR:502. The data table of the copied chart contains only values and empty cells. It does not contain cells that have value "ERR:502". Work-around: 1. "Export as image" results in correct png-images that can be imported to other documents. 2. The sheet could be modified so that no ERR:502 cells are present.
i can confirm the described behaviour Version: 6.1.2.1 (x64) Build-ID: 65905a128db06ba48db947242809d14d3f9a93fe CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; Gebietsschema: de-DE (de_DE); Calc: Version: 6.2.0.0.alpha0+ (x64) Build ID: bc32f789bb3c079eba9c07275866a7b13f76dbcc CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: de-DE (de_DE); Calc: threaded workaround: it worked for me using a matrix formula, for example column H: - select D3:D159 - enter: =IF(D3:D159="";"";LOG(D3:D159)) - Shift+Ctrl+Enter
I can reproduce the issue copying the chart from the spreadsheet to a writer document. Reproduced in Version: 5.2.0.0.alpha0+ Build ID: 3ca42d8d51174010d5e8a32b96e9b4c0b3730a53 Threads 4; Ver: 4.10; Render: default; Version: 4.3.0.0.alpha1+ Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e but not in Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Bibisected to the following range using repo bibisect-42max (intermediate ones failed to build), all part of Kohei Yoshida's Calc work: https://cgit.freedesktop.org/libreoffice/core/log/?qt=range&q=ac84ffb3c90bb5788608eadf2177f587021daaad..4c99a427ee4adaeddb2682c192384bad21d9d09b
Dear Tuomas J, 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
Ouyang Leyan committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/318d384c596c1593667d6c936f55bf6ebd0c5db6 tdf#120348: Avoid data loss when copying chart with error in formulas It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: 876da94619d561e4b4c6c7d12a8d6726eb857df8 CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded @Ouyang Leyan, thanks for fixing this issue. Should it be closed as RESOLVED FIXED ?
Ouyang Leyan committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/d03f68526a9fc6f6c26257d58166480397d285c8 tdf#120348: Avoid data loss when copying chart with error in formulas It will be available in 7.1.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Ouyang Leyan committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/a7997a44d20a78bc7aecbd0518528522cd041e16 tdf#120348: Avoid data loss when copying chart with error in formulas It will be available in 7.0.5. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/356848ed36f958c283d1863934161d6823d8b121 tdf#120348: sc: Add UItest It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I think we can close this issue. @Ouyang Leyan, thanks for fixing this issue
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/6e9b99ffe0083060176dc782986d3b441b7e48ec tdf#120348: move UItest to CppUnittest It will be available in 7.5.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.