LibreOffice Calc error - the formula separators have been reset to their default values
Clash Royale CLAN TAG#URR8PPP
up vote
0
down vote
favorite
I want to set locale setting for Language in Libre Calc 6 to my current one in Ubuntu 18 (strange it's not that way by default...).
I set it to locale with point for decimal separator (and space for thousands). After I set locale I got message Because the current formula separator settings conflict with the locale, the formula separators have been reset to their default values. and in addition to some formula separators effect which is written in the message, numbers in calculation sheet have comma, not point for decimal separator. Why? What the message means?
By the way, in Libre options for checkbox decimal separator key I see (,), not (.), when in Regional settings for Ubuntu I see ..
Denmark/Danish locale works fine in Libre Calc, it has point for decimal and comma for thousands. And for it in Libre options for checkbox decimal separator key I see (.).
linux ubuntu libreoffice
asked Jul 5 at 12:18
Alexei Martianov
23211
add a comment |Â
up vote
0
down vote
favorite
I want to set locale setting for Language in Libre Calc 6 to my current one in Ubuntu 18 (strange it's not that way by default...).
I set it to locale with point for decimal separator (and space for thousands). After I set locale I got message Because the current formula separator settings conflict with the locale, the formula separators have been reset to their default values. and in addition to some formula separators effect which is written in the message, numbers in calculation sheet have comma, not point for decimal separator. Why? What the message means?
By the way, in Libre options for checkbox decimal separator key I see (,), not (.), when in Regional settings for Ubuntu I see ..
Denmark/Danish locale works fine in Libre Calc, it has point for decimal and comma for thousands. And for it in Libre options for checkbox decimal separator key I see (.).
linux ubuntu libreoffice
asked Jul 5 at 12:18
Alexei Martianov
23211
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I want to set locale setting for Language in Libre Calc 6 to my current one in Ubuntu 18 (strange it's not that way by default...).
I set it to locale with point for decimal separator (and space for thousands). After I set locale I got message Because the current formula separator settings conflict with the locale, the formula separators have been reset to their default values. and in addition to some formula separators effect which is written in the message, numbers in calculation sheet have comma, not point for decimal separator. Why? What the message means?
By the way, in Libre options for checkbox decimal separator key I see (,), not (.), when in Regional settings for Ubuntu I see ..
Denmark/Danish locale works fine in Libre Calc, it has point for decimal and comma for thousands. And for it in Libre options for checkbox decimal separator key I see (.).
linux ubuntu libreoffice
asked Jul 5 at 12:18
Alexei Martianov
23211
I want to set locale setting for Language in Libre Calc 6 to my current one in Ubuntu 18 (strange it's not that way by default...).
I set it to locale with point for decimal separator (and space for thousands). After I set locale I got message Because the current formula separator settings conflict with the locale, the formula separators have been reset to their default values. and in addition to some formula separators effect which is written in the message, numbers in calculation sheet have comma, not point for decimal separator. Why? What the message means?
By the way, in Libre options for checkbox decimal separator key I see (,), not (.), when in Regional settings for Ubuntu I see ..
Denmark/Danish locale works fine in Libre Calc, it has point for decimal and comma for thousands. And for it in Libre options for checkbox decimal separator key I see (.).
linux ubuntu libreoffice
asked Jul 5 at 12:18
Alexei Martianov
23211
edited Jul 6 at 5:10
asked Jul 5 at 12:18
Alexei Martianov
23211
asked Jul 5 at 12:18
Alexei Martianov
23211
asked Jul 5 at 12:18
Alexei Martianov
23211
23211
add a comment |Â
add a comment |Â
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f453610%2flibreoffice-calc-error-the-formula-separators-have-been-reset-to-their-default%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
