[Libreoffice-bugs] [Bug 123834] New: FILEOPEN XLSX Line chart has gaps instead of 0.0 values if the cell content is a string

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 123834
           Summary: FILEOPEN XLSX Line chart has gaps instead of 0.0
                    values if the cell content is a string
           Product: LibreOffice
           Version: 6.3.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libreoffice at nisz.hu

Description:
If there is a cell with a string value (for example asdf1 or 2text_), in a line
chart it appears as a gap in LibreOffice, but in MSO it appears as 0 value.

Steps to Reproduce:
    1. Fill a column with some data (for example: 1, string1, empty cell,
2string, 3)
    2. Select the area of the data sequence
    3. Click on Insert menu and select chart
    4. Chose line in the chart type selection, then select points and lines or
lines only
    5. Click on finish
    6. Open the file in Calc and Excel and compare them

Actual Results:
In Calc, there are no lines between 1, string1 and 2string, 3 values, but there
will be in Excel.

Expected Results:
If a cell has string value, it should be interpreted as 0 value in a line
chart, in this example there should be lines between values 1, string1 and
2string, 3.


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
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/20190304/ba11875c/attachment.html>