Using Comma for Functions

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Using Comma for Functions

Jay Azar
Hey team,

I love your application, I even prefer it over MS Office. However, in Calc,
I am trying to use a comma instead semicolon for functions but I cannot
find out how to change it.

May you assist me?


Best regards,

Jay Azar
Territory Sales Manager, Qatar
Brady Corporation
Office: +974 4020 6615
Mobile: +974 5592 5691
Reply | Threaded
Open this post in threaded view
|

Re: Using Comma for Functions

Leon Zar
Hi Jay,
I don't think OO allows this to be changed.  I believe that it requires
semicolon because some locales use a comma as the decimal separator.  There
may be a language locale that would accept comma as the separator, but
you'd have to experiment to find out, and it would likely change the
currency character (and spelling dictionary).  Locales are specified under
options/preferences "Language Settings".  (Note:  LibreOffice does allow
specification of the parameter separator independent of locale).
Best regards,
  Leon Zar


On Tue, Mar 13, 2018 at 3:32 AM, Jay Azar <[hidden email]> wrote:

> Hey team,
>
> I love your application, I even prefer it over MS Office. However, in Calc,
> I am trying to use a comma instead semicolon for functions but I cannot
> find out how to change it.
>
> May you assist me?
>
>
> Best regards,
>
> Jay Azar
> Territory Sales Manager, Qatar
> Brady Corporation
> Office: +974 4020 6615
> Mobile: +974 5592 5691
>
Reply | Threaded
Open this post in threaded view
|

Re: Using Comma for Functions

Johnny Rosenberg
In reply to this post by Jay Azar
2018-03-13 9:32 GMT+01:00 Jay Azar <[hidden email]>:

> Hey team,
>
> I love your application, I even prefer it over MS Office. However, in Calc,
> I am trying to use a comma instead semicolon for functions but I cannot
> find out how to change it.
>
> May you assist me?
>

I don't have Apache OpenOffice installed at the moment, but I remember that
there was a setting for this when I did. In LibreOffice I find it at Tools
→ Options… → LibreOffice Calc → Formula. I know LibreOffice is a lot
different from Apache OpenOffice these days, but hopefully this takes you a
little bit closer to the answer.


Kind regards

Johnny Rosenberg



>
>
> Best regards,
>
> Jay Azar
> Territory Sales Manager, Qatar
> Brady Corporation
> Office: +974 4020 6615
> Mobile: +974 5592 5691
>