# how to know a locale's delimiter for combining data series

The delimiter for combining data ranges for a chart is based on the locale. How can users find the delimiter for their locale?

edit retag close merge delete

In the line where you can edit the DataRanges for a chart you can have non-contigiouis ranges listed with the semicolon as the delimiter. What alternative delimiter(s) are you talking of?

( 2019-08-18 00:25:20 +0200 )edit

A semicolon does not work for me. I eventually found that in my locale, I need to use a comma. It seems to me that users should have a way to find out what the delimiter is for their locale.

( 2019-08-18 04:36:28 +0200 )edit

Wouldn't it be an idea to simply to tell what "my locale" and other related settings are?
In fact there seems to be an inconsistency (bug):
Formulae still always accept the semicolon as a parameter separator in functions. They only automatically change it to a comma for display if the setting @m.a.riosv mentioned chose the comma. The Data Ranges... line, however only accepts the chosen separator - and this despite the fact that there isn't any function needing to separate any parameters.
This seems to follow the "Principle of Maximal Confusion" ruling the surface of Office software next to completely.

( 2019-08-18 13:13:29 +0200 )edit

@m.a.riosv mainly:
I filed the bug tdf#127007 concerning this matter.

( 2019-08-18 15:01:00 +0200 )edit

@Lupp, set up as new.

( 2019-08-18 15:46:23 +0200 )edit

Sort by » oldest newest most voted
Menu/Tools/Options/LibreOffice calc/Formula - Separators

more

Thank you. This made me realize that the LibreOffice Calc options are not available when the chart is in edit mode. Could that be considered a bug?

( 2019-08-18 16:06:05 +0200 )edit

I don't think so, and I think it would be really complicated to manage the changes on the fly with security.

( 2019-08-18 16:31:00 +0200 )edit

I don't know much about this and am not sure what you mean. How is chart edit mode related to security?

( 2019-08-18 17:04:16 +0200 )edit

The only settings you need to consider (and probably try) are the semicolon (good) and the comma (doubtable). Other settings can be made, but it's very unlikely that someone did it.

( 2019-08-18 22:27:49 +0200 )edit

How is chart edit mode related to security?

I suppose that @m.a.riosv meant "it is hard to do reliably" ... IIRC, we used to have all possible option categories available in the dialog, regardless of which modules are open and which is active at the moment; and we changed that to only show the active one for some reason (possibly to reduce users' confusion?) at some point. (Yes, I have checked that to be true - and it was changed between OOo 1.0.3 and OOo 2.2.0 :-))

( 2019-08-25 16:17:44 +0200 )edit