CALC: TEXT(number; format) doesn't work

[djb]

I want to convert a number to a string (in order to construct dynamic ranges in R1C1 format.)
I get error messages like non-closed parentheses.

It looks like the semicolon in the argument list causes this but the interpreter apparently doesn’t know about the TEXT function.

I am a bit confused about where I can find the proper functions that I can use for programming in the calc environment.

[anon73440385]

I get error messages like non-closed parentheses.

You ask for help, but you are not providing

• your number
• your formula
• your error message

So please tell us, how we could help you.

> interpreter apparently doesn't know about the TEXT function .... I am a bit confused about where I can find the proper functions that I can use for programming in the calc environment.

… and I’m confused what you are talking about, since that wording makes my gut feel you are talking about BASIC programming, which doesn’t know a TEXT() function. Could it be, that you assume Calc spreadsheet functions do exist the same way (syntax) in BASIC macros?

[mikekaganski]

See also: tdf#131382