<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://wiki.openoffice.org/w/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Jebix</id>
	<title>Apache OpenOffice Wiki - User contributions [en]</title>
	<link rel="self" type="application/atom+xml" href="https://wiki.openoffice.org/w/api.php?action=feedcontributions&amp;feedformat=atom&amp;user=Jebix"/>
	<link rel="alternate" type="text/html" href="https://wiki.openoffice.org/wiki/Special:Contributions/Jebix"/>
	<updated>2026-11-19T17:16:19Z</updated>
	<subtitle>User contributions</subtitle>
	<generator>MediaWiki 1.35.14</generator>
	<entry>
		<id>https://wiki.openoffice.org/w/index.php?title=Talk:Extensions_development_basic&amp;diff=13546</id>
		<title>Talk:Extensions development basic</title>
		<link rel="alternate" type="text/html" href="https://wiki.openoffice.org/w/index.php?title=Talk:Extensions_development_basic&amp;diff=13546"/>
		<updated>2006-07-06T02:48:36Z</updated>

		<summary type="html">&lt;p&gt;Jebix: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Name Change Proposal ==&lt;br /&gt;
&lt;br /&gt;
I think the name of this article should be changed to &amp;#039;&amp;#039;OpenOffice.org Basic&amp;#039;&amp;#039;. I know that the &amp;#039;&amp;#039;OpenOffice.org&amp;#039;&amp;#039; part sounds redundant because the whole wiki is about OpenOffice.org. However, the title &amp;#039;&amp;#039;Basic&amp;#039;&amp;#039; would be too generic. Check out Wikipedia where there is already an article called &amp;#039;&amp;#039;StarOffice Basic&amp;#039;&amp;#039;. Not much there though.&lt;br /&gt;
&lt;br /&gt;
Only reason I bring this up is that I had trouble finding out the basics of writing Basic code in OOo. I googled into the [[custom functions]] article and I scanned through Category:Basic:Tutorials and did not see anything. [[User:Jebix|Jebix]] 04:48, 6 July 2006 (CEST)&lt;/div&gt;</summary>
		<author><name>Jebix</name></author>
	</entry>
	<entry>
		<id>https://wiki.openoffice.org/w/index.php?title=Talk:Custom_functions&amp;diff=13545</id>
		<title>Talk:Custom functions</title>
		<link rel="alternate" type="text/html" href="https://wiki.openoffice.org/w/index.php?title=Talk:Custom_functions&amp;diff=13545"/>
		<updated>2006-07-06T02:37:05Z</updated>

		<summary type="html">&lt;p&gt;Jebix: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Where to put code ==&lt;br /&gt;
&lt;br /&gt;
It&amp;#039;s great to see some explanation on creating custom functions. I have not seen the functions I write show up in the function wizard in the &amp;#039;&amp;#039;&amp;#039;Function&amp;#039;&amp;#039;&amp;#039; list box of the &amp;#039;&amp;#039;&amp;#039;Functions&amp;#039;&amp;#039;&amp;#039; tab. This made me believe at first that I was not putting my custom function code in the right place or that I needed to change a setting.&lt;br /&gt;
&lt;br /&gt;
Could someone explain where exactly the code should be placed? [[User:Jebix|Jebix]] 04:04, 6 July 2006 (CEST)&lt;br /&gt;
&lt;br /&gt;
: Sorry I missed it. A good explanation about where to write code is already in the article [[Extensions development basic]] page. Maybe &amp;#039;&amp;#039;Extensions development basic&amp;#039;&amp;#039; is not the best name. I think &amp;#039;&amp;#039;OpenOffice.org Basic&amp;#039;&amp;#039; might be a better name. The title &amp;#039;&amp;#039;Basic&amp;#039;&amp;#039; alone would just be too meaningless or else I would just suggest it instead. [[User:Jebix|Jebix]] 04:37, 6 July 2006 (CEST)&lt;/div&gt;</summary>
		<author><name>Jebix</name></author>
	</entry>
	<entry>
		<id>https://wiki.openoffice.org/w/index.php?title=Custom_functions&amp;diff=13544</id>
		<title>Custom functions</title>
		<link rel="alternate" type="text/html" href="https://wiki.openoffice.org/w/index.php?title=Custom_functions&amp;diff=13544"/>
		<updated>2006-07-06T02:28:36Z</updated>

		<summary type="html">&lt;p&gt;Jebix: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;=Simple functions=&lt;br /&gt;
&lt;br /&gt;
You can write simple functions to make your spreadsheets more readable and easier to maintain. The process of developing and using these functions is very similar to other spreadsheet applications. For an introduction see [[Extensions development basic]]. Some examples in OpenOffice.org Basic follow. &lt;br /&gt;
&lt;br /&gt;
==Cell as an argument==&lt;br /&gt;
&amp;lt;code&amp;gt;[oobas]&lt;br /&gt;
Function Cube( c1 )&lt;br /&gt;
    Cube = c1 * c1 * c1&lt;br /&gt;
End Function&lt;br /&gt;
&amp;lt;/code&amp;gt;&lt;br /&gt;
You can put &amp;#039;&amp;#039;=Cube(A1)&amp;#039;&amp;#039; in any cell. &lt;br /&gt;
&lt;br /&gt;
==More cells as the arguments==&lt;br /&gt;
&amp;lt;code&amp;gt;[oobas]&lt;br /&gt;
Function SimpleSum( c1, c2 )&lt;br /&gt;
    SimpleSum = c1 + c2&lt;br /&gt;
End Function&lt;br /&gt;
&amp;lt;/code&amp;gt;&lt;br /&gt;
You can put &amp;#039;&amp;#039;=SimpleSum(A1;A2)&amp;#039;&amp;#039; in any cell. &lt;br /&gt;
&lt;br /&gt;
==Cells range as an argument==&lt;br /&gt;
&amp;lt;code&amp;gt;[oobas]&lt;br /&gt;
Function MySum( oRange As Variant )&lt;br /&gt;
If Not IsArray( oRange ) Then&lt;br /&gt;
        If IsNumeric( oRange ) Then&lt;br /&gt;
                MySum = oRange&lt;br /&gt;
        else&lt;br /&gt;
                MySum = 0&lt;br /&gt;
        End If&lt;br /&gt;
        Exit Function&lt;br /&gt;
End If&lt;br /&gt;
 &lt;br /&gt;
Dim nSum As double&lt;br /&gt;
 &lt;br /&gt;
nSum = 0&lt;br /&gt;
 &lt;br /&gt;
For i = 1 To ubound( oRange, 1 )&lt;br /&gt;
        For j = 1 To ubound( oRange, 2 )&lt;br /&gt;
 &lt;br /&gt;
                If IsNumeric( oRange( i, j ) ) Then&lt;br /&gt;
                        nSum = nSum + oRange( i, j )            &lt;br /&gt;
                End If&lt;br /&gt;
        Next j&lt;br /&gt;
Next i&lt;br /&gt;
 &lt;br /&gt;
MySum = nSum&lt;br /&gt;
End Function&lt;br /&gt;
&amp;lt;/code&amp;gt;&lt;br /&gt;
You can put &amp;#039;&amp;#039;=MySum(A1:A3)&amp;#039;&amp;#039; in any cell. &lt;br /&gt;
&lt;br /&gt;
It is not possible to write to custom function that uses a cell range that spans sheets. E.g. &amp;lt;tt&amp;gt;=Sheet1.A2:Sheet2.A2&amp;lt;/tt&amp;gt; instead you would have to have separate parameters for each sheet.&lt;br /&gt;
&lt;br /&gt;
[[Category:Basic:Tutorials]]&lt;/div&gt;</summary>
		<author><name>Jebix</name></author>
	</entry>
	<entry>
		<id>https://wiki.openoffice.org/w/index.php?title=Custom_functions&amp;diff=13543</id>
		<title>Custom functions</title>
		<link rel="alternate" type="text/html" href="https://wiki.openoffice.org/w/index.php?title=Custom_functions&amp;diff=13543"/>
		<updated>2006-07-06T02:23:07Z</updated>

		<summary type="html">&lt;p&gt;Jebix: Added a header paragraph with background on where to write the code.&lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;=Simple functions=&lt;br /&gt;
&lt;br /&gt;
You can write simple functions to make your spreadsheets more readable and easier to maintain. The process of developing and using these functions is very similar to other spreadsheet applications. To start writing code, from the menu select &amp;#039;&amp;#039;&amp;#039;Tools&amp;#039;&amp;#039;&amp;#039; -&amp;gt; &amp;#039;&amp;#039;&amp;#039;Macros&amp;#039;&amp;#039;&amp;#039; -&amp;gt; &amp;#039;&amp;#039;&amp;#039;Organize Macros&amp;#039;&amp;#039;&amp;#039; and choose a scripting language: OpenOffice.org Basic, Python, or BeanShell. Find your file in the dialog box, select it, and then press the &amp;#039;&amp;#039;&amp;#039;New&amp;#039;&amp;#039;&amp;#039; button. This creates a new module where you can type in your code. After you create the module, an editor window will open and you can start writing your code. Some examples in OpenOffice.org Basic follow. &lt;br /&gt;
&lt;br /&gt;
==Cell as an argument==&lt;br /&gt;
&amp;lt;code&amp;gt;[oobas]&lt;br /&gt;
Function Cube( c1 )&lt;br /&gt;
    Cube = c1 * c1 * c1&lt;br /&gt;
End Function&lt;br /&gt;
&amp;lt;/code&amp;gt;&lt;br /&gt;
You can put &amp;#039;&amp;#039;=Cube(A1)&amp;#039;&amp;#039; in any cell. &lt;br /&gt;
&lt;br /&gt;
==More cells as the arguments==&lt;br /&gt;
&amp;lt;code&amp;gt;[oobas]&lt;br /&gt;
Function SimpleSum( c1, c2 )&lt;br /&gt;
    SimpleSum = c1 + c2&lt;br /&gt;
End Function&lt;br /&gt;
&amp;lt;/code&amp;gt;&lt;br /&gt;
You can put &amp;#039;&amp;#039;=SimpleSum(A1;A2)&amp;#039;&amp;#039; in any cell. &lt;br /&gt;
&lt;br /&gt;
==Cells range as an argument==&lt;br /&gt;
&amp;lt;code&amp;gt;[oobas]&lt;br /&gt;
Function MySum( oRange As Variant )&lt;br /&gt;
If Not IsArray( oRange ) Then&lt;br /&gt;
        If IsNumeric( oRange ) Then&lt;br /&gt;
                MySum = oRange&lt;br /&gt;
        else&lt;br /&gt;
                MySum = 0&lt;br /&gt;
        End If&lt;br /&gt;
        Exit Function&lt;br /&gt;
End If&lt;br /&gt;
 &lt;br /&gt;
Dim nSum As double&lt;br /&gt;
 &lt;br /&gt;
nSum = 0&lt;br /&gt;
 &lt;br /&gt;
For i = 1 To ubound( oRange, 1 )&lt;br /&gt;
        For j = 1 To ubound( oRange, 2 )&lt;br /&gt;
 &lt;br /&gt;
                If IsNumeric( oRange( i, j ) ) Then&lt;br /&gt;
                        nSum = nSum + oRange( i, j )            &lt;br /&gt;
                End If&lt;br /&gt;
        Next j&lt;br /&gt;
Next i&lt;br /&gt;
 &lt;br /&gt;
MySum = nSum&lt;br /&gt;
End Function&lt;br /&gt;
&amp;lt;/code&amp;gt;&lt;br /&gt;
You can put &amp;#039;&amp;#039;=MySum(A1:A3)&amp;#039;&amp;#039; in any cell. &lt;br /&gt;
&lt;br /&gt;
It is not possible to write to custom function that uses a cell range that spans sheets. E.g. &amp;lt;tt&amp;gt;=Sheet1.A2:Sheet2.A2&amp;lt;/tt&amp;gt; instead you would have to have separate parameters for each sheet.&lt;br /&gt;
&lt;br /&gt;
[[Category:Basic:Tutorials]]&lt;/div&gt;</summary>
		<author><name>Jebix</name></author>
	</entry>
	<entry>
		<id>https://wiki.openoffice.org/w/index.php?title=Talk:Custom_functions&amp;diff=13542</id>
		<title>Talk:Custom functions</title>
		<link rel="alternate" type="text/html" href="https://wiki.openoffice.org/w/index.php?title=Talk:Custom_functions&amp;diff=13542"/>
		<updated>2006-07-06T02:04:25Z</updated>

		<summary type="html">&lt;p&gt;Jebix: &lt;/p&gt;
&lt;hr /&gt;
&lt;div&gt;== Where to put code ==&lt;br /&gt;
&lt;br /&gt;
It&amp;#039;s great to see some explanation on creating custom functions. I have not seen the functions I write show up in the function wizard in the &amp;#039;&amp;#039;&amp;#039;Function&amp;#039;&amp;#039;&amp;#039; list box of the &amp;#039;&amp;#039;&amp;#039;Functions&amp;#039;&amp;#039;&amp;#039; tab. This made me believe at first that I was not putting my custom function code in the right place or that I needed to change a setting.&lt;br /&gt;
&lt;br /&gt;
Could someone explain where exactly the code should be placed? [[User:Jebix|Jebix]] 04:04, 6 July 2006 (CEST)&lt;/div&gt;</summary>
		<author><name>Jebix</name></author>
	</entry>
</feed>