Ask Your Question

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

asked 2019-08-17 23:24:55 +0100

catbill gravatar image

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 flag offensive 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?

Lupp gravatar imageLupp ( 2019-08-18 00:25:20 +0100 )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.

catbill gravatar imagecatbill ( 2019-08-18 04:36:28 +0100 )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.

Lupp gravatar imageLupp ( 2019-08-18 13:13:29 +0100 )edit

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

Lupp gravatar imageLupp ( 2019-08-18 15:01:00 +0100 )edit

@Lupp, set up as new.

m.a.riosv gravatar imagem.a.riosv ( 2019-08-18 15:46:23 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-08-18 10:56:20 +0100

m.a.riosv gravatar image
Menu/Tools/Options/LibreOffice calc/Formula - Separators
edit flag offensive delete link 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?

catbill gravatar imagecatbill ( 2019-08-18 16:06:05 +0100 )edit

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

m.a.riosv gravatar imagem.a.riosv ( 2019-08-18 16:31:00 +0100 )edit

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

catbill gravatar imagecatbill ( 2019-08-18 17:04:16 +0100 )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.

Lupp gravatar imageLupp ( 2019-08-18 22:27:49 +0100 )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 :-))

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-25 16:17:44 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-08-17 23:24:55 +0100

Seen: 58 times

Last updated: Aug 18 '19