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: [email protected]
          Reporter: [email protected]

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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to