Summary: | Threshold lines(Target values) cannot be created in all chart types in word, excel and ppt | ||
---|---|---|---|
Product: | POI | Reporter: | Chenna Kesavarao <chennak.s> |
Component: | XDDF | Assignee: | POI Developers List <dev> |
Status: | RESOLVED FIXED | ||
Severity: | enhancement | ||
Priority: | P2 | ||
Version: | 3.14-FINAL | ||
Target Milestone: | --- | ||
Hardware: | PC | ||
OS: | All |
Description
Chenna Kesavarao
2016-05-24 11:30:15 UTC
As http://poi.apache.org/spreadsheet/limitations.html states, charting is not fully implemented and there is currently no major effort underway to add it. If you really need functionality and have the skills, your best option will be to work out a patch together with some unit-tests which we then can discuss on and apply if it fits. Another option might be to find out what actual XML-conent is needed for these things and use the low-level getCT... methods and CT... classes to add these items in your code. microsoft is not yet providing support for this feature Despite not having a one-method solution for this, all underlying constructs are available. The recently introduced package XDDF offers bar charts (where an option is given to set the direction to columns) and scatter charts to draw the line. I suppose you could write an example using these resources as part of our ongoing documentation effort. I would consider the following example as an answer to this issue: /examples/src/org/apache/poi/xssf/usermodel/examples/ExcelChartWithTargetLine.java |