I've searched high and low, and can't find a simple reference manual for OOo Basic.
For example:
- What values TextWrap could take?
- What command would let me insert a picture into a Writer document?
Where is the reference manual for OOo Basic, please?
Code: Select all
Dim MyItem as Object
MyItem = ThisComponent.CurrentSelection
I am in the same boat, I understand the basic bits and bobs, but I am trying to understand how to reference a cell. unfortunately I can only describe this with blasphemy, myvariable = worksheets("sheet1").cells(3,4)Paddy Landau wrote:Hmm...
Thanks for the pointer. I have gone through that (the Basic Programming Guide) already.
Are you saying that, having gone through the tutorial, I should look at the API documentation?
For example, how would I know how to use a selected object? (I know it's as follows, but how would I know if someone hadn't told me?)That's what I'm trying to get at. Where is the documentation that will help me learn this stuff?Code: Select all
Dim MyItem as Object MyItem = ThisComponent.CurrentSelection
For example, I want to change the current selection (which is a picture) to having "Wrap Through" (MyItem.TextWrap = 1) but also "In background" (and I can't find out how to do that).
Code: Select all
oSheet = ThisComponent.getSheets().getByName("Sheet1")
oCell = oSheet.getCellByPosition(3,2) ' Cell D3
It gives a cooking receipt for a tiny problem you may have at this moment. It does not explain anything. Next time you need another receipt.
Or evenrudolfo wrote: At the end you should find something like the following for your question:OpenOfffice counts cells in a table starting from index 0 and the first parameter is the column and the second the row.Code: Select all
oSheet = ThisComponent.getSheets().getByName("Sheet1") oCell = oSheet.getCellByPosition(3,2) ' Cell D3
Code: Select all
oCell = ThisComponent.Sheets.getCellByPosition(3,2,1) ' Cell D3 on second sheet
Coming from VBA, anything else is difficult. Just change your tools and your mind set. Install the MRI extension, explore its capabilities.franc wrote:Coming from VBA with IntelliSense and a good integrated help, it is hard and stony to get started with SB.
I did it:FJCC wrote:...but please start a new topic...