[Bug 60915] New: XLS to HTML Charts to coming

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

[Bug 60915] New: XLS to HTML Charts to coming

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=60915

            Bug ID: 60915
           Summary: XLS to HTML Charts to coming
           Product: POI
           Version: 3.15-FINAL
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: blocker
          Priority: P2
         Component: HSLF
          Assignee: [hidden email]
          Reporter: [hidden email]
  Target Milestone: ---

I am using ExcelToHtmlConverter provided by POI to xls to pdf conversion.
Somehow in the output I am not getting charts.

I thought of adding one more method in ExcelToHtmlConverter named as
processChart by extending the class. Sample method -

 //TODO convert chart to images and add to output
    private void processChart(HSSFSheet sheet) {
        for(HSSFChart chart : HSSFChart.getSheetCharts(sheet)){
            Element table = this.htmlDocumentFacade.createTable();
            this.htmlDocumentFacade.addStyleClass(table,
this.cssClassPrefixTable, "border-collapse:collapse;border-spacing:0;");
            Element tableBody = this.htmlDocumentFacade.createTableBody();
            tableBody.setTextContent(chart.getChartTitle());
            table.appendChild(tableBody);
            this.htmlDocumentFacade.getBody().appendChild(table);
        }
    }


Somehow I am not able to convert this HSSFChart to image. Please suggest me a
way to convert to chart to image or to add them in final output.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 60915] XLS to HTML Charts not coming

Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=60915

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|XLS to HTML Charts to       |XLS to HTML Charts not
                   |coming                      |coming

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 60915] XLS to HTML Charts not coming

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=60915

[hidden email] changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
          Component|HSLF                        |HSSF

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

[Bug 60915] XLS to HTML Charts not coming

Bugzilla from bugzilla@apache.org
In reply to this post by Bugzilla from bugzilla@apache.org
https://bz.apache.org/bugzilla/show_bug.cgi?id=60915

Javen O'Neal <[hidden email]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Severity|blocker                     |enhancement
         Resolution|---                         |INVALID
             Status|NEW                         |RESOLVED

--- Comment #1 from Javen O'Neal <[hidden email]> ---
I am not sure what the issue is. Sounds like a mixture of a usage question and
a feature enhancement request. ExcelToHtmlConverter outputs to HTML, not PDF.
POI currently cannot render charts to images. If anyone is interested in
improving the charts API, we encourage them to contact us on the mailing list.

--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]