When entering arguments to text funtions in the Function Wizard, arguments which can not be interpreted should be treated as strings and be automatically quotetd. For now arguments which can not be parsed yield the result #NAME?.
I disagree. Mistyped arguments should not silently be converted to literal strings.
(In reply to Eike Rathke from comment #1) > I disagree. Mistyped arguments should not silently be converted to literal > strings. Do you also have an argument, why there should be no conversion? Besides I wouldn't call an automatic quotation "silent". I participated in a LO training with average users and it was very hard for them to understand the need of quotation. In an example we had to construct E-Mail addresses from a names list with the Function Wizard: > =LOWER(CONCATENATE(A6,".",B6,"@",E6,".my-organisation.org") ) In cases like this example it is possible to infer the type of the arguments and conduct an automatic quotation. This is a question of providing an intuitive user interface.
Dear Max Harmathy, this enhancement request has been in UNCONFIRMED status with no activity for more than 1 year, lacking interest from the Community. Besides, the main Calc developer disagrees with the idea. Closing as RESOLVED WONTFIX