Created attachment 123609 [details] ods file I have a chart, with error bars. When I try to reopen the file, chart is empty white square. Clicking inside lead to crash. It well repeatable in version 4.4.7.2 (Fedora) and latest release on (CentOS). I saved xlsx, and it opens nicely. ods is corrupted. I attach both files.
Created attachment 123610 [details] good xlsx saved by libreoffice, shows how the chart was
The way to reproduce the issue is to 1. open xlsx 2. save as ods 3. close the program 4. open the ods again: the chart will be corrupted
Chart displays fine for me in ODS and does not crash. Arch Linux 64-bit, KDE Plasma 5 Version: 5.2.0.0.alpha0+ Build ID: 011e65c93053c88eb752e50ef47c69872608cbcd CPU Threads: 8; OS Version: Linux 4.4; UI Render: default; Locale: fi-FI (fi_FI.UTF-8) Built on March 22nd 2016
repro, Version: 5.2.0.0.alpha1+; win7 error message: unsatisfied query for interface of type com.sun.star.chart2.XCoordinateSystemContainer with 4.5 is chart lost, but doesn't crash
Created attachment 125227 [details] console output opening .xlsx attachment 123610 [details] the first chart looks correct but most parts of second chart are missing. looking in the file: "Object 2/content.xml" is not complete, but suddenly cut off. last elements: <style:style style:name="ch4" style:family="chart"> <style:graphic-properties draw:stroke="none" svg:stroke-color="#b3b3b3" draw:fill="none" draw:fill-color="#e6e6e6"/><style:text-properties fo:font-size="10pt" style:font-size-as think the import already goes wrong, see attachment
I have this issue when I try to add Y error bars using a cell range. To reproduce: Begin with the file I have attached, and add Y error bars to the "Density Mean" data series using cell range. 1. Select "Positive and Negative" 2. Check "Same value for both" 3. Set the positive parameter as "$Sheet1.$J$3,$Sheet1.$J$8,$Sheet1.$J$12,$Sheet1.$J$19,$Sheet1.$J$23,$Sheet1.$J$27,$Sheet1.$J$33,$Sheet1.$J$36". 4. Save and close Calc Upon opening it, the chart has only its area element left, and clicking on it results in the error "unsatisfied query for interface of type com.sun.star.chart2.XCoordinateSystemContainer!". It seems to happen when using a discontinuous range for Y error bars. I don't really know how to report bugs or use Bugzilla, so I apologise if this is in the wrong place.
Created attachment 127349 [details] Test case
I can reproduce it.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c3cc9429d136178996d797ef8fd6d740b39cc94e avoid crashes on broken charts, related tdf#98690 It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0ab45be62bc1ffcbdd13aca7375fdcd1bbccb79a catch the exception to prevent broken charts, tdf#98690 It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Review request for 5-2 in gerrit.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=cf5d6ccea23549aea708c6e399a982598b2b58aa&h=libreoffice-5-2 catch the exception to prevent broken charts, tdf#98690 It will be available in 5.2.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=0e8045fd2365c5adf986cd845d4d1a185ffe0aeb&h=libreoffice-5-2 avoid crashes on broken charts, related tdf#98690 It will be available in 5.2.4. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://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/3421440bfbfff7c59caea881be64b684e601e04f tdf#98690: 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.
That attachment 123610 [details] is *NOT* a "good xlsx", it was already saved broken (LibreOffice/5.1.1.3) with the static literal names not being quoted strings.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/0e5d89a149e86975e103270a0ff4e65776ff8f85 tdf#98690: move UItest to CppUnittest It will be available in 7.6.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.