Issue 92056

Summary: localize the separators in formula expressions
Product: Calc Reporter: kyoshida
Component: codeAssignee: AOO issues mailing list <issues>
Status: ACCEPTED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, ooo
Version: DEV300m26   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on: 106959, 107458    
Issue Blocks:    
Description Flags
screenshot of Formula options page none

Description kyoshida 2008-07-23 20:53:43 UTC
Make the parameter separator, and array column and row separators locale
dependent so that e.g. in the English locale they will be ',' ',' and ';'.
Comment 1 kyoshida 2008-07-23 21:03:50 UTC
Comment 2 ooo 2008-11-20 19:53:20 UTC
When browsing the thread
especially for the Russian locale
xlRowSeparator: :
as mentioned in
I have serious doubts about the sanity of such feature, given that ':'
is also the range operator (or is even that different in a Russian Excel
localization?). We'd need special treatment of common operators when
within array constants in that case.

Of course the request to support ',' as the parameter separator makes
much sense, so does flexibility in decimal separator, and array
constants' row separator would also be nice. We will have to give up the
possibility to parse group separators within formula values. We should
ask ourself though to what extend we are willing to support some quirks
that different locales in Excel introduced and maybe changed between
Excel releases? Should we allow arbitrary configuration of the array
constants' row separator because expressions aren't possible anyway? Or
should there be the prerequisite that no separator shall clash with an

Anyway, we'll end up with configurable separators, to be defaulted to
whatever UX thinks would be right, current OOo or (Excel) locale
dependent. Plus we'd need either pointers in or locale dependent online
help if the latter. Sounds like a nightmare to me. YMMV.

My 0,02 €
Comment 3 kyoshida 2008-12-12 05:55:54 UTC
I believe, given all possible scenarios, providing a set of configurable
separators would make most sense.  We can't possibly emulate Excel's separators
in all locales, but we should at least cover major locales, leave the users an
option to change them if they don't like the default values.

The UI should impose some restrictions on what character can be used as
separators.  It's messy but possible.

In on-line help, we could probably just use the current set of separators, with
a pointer to the separator configuration.  It may become messy, but I think it's
the role of on-line help to supplement the feature but the feature should always
come first.  IOW, the on-line help itself should not limit what feature should
or should not be implemented.
Comment 4 kyoshida 2008-12-12 06:12:24 UTC
Created attachment 58760 [details]
screenshot of Formula options page
Comment 5 kyoshida 2008-12-12 06:13:54 UTC
I've made a new configuration option page - 'Formula' - to allocate more space
for this.  I've also moved the formula syntax option to this page, as I feel the
two options should be side-by-side.
Comment 6 ccheney 2009-02-04 13:51:24 UTC
The formula documentation needs to somehow reflect the new separators as well.
Comment 7 Rob Weir 2013-07-30 02:47:53 UTC
Reset assignee on issues not touched by assignee in more than 1000 days.