Created attachment 162178 [details] Example file from Excel Attached document contains some XLSX charts (column, bar, line and area are all affected) that have their data range defined with several empty lines and the displayed category is dates from multiple months. Also the range contains 10 empty rows after these. This results in a date type X axis with month resolution. When opened in Calc the chart tries to display even the empty rows and fails miserably. This only happens with month resolution, day and year are fine since in that case Calc ignores the empty rows and displays the charts just like Excel (which also ignores the empty rows) Changing the data range to only the part with actual data corrects the charts appearance. Steps to reproduce: 1. Open attached file Actual results: The charts with the month date axis scale appear unreadable. Expected results: Only the data points with actual data are drawn on the chart, like in the case of day and year resolution. LibreOffice details: Version: 7.1.0.0.alpha0+ (x64) Build ID: 33a720ab802491f15b247e09755cd36205b6f435 CPU szálak: 4; OS: Windows 6.3 Build 9600; Felületmegjelenítés: alapértelmezett; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: CL Also happens in Verzió: 6.0.0.3 Build az.: 64a0f66915f38c6217de274f0aa8e15618924765 CPU szálak: 4; OS: Windows 6.3; Felületmegjelenítés: alapértelmezett; Területi beállítások: hu-HU (hu_HU); Calc: CL Version: 5.0.0.5 Build ID: 1b1a90865e348b492231e1c451437d7a15bb262b Locale: hu-HU (hu_HU) Verzió: 4.0.0.3 (Build az.: 7545bee9c2a0782548772a21bc84a9dcc583b89)
Created attachment 162179 [details] Screenshot of the original document side by side in Excel and Calc
Reproduced in Version: 7.1.0.0.alpha0+ Build ID: e2b50a956cd34179d4f1e7f87834a94188011843 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded
Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/886c2e35fadc7813498da041fc4ea8a8ba2fb358 tdf#134118 Chart OOXML import: fix gaps in month based data It will be available in 7.1.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.
Verified in: Version: 7.1.0.0.alpha0+ (x64) Build ID: 34a09c9c61bff30e8c4d16132bb47b2b1b16e422 CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded