| Summary: | FILESAVE XLSX Pie Charts with 3D look get a gray background when saved in Calc and opened in Excel 2013 | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Gabor Kelemen (allotropia) <kelemeng> |
| Component: | Chart | Assignee: | Bartosz <gang65> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | gang65, jalojo |
| Priority: | medium | Keywords: | filter:xlsx |
| Version: | 3.5.3 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | target:6.1.0 target:6.0.4 target:7.0.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Attachments: |
Example file made with Excel 2013
The example file saved by LO6 alpha Screenshot of the document in LO 6 and Excel 2013 Example 3d Chart with background colours, created by MS Excel 2010 .xlsx file with different chart types |
||
Created attachment 138066 [details]
The example file saved by LO6 alpha
Created attachment 138067 [details]
Screenshot of the document in LO 6 and Excel 2013
Hi Gabor, Reproduced with LO 6.0.0.0.beta1 Build ID: 97471ab4eb4db4c487195658631696bb3238656c Threads CPU : 2; OS : Windows 6.1; UI Render : par défaut; Locale : en-US (fr_FR); Calc: CL Also with LO 3.5.3.2 Version ID : 235ab8a-3802056-4a8fed3-2d66ea8-e241b80 so probably inherited from OOo. *** Bug 114183 has been marked as a duplicate of this bug. *** The root cause of problem is setting up the shape colour, in chart1.xml file:
<c:spPr>
<a:solidFill>
<a:srgbClr val="d9d9d9"/>
</a:solidFill>
<a:ln>
<a:noFill/>
</a:ln>
</c:spPr>
</c:plotArea>
After replacing it with
<c:spPr>
<a:noFill/>
<a:ln>
<a:noFill/>
</a:ln>
<a:effectLst/>
</c:spPr>
The issue is gone.
More information is available at: http://www.datypic.com/sc/ooxml/e-draw-chart_spPr-1.html Created attachment 139680 [details]
Example 3d Chart with background colours, created by MS Excel 2010
It seems that MS Excel is drawing 3D charts differently than LO. It have two types of colours: - for plot area - for chart area Both could have different colours. As we cannot change "plot area" attributes, the best will be set it as "No fill" Created attachment 139691 [details]
.xlsx file with different chart types
Bartosz Kosiorek committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=5b9e76557d2b5c835a5873de1ce530f36ea98d2d tdf#114139 Don't export Plot Area shape property fot 3D charts It will be available in 6.1.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. Bartosz Kosiorek committed a patch related to this issue. It has been pushed to "libreoffice-6-0": http://cgit.freedesktop.org/libreoffice/core/commit/?id=dfd19459a336a6cd9a67a0d3dc3cf305de567be1&h=libreoffice-6-0 tdf#114139 Don't export Plot Area shape property fot 3D charts It will be available in 6.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/f7e23260d22416667fb707e06282c2aeb538d816 tdf#114139: 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. |
Created attachment 138065 [details] Example file made with Excel 2013 Pie Charts with 3D look get a gray background when saved in LibreOffice Calc and opened in Microsoft Excel 2013. Steps to reproduce: 1. Create a new spreadsheet in Microsoft Excel 2013. 2. Create a simple pie chart with 3D look. 3. Save the file as XLSX. 4. Open the file in LibreOffice Calc and save with a different name as XLSX. 5. Open the file created by Calc in Microsoft Excel 2013. Actual results: The chart gets a gray background in Microsoft Excel 2013. Expected results: The chart should preserve the original white background both in Calc and Excel.