|
Number
|
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
|
3432
|
|
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
|
2585
|
|
1037
|
The following is a OpenOffice.org Basic macro which calls Columba and provides the To, Subject and Body text completed.
|
06/09/04
|
1516
|
|
802
|
Link to keycode constants when a user presses a key.
|
29/12/03
|
343
|
|
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
|
4203
|
|
800
|
How do I move the dialogue and the buttons all at the same time?
|
29/12/03
|
227
|
|
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
|
1237
|
|
798
|
Code snippet to insert a special character at the current cursor location. Applies to both Ascii and Unicode characters.
|
29/12/03
|
1332
|
|
797
|
Code snippets to move to the First or Last sheet in a Calc spreadsheet
|
29/12/03
|
697
|
|
796
|
A code snippet to place the cursor at a nominated cell position in a Calc spreadsheet.
|
29/12/03
|
917
|
|
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
|
1628
|
|
782
|
How do you determine the quote string to use around fields for SQL queries?
|
16/12/03
|
660
|
|
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
|
4670
|
|
778
|
Using the Windows API GetSystemMetrics dll to display screen resolution
|
14/12/03
|
592
|
|
753
|
As part of generating the Form look we also need to turn off the toolbars and status bar.
|
02/09/03
|
3096
|
|
752
|
Part of trying to make a window look like a form instead of a document is to turn off a number of window features such as scroll bars, rulers and setting the layout to OnlineLayout and zoom level.
|
02/09/03
|
1854
|
|
751
|
The following macro shows how to set the title for the current window.
|
02/09/03
|
750
|
|
750
|
In working out how to set the size and postion of a window as discussed in question 749, we had to learn some information about properties and methods for particular objects and created a macro to view the information.
|
02/09/03
|
2752
|
|
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
|
1770
|
|
747
|
How to select the dialog form so that it can be resized.
|
22/08/03
|
139
|
|
746
|
This code shows two macros. One is to open the dialog and the other is to close the dialog.
|
22/08/03
|
549
|
|
745
|
This short piece of code shows a macro to open a dialog.
|
22/08/03
|
314
|
|
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
|
622
|
|
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
|
1094
|
|
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
|
948
|
|
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.
|
15/05/03
|
3315
|
|
740
|
How to add a your own functions to a Calc spreadsheet
|
12/05/03
|
202
|
|
739
|
Recursion is now available in Basic
|
07/05/03
|
280
|
|
738
|
A macro to perform a word count on the selected text.
|
16/04/03
|
4320
|
|
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
|
1467
|
|
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
|
389
|
|
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
|
1186
|
|
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
|
1520
|
|
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
|
146
|
|
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
|
300
|
|
727
|
I want to start programming in the OpenOffice.org basic. Is there any good documentation available?
|
11/03/03
|
798
|
|
724
|
An example of a macro which moves to the next record.
|
04/03/03
|
761
|
|
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
|
638
|
|
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
|
691
|
|
317
|
I want to start programming in the OpenOffice.org basic. Is there any good documentation available?
|
26/12/03
|
1391
|
