Created attachment 138142 [details] Example file made with Calc Many Chart Wall properties are not preserved when the spreadsheet is saved as XLSX, including Bitmap, Pattern and Hatch area fills and border line styles different from Continuous. Steps to reproduce: 1. Create a new spreadsheet in LibreOffice Calc. 2. Create a simple chart (a column chart with default settings will do) based on any values. 3. Change the area fill of the chart wall to bitmap, pattern or hatch, or the Border line style to something different from Continuous. 4. Save the file as XLSX. 5. Reload the file. Actual results: The custom chart wall property will be lost. Expected results: The custom chart wall property should be preserved.
Created attachment 138144 [details] The example file saved by LO6 alpha
Created attachment 138145 [details] The two files in Calc and Excel side by side
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
Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=38df2698123d52461679b4bedadd693b23cb4794 support exporting of hatch for chart background, tdf#114180 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.
A polite ping to Markus Mohrhard: is this bug fixed? if so, could you please close it as RESOLVED FIXED ? Thanks
This bug is far from being fixed. I just fixed the easiest case. All the remaining ones look like they might require a lot more work.
To install previous version of LibreOffice, you need to unistall current version of LibreOffice with command: $ sudo apt remove libreoffice-core And next download LO 5.4.5 from website: https://www.libreoffice.org/download/download/ More information is available at: https://askubuntu.com/questions/248953/can-i-use-an-older-version-of-libreoffice Please let me know if this helps.
Dear Markus Mohrhard, This bug has been in ASSIGNED status for more than 3 months without any activity. Resetting it to NEW. Please assigned it back to yourself if you're still working on this.
Created attachment 148136 [details] Calc and Excel side by side The two files in Calc and Excel side by side. Now, It looks much better.
Created attachment 148137 [details] Example file made and export by Calc.