Bug 134118

Summary: FILEOPEN XLSX Date axis tries to display empty items in range with month resolution
Product: LibreOffice Reporter: NISZ LibreOffice Team <libreoffice>
Component: ChartAssignee: Balázs Varga <varga.balazs3>
Status: VERIFIED FIXED    
Severity: normal CC: nemeth, tundeth, varga.balazs3, xiscofauli
Priority: medium    
Version: Inherited From OOo   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=133672
Whiteboard: target:7.1.0
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 75057    
Attachments: Example file from Excel
Screenshot of the original document side by side in Excel and Calc

Description NISZ LibreOffice Team 2020-06-18 16:03:14 UTC 
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)
Comment 1 NISZ LibreOffice Team 2020-06-18 16:03:51 UTC 
Created attachment 162179 [details]
Screenshot of the original document side by side in Excel and Calc
Comment 2 Xisco Faulí 2020-07-03 09:41:37 UTC 
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
Comment 3 Commit Notification 2020-08-23 11:06:31 UTC 
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.
Comment 4 NISZ LibreOffice Team 2020-09-14 09:55:58 UTC 
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