|
Click link
to request
|
Question
|
Date
(dd/mm/yy)
|
Length
|
|
|
|
|
|
|
1710
|
The following code written in OpenOffice.org Basic reads bytes from a file, processes the text and then writes the text into a textbox. This code shows how to access the textbox, and using file selection control.
|
30/04/07
|
1885
|
|
1709
|
The following code written in OpenOffice.org Basic reads text from a textbox, processes the text and then writes it back into the textbox. This code shows how to access the textbox.
|
30/04/07
|
1515
|
|
1037
|
The following is a OpenOffice.org Basic macro which calls Columba and provides the To, Subject and Body text completed.
|
06/09/04
|
1236
|
|
802
|
Link to keycode constants when a user presses a key.
|
29/12/03
|
314
|
|
801
|
This code snippet enables the user to insert special characters into text. (It does not support tables.) The user presses Control+S. A dialog then appears. The user can select by pressing on the first character of the list item or click using the mouse. The user needs to create a dialogue in order to use the macro.
|
29/12/03
|
2859
|
|
800
|
How do I move the dialogue and the buttons all at the same time?
|
29/12/03
|
211
|
|
799
|
When assigning an event to a dialogue button there is no way to pass a parameter. The following code gets around this issue by displaying information about the button which can then be used in subsequent code.
|
29/12/03
|
1098
|
|
798
|
Code snippet to insert a special character at the current cursor location. Applies to both Ascii and Unicode characters.
|
29/12/03
|
1159
|
|
797
|
Code snippets to move to the First or Last sheet in a Calc spreadsheet
|
29/12/03
|
549
|
|
796
|
A code snippet to place the cursor at a nominated cell position in a Calc spreadsheet.
|
29/12/03
|
743
|
|
793
|
We like to investigate the underlying data source information. This code shows how to query the metadata for the Scalar functions for an MS Access database using the ODBC driver.
|
23/12/03
|
1407
|
|
782
|
How do you determine the quote string to use around fields for SQL queries?
|
16/12/03
|
588
|
|
779
|
A Basic routine which provides the user with the ability to resize a group of selected controls on a form or shapes. This should be placed in a library although it could be a template. The keystrokes will need to be assigned so the routines can be run from the keyboard.
|
15/12/03
|
3059
|
|
778
|
Using the Windows API GetSystemMetrics dll to display screen resolution
|
14/12/03
|
444
|
|
753
|
As part of generating the Form look we also need to turn off the toolbars and status bar.
The following is a macro generated by the macro recorder in OpenOffice.org 1.1.
At this stage I have not been able to directly turn off the toolbars and the status bar so I have included the method which is available using the macro recorder.
The macro hides all the default toolbars. If you normally enable other toolbars then these should also be hidden. Simply use the macro recorder to determine the required values.
Note also this method turns off the toolbars for OpenOffice.org in general. Once the application is finished it would probably be wisest to turn all the toolbars back on again.
|
02/09/03
|
1499
|
|
752
|
Part of trying to make a window look like a form instead of a document is to turn of a number of window features.
The following macro turns of the scrolls bars, rulers and sets the layout to OnlineLayout so the page boundaries are not shown.
Also the Zoom Value is set to 100 so that it is a known magnification.
|
02/09/03
|
1018
|
|
751
|
The following macro shows how to set the title for the current window.
This does not permanently set the window title, just whilst the document is open.
When the document is opened again the window title will revert to the document title or the file name of the document.
|
02/09/03
|
193
|
|
750
|
In working out how to set the size and postion of a window as discussed in a previous question, we had to learn some information about properties and methods for particular objects.
This was very trial and error type stuff as there is very little documentation.
This macro shows is what we used to drill down the object heirarchy. Through trial and error and many hours of investigation we were able to get what we needed to achieve our objectives.
|
02/09/03
|
1510
|
|
749
|
The following macro provides the ability to set the current window position and size. The reason for this is to allow a Form to display in a window and look more like a Form than a document.
|
02/09/03
|
1000
|
|
747
|
How to select the dialog form so that it can be resized.
|
22/08/03
|
131
|
|
746
|
This code shows two macros. One is to open the dialog and the other is to close the dialog.
|
22/08/03
|
473
|
|
745
|
This short piece of code shows a macro to open a dialog.
|
22/08/03
|
276
|
|
744
|
The following are two macros for Calc which allow you to quickly go to the first sheet or the last sheet. These need to be assigned as buttons on a toolbar or to a keystroke combination.
|
26/05/03
|
542
|
|
743
|
In this example we create a form with a single label on it and set the background colour to Red. Each time the macro is run it changes the background colour of the label from red to green and back again.
|
20/05/03
|
914
|
|
742
|
This macro shows how to change the text on the button when it is pressed. The button toggles between the text 'start' and 'stop'.
|
20/05/03
|
768
|
|
741
|
OpenOffice.org 1.0.x from most users point of view had the short month format incorrect as September shows as Sep. This macro can be used in a spreadsheet to provide the normal shorter format of Sep.
It should be noted the date is converted to a text string so further date manipulations cannot be done on the value.
|
15/05/03
|
1491
|
|
740
|
How to add a your own functions to a Calc spreadsheet
|
12/05/03
|
186
|
|
739
|
Recursion is now available in Basic
|
07/05/03
|
255
|
|
738
|
A macro to perform a word count on the selected text.
|
16/04/03
|
2843
|
|
736
|
A macro to remove tabs in a section of text. This example uses the selected text. It only works for text in a document and not in other structure such as tables. It also does not work if the all text is selected.
|
25/03/03
|
1209
|
|
735
|
The following macro makes the current selected text bold. This macro is not about making the text bold, but showing how to use the currently selected text.
|
19/03/03
|
353
|
|
734
|
The example in the help on the Select Case does not appear to work. In particular the line 'Case Is > 8 And iVar < 11' does not work.
|
19/03/03
|
962
|
|
732
|
A macro to walk through a few records in the biblio table. Each record is displayed in a message box. A query is used to provide a subset of the records.
|
19/03/03
|
1208
|
|
730
|
I am having problems with a recursive subroutine.
|
13/03/03
|
74
|
|
729
|
It appears that all variables are passed by reference to subroutines. Is this correct?
|
12/03/03
|
141
|
|
728
|
When I enter a constant such as a number as a parameter in a subroutine I cannot put the parameter in a loop and progressively decrease the value. Why?
|
12/03/03
|
284
|
|
727
|
I want to start programming in the OpenOffice.org basic. Is there any good documentation available?
|
11/03/03
|
734
|
|
724
|
An example of a macro which moves to the next record.
|
04/03/03
|
579
|
|
723
|
An example of an OpenOffice.org Form macro which updates the image in a form as the user moves from record to record using the record navigation buttons.
|
04/03/03
|
517
|
|
722
|
An example of a macro in OpenOffice.org forms which updates a second image control when the text in a control is changed.
|
04/03/03
|
516
|
|
317
|
I want to start programming in the OpenOffice.org basic. Is there any good documentation available?
|
26/12/03
|
1327
|