Created attachment 78863 [details] Test case spreadsheet with the embedded chart with transparent background. When I save a spreadsheet with an embedded chart with a transparent background in MS Excel 2007/2010 format, the transparent background of the chart is lost when the spreadsheet is opened in MS Excel 2007. If I save the same spreadsheet in MS Excel XP/2003 format, the transparent background of the chart is preserved when the spreadsheet is opened in MS Excel 2007. Steps to reproduce: 1. Create a spreadsheet in Calc with a chart with a transparent background 2. Save the spreadsheet in Excel 2007/2010 format 3. View the spreadsheet in Excel 2007 Current behavior: Excel 2007 displays the Excel 2007/2010 format spreadsheet with the embedded chart not having a transparent background. Expected behavior: Excel 2007 should display the Excel 2007/2010 format spreadsheet with the embedded chart having the transparent background preserved. Operating System: Ubuntu Version: 4.0.3.2 (rc2) release I had eluded to this issue in bug report #59857, which focused on a warning message that was being issued by MS Excel when the 2007/2010 format spreadsheet was being opened. This bug report focuses on the fact the transparent background of the chart isn't preserved when the spreadsheet is saved in MS Excel 2007/2010 format.
Created attachment 78864 [details] Test case spreadsheet with the embedded chart with transparent background.
Created attachment 78865 [details] Test case saved as XLS file and viewed in Excel 2007.
Created attachment 78866 [details] Test case saved as XLSX file and viewed in Excel 2007.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=6e2292b3cdd032edff21f0016b7f61e9bb420699 map full transparent solid fill to no fill, fdo#64224 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.
Waiting for review for 4-0 at https://gerrit.libreoffice.org/#/c/3792/ If you have more such cases please set me into CC as I will miss them otherwise.
Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5672bfda87bce5e05e6ef1ecc20f36b4fc7a92ef&h=libreoffice-4-0 map full transparent solid fill to no fill, fdo#64224 It will be available in LibreOffice 4.0.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/7bc3455af6dca6fa596f374a1d1ed2053323069e tdf#64224: Add unittest It will be available in 7.0.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.