[Libreoffice-bugs] [Bug 134118] New: FILEOPEN XLSX Date axis tries to display empty items in range with month resolution

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134118

            Bug ID: 134118
           Summary: FILEOPEN XLSX Date axis tries to display empty items
                    in range with month resolution
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Chart
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu
                CC: balazs.varga991 at gmail.com, nemeth at numbertext.org,
                    tundeth at gmail.com
            Blocks: 75057

Created attachment 162178
  --> https://bugs.documentfoundation.org/attachment.cgi?id=162178&action=edit
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)


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=75057
[Bug 75057] [META] OOXML Chart object issues
-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200618/65d1eb8f/attachment.htm>