Created attachment 138069 [details] Example file made with Excel 2013 It is possible to create 3D Column charts with ‘0’ Y value (in that case, the shape of the data series is a square) in Microsoft Excel 2013, but these are not fully supported by Calc: Calc only shows the value of the data (these data labels move down under the X axis) but the data series of ‘0’ Y values (the “square”) are disappeared. Steps to reproduce: 1. Create a new spreadsheet in Microsoft Excel 2013. 2. Add two values (0% and 10%) to two cells in a column. 3. Select the cell range that contains the data. 4. Create a simple 3D Column chart with these (0% and 10%) data series. 5. Modify the X category axis labels to show the data series values (0% and 10%). 5. Save the file as XLSX. 6. Open the file in LibreOffice Calc and compare it with Excel. Actual results: The chart in Calc doesn’t show the data series of ‘0’ Y values (the “square”) and these labels move down a little bit under the X axis. Expected results: The chart should display the zero values of data series at 3D charts.
Created attachment 138070 [details] The example file saved by LO6 alpha
Created attachment 138071 [details] The two files in Calc and Excel side by side
Hi Gabor, I reproduce 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 Not sure it is a bug. Set Status to enhancement.
initial fix by József Szakács: https://gerrit.libreoffice.org/#/c/65269/ It seems, this is really not a bug. We need the recent behavior, too, for example: https://www.excelforum.com/excel-charting-and-pivots/955495-help-hiding-zero-value-bars-in-stacked-3d-bar-chart.html So we will need a new LibreOffice chart option or setting to support both ways of data visualization.
Jozsef Szakacs committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/+/b8d2d78974fcb3e95de87dd98103e5bc015b7687%5E%21 tdf#114141 draw the top of the zero height 3D bars It will be available in 6.3.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.
@Mike, Regina: it seems for me, it's worth to extend the OpenDocument standard here to support both interoperability and back compatibility. What is your opinion?
I don't know much about Charts, so I am not sure if "how to show zero data" should be some data series property, or chart property, and if the latter is OK to be app-specific settings that may be in chart's settings.xml (can we have one per chart?), and not require ODF extension.
(In reply to Mike Kaganski from comment #7) I agree, using app settings could be an acceptable solution. Thanks, László
(In reply to László Németh from comment #6) > @Mike, Regina: it seems for me, it's worth to extend the OpenDocument > standard here to support both interoperability and back compatibility. What > is your opinion? I think, that is nothing to be treated in the standard. LibreOffice was simple wrong, when it did not show a column of 0 height. Showing nothing would mean, that there is a gap in the data. And showing nothings means, that you are not able to select that data point, to add a single label, for example.