How to Apply an Add-In to a Chart Document

OpenOffice.org Developer's Guide

Charts

< Previous Section

Next Section >

• Handling Chart Documents

• Creating and Adding a Chart to a Spreadsheet
• Creating a Chart OLE Object in Draw and Impress
• Setting the Chart Type
• Accessing Existing Chart Documents

• Working With Charts

• Data Access
• Chart Document Parts

• Common Parts of all Chart Types
• Features of Special Chart Types

• Statistics
• 3-D Charts
• Pie Charts
• Stock Charts

• Chart Document Controller
• Chart Add-Ins

• Prerequisites
• How Add-Ins Work
• How to Apply an Add-In to a Chart Document

< Previous Page

Next Page >

There is no method to set an add-in as a chart type for an existing chart in the graphical user interface. To set the chart type, use an API script, for instance, in OpenOffice.org Basic. The following example sets the add-in with service name “com.sun.star.comp.Chart.JavaSampleChartAddIn” at the current document. To avoid problems, it is advisable to create a chart that has the same type as the one that the add-in sets as BaseDiagram type.

 Sub SetAddIn
 Dim oDoc As Object
 Dim oSheet As Object
 Dim oTableChart As Object
 Dim oChart As Object
 Dim oAddIn As Object
 
     ' assume that the current document is a spreadsheet
     oDoc = ThisComponent
     oSheet = oDoc.Sheets( 0 )
     
     ' assume also that you already added a chart
     ' named "MyChart" on the first sheet
     oTableChart = oSheet.Charts.getByName( "MyChart" )
   
     If Not IsNull( oTableChart ) Then
         oChart = oTableChart.EmbeddedObject
         If Not IsNull( oChart ) Then
             oAddIn = oChart.createInstance( "com.sun.star.comp.Chart.JavaSampleChartAddIn" )
             If Not IsNull( oAddIn ) Then
                 oChart.setDiagram( oAddIn )
             End If
         End If
     End If
 End Sub

Content on this page is licensed under the Public Documentation License (PDL).