Apache OpenOffice Community Forum

Posted: **Fri Dec 16, 2011 5:32 pm**

I have the following code snippet :

Sub Main
  Dim momDocument, maTable As Object
  Dim cursCell as Object
  monDocument = ThisComponent
  
  maTable = monDocument.TextTables.getByName( "Tableau1" )
  cursCell = maTable.createCursorByCellName( "A1" )

  oGTP = CreateUnoService("com.sun.star.gallery.GalleryThemeProvider")
  sName = "ACVF-A..D"
 
  If oGTP.hasByName(sName) Then
    oTheme = oGTP.getByName(sName)
    nCount = oTheme.getCount()
    oItem = oTheme.getByIndex(nCount -1)


    // how to add the gallery image to the cell pointed by cursCell ?


  End If
End Sub

Having the reference

Code: Select all

cursCell

to the TableCellCursor of a Writer document , how can I add the gallery image

Code: Select all

oItem

to that position ? Is there any method that helps me to get a gallery item by name ?

Posted: **Mon Dec 19, 2011 6:59 pm**

Insert image with oItem.URL of the image URL by general way which is known and can be found in this forum through the API.

Is there any method that helps me to get a gallery item by name ?

I have not seen it.

Posted: **Wed Dec 21, 2011 2:35 pm**

Thanks to all that helped my to finally reach my goal. Here is the solution :

Code: Select all

sub instertItemToCell( sItem as String, sTable as String, sCell as String )
    	
	C_TotalPageWidth = 18800
	oTextGraphicObject = ThisComponent.createInstance("com.sun.star.text.TextGraphicObject")

	oItem = getItemFromGallery(sItem)
	
	if not IsNull( oItem ) then
		oGraphic = oItem.Graphic
		oSize = oGraphic.Size
	
		oTable = ThisComponent.TextTables.getByName(sTable)
		oCursCell = oTable.getCellByName(sCell)
		
  		oColumns = oTable.getPropertyValue( "TableColumnSeparators" )
 		iColSeparator = oColumns(0).Position REM position of the first column separator
 		iTotalColumns = oTable.TableColumnRelativeSum
 	
  		rWidthRatio = iColSeparator/iTotalColumns
 		iGraphicWidth = C_TotalPageWidth*rWidthRatio
 		rGraphicAmplify = iGraphicWidth/oSize.Width
 		iGraphicHeight = oSize.Height*rGraphicAmplify
 	
 		oSize.Width = iGraphicWidth
 		oSize.Height = iGraphicHeight
 		
		oTextGraphicObject.Graphic = oGraphic
		oTextGraphicObject.setSize(oSize)

    
    	oCursText = oCursCell.Text
   		oTextCellCurs = oCursText.createTextCursor
   		
    	oCursText.insertTextContent( oTextCellCurs, oTextGraphicObject, true)	
    end if
end sub

Posted: **Fri Oct 16, 2020 12:30 pm**

brunnerdan wrote:Is there any method that helps me to get a gallery item by name ?

Presuming by name, you meant title. The item's name (in a document) is not necessarily the same as the item's title (in the gallery). I used this code to get a gallery item by title.

Code: Select all

   Cache = CreateUnoService("com.sun.star.gallery.GalleryThemeProvider")
   Theme = Cache.getByName("MyShapes")
   For Nth = 0 To Theme.Count - 1
      Shp = Theme(Nth)
      If Shp.Title = "‹ShapeTitle›" Then Exit For
   Next

Apache OpenOffice Community Forum

[Solved] How to add a gallery image into a Writer table Cell

[Solved] How to add a gallery image into a Writer table Cell

Re: Howto add a gallery image into a Writer table Cell ?

Re: Howto add a gallery image into a Writer table Cell ?

Re: [Solved] How to add a gallery image into a Writer table