Apache OpenOffice Community Forum

Posted: **Sun Mar 06, 2022 4:59 pm**

I have the following function to translate a number (1... 26) into a character "A"..."Z"

function test(n as integer) as string
dim s(26) as string
s(0)=" "
s(1)="A"
s(2)="B"
' etc. 
s(25)="C"
s(26)="Z"
test = s(n)
end function

it generates the runtime error with the arrow on the line with: test=s(n)
I am missing something (beginner).
BTW is any calc-function usable in Basic?

Posted: **Sun Mar 06, 2022 6:05 pm**

Try:

Code: Select all

 chr(n+64)

Posted: **Mon Mar 07, 2022 2:42 pm**

Code: Select all

function test(optional n as integer) as string

And manage yourself if n is missing

Posted: **Sun Dec 31, 2023 1:31 am**

That worked for me too, thanks.

Both sub A and sub B called sub C (with 2 parameters). When called from sub A, sub C worked fine. When called from sub B, sub C always produced the run-time error "argument not optional". So I made both parameters optional; now A and B can call C with no errors.

Apache OpenOffice Community Forum

[Solved] BASIC runtime error; Argument is not optional

[Solved] BASIC runtime error; Argument is not optional

Re: BASIC runtime error; Argument is not optional

Re: BASIC runtime error; Argument is not optional

Re: [Solved] BASIC runtime error; Argument is not optional