[Libreoffice-bugs] [Bug 112250] New: empty values in y-axis of empty chart

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 112250
           Summary: empty values in y-axis of empty chart
           Product: LibreOffice
           Version: 5.4.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: marc.oggier at megavolts.ch

Description:
When importing a xlsx spreadsheet, containing a chart, modified with openoffice
with python using openpyxl modulel, it raised an error. After digging into it
with the openpyxl developper, we find out the issue was related to handling
empty values in y-axis of the chart. The specification says that [NumVal]
elements must have a [v] child which must contain a string.

In my document I have an empty/None value
        <c:pt idx="1">
         <c:v>

         </c:v>

When it should be float or a string like
        <c:pt idx="1">
         <c:v>
          0.0
         </c:v>



Steps to Reproduce:
1. Saving files with an empty chart

Actual Results:  
The [NumVal] elements have a [v] child which is empty/None:

        <c:pt idx="1">
         <c:v>

         </c:v>

Expected Results:
The [NumVal] elements have a [v] child which is a string, according to the
specifications

        <c:pt idx="1">
         <c:v>
             0.0
         </c:v>


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:55.0) Gecko/20100101
Firefox/55.0

-- 
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/20170905/1cb22669/attachment.html>