You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2016/05/25 09:05:05 UTC

[Bug 59631] New: LineChart not working: lines not shown

https://bz.apache.org/bugzilla/show_bug.cgi?id=59631

            Bug ID: 59631
           Summary: LineChart not working: lines not shown
           Product: POI
           Version: 3.14-FINAL
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: michael.holtermann@dfb-medien.de

Created attachment 33887
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=33887&action=edit
File rendered from org.apache.poi.xssf.usermodel.examples.LineChart

I'm trying to create a Line Chart following the example in
org.apache.poi.xssf.usermodel.examples.LineChart.

Unfortunately, the rendered XLSX will contain a LineChart that's not readable.
I'll attach the file.

You may clik through the chart, select the line and apply some styling in Excel
or LibreOffice.

I think there's something wrong within 'chart1.xml', somewhere near 
<c:lineChart>
<c:varyColors val="false"/>
<c:ser>
<c:idx val="0"/>
<c:order val="0"/>
<c:marker>
<c:symbol val="none"/>
</c:marker>

It seams the Chart API does not contain any possiblity to style the chart, do
it?

Regards, Michael

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 59631] LineChart not working: lines not shown

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59631

--- Comment #1 from Michael <mi...@dfb-medien.de> ---
Created attachment 33928
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=33928&action=edit
Workaround by using an empty Excel file as template

I've found a workaround:
1. create an empty Excel file and save it
2. use that file as "template" in "new XSSFWorkbook(file)"

Now the chart contains some styling, the lines are visible.

I'll attach the template file and a slightly adopted
"org.apache.poi.xssf.usermodel.examples.LineChart".

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 59631] LineChart not working: lines not shown

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59631

Alain Fagot Bearez <Al...@cua.li> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |FIXED
             Status|NEW                         |RESOLVED

--- Comment #3 from Alain Fagot Bearez <Al...@cua.li> ---
Styling the charts has been introduced in r1820369 by defining
XDDFShapeProperties.

An example can be found in example 
org.apache.poi.xssf.usermodel.examples.BarChart

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


[Bug 59631] LineChart not working: lines not shown

Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59631

--- Comment #2 from Michael <mi...@dfb-medien.de> ---
Created attachment 33929
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=33929&action=edit
Adopted LineChart example, uses emptyTemplate.xlsx

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org