How to change the Default Number Format for a Calc Spreadsheet?
Clash Royale CLAN TAG#URR8PPP up vote
0
down vote
favorite
I have Calc spreadsheets which are by default in the French number format. I have no idea how this came about except that I live in France and the second language on my laptop is French. In system settings/Language Support, Language and Regional Formats I have English UK. On changing the number format for all cells in the Calc Spreadsheet I can work in English but each time I save and close the file it reverts to French. I have also tried to save the re-formatted number format file as another name but the same thing happens, it reverts to the Default French when I close and reopen it.
I built this spreadsheet years ago and it is quite complex so I would prefer being able to revert it to its' original English number format.
Does anyone have any ideas?
libreoffice language
asked Mar 9 at 17:45
Garoolgan
256
add a comment |Â
up vote
0
down vote
favorite
I have Calc spreadsheets which are by default in the French number format. I have no idea how this came about except that I live in France and the second language on my laptop is French. In system settings/Language Support, Language and Regional Formats I have English UK. On changing the number format for all cells in the Calc Spreadsheet I can work in English but each time I save and close the file it reverts to French. I have also tried to save the re-formatted number format file as another name but the same thing happens, it reverts to the Default French when I close and reopen it.
I built this spreadsheet years ago and it is quite complex so I would prefer being able to revert it to its' original English number format.
Does anyone have any ideas?
libreoffice language
asked Mar 9 at 17:45
Garoolgan
256
Can you please open a terminal window, run thelocalecommand, and show us the output by editing your question.
– Gunnar Hjalmarsson
Mar 9 at 23:59
I've found the solution!! I was saving the file in the original .xlsx format as I imported it from my OSX days. Now that for the first time I've saved it as an .ods file the again corrected number format, has stuck.
– Garoolgan
Mar 10 at 10:18
bob@bob-ThinkPad-W530:~$ locale LANG=en_GB.UTF-8 LANGUAGE=en_GB:en_US:en LC_CTYPE="en_GB.UTF-8" LC_NUMERIC=en_GB.UTF-8 LC_TIME=en_GB.UTF-8 LC_COLLATE="en_GB.UTF-8" LC_MONETARY=en_GB.UTF-8 LC_MESSAGES="en_GB.UTF-8" LC_PAPER=en_GB.UTF-8 LC_NAME=en_GB.UTF-8 LC_ADDRESS=en_GB.UTF-8 LC_TELEPHONE=en_GB.UTF-8 LC_MEASUREMENT=en_GB.UTF-8 LC_IDENTIFICATION=en_GB.UTF-8 LC_ALL= bob@bob-ThinkPad-W530:~$ ^C
– Garoolgan
Mar 10 at 10:19
1
Ok, good. Can you please submit that as an answer (it's perfectly fine to answer your own question). Then, in a couple of days, you'll be able to accept the answer to mark the problem as resolved.
– Gunnar Hjalmarsson
Mar 10 at 10:29
add a comment |Â
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have Calc spreadsheets which are by default in the French number format. I have no idea how this came about except that I live in France and the second language on my laptop is French. In system settings/Language Support, Language and Regional Formats I have English UK. On changing the number format for all cells in the Calc Spreadsheet I can work in English but each time I save and close the file it reverts to French. I have also tried to save the re-formatted number format file as another name but the same thing happens, it reverts to the Default French when I close and reopen it.
I built this spreadsheet years ago and it is quite complex so I would prefer being able to revert it to its' original English number format.
Does anyone have any ideas?
libreoffice language
asked Mar 9 at 17:45
Garoolgan
256
I have Calc spreadsheets which are by default in the French number format. I have no idea how this came about except that I live in France and the second language on my laptop is French. In system settings/Language Support, Language and Regional Formats I have English UK. On changing the number format for all cells in the Calc Spreadsheet I can work in English but each time I save and close the file it reverts to French. I have also tried to save the re-formatted number format file as another name but the same thing happens, it reverts to the Default French when I close and reopen it.
I built this spreadsheet years ago and it is quite complex so I would prefer being able to revert it to its' original English number format.
Does anyone have any ideas?
libreoffice language
libreoffice language
asked Mar 9 at 17:45
Garoolgan
256
asked Mar 9 at 17:45
Garoolgan
256
asked Mar 9 at 17:45
Garoolgan
256
asked Mar 9 at 17:45
Garoolgan
256
asked Mar 9 at 17:45
Garoolgan
256
256
Can you please open a terminal window, run thelocalecommand, and show us the output by editing your question.
– Gunnar Hjalmarsson
Mar 9 at 23:59
I've found the solution!! I was saving the file in the original .xlsx format as I imported it from my OSX days. Now that for the first time I've saved it as an .ods file the again corrected number format, has stuck.
– Garoolgan
Mar 10 at 10:18
bob@bob-ThinkPad-W530:~$ locale LANG=en_GB.UTF-8 LANGUAGE=en_GB:en_US:en LC_CTYPE="en_GB.UTF-8" LC_NUMERIC=en_GB.UTF-8 LC_TIME=en_GB.UTF-8 LC_COLLATE="en_GB.UTF-8" LC_MONETARY=en_GB.UTF-8 LC_MESSAGES="en_GB.UTF-8" LC_PAPER=en_GB.UTF-8 LC_NAME=en_GB.UTF-8 LC_ADDRESS=en_GB.UTF-8 LC_TELEPHONE=en_GB.UTF-8 LC_MEASUREMENT=en_GB.UTF-8 LC_IDENTIFICATION=en_GB.UTF-8 LC_ALL= bob@bob-ThinkPad-W530:~$ ^C
– Garoolgan
Mar 10 at 10:19
1
Ok, good. Can you please submit that as an answer (it's perfectly fine to answer your own question). Then, in a couple of days, you'll be able to accept the answer to mark the problem as resolved.
– Gunnar Hjalmarsson
Mar 10 at 10:29
add a comment |Â
Can you please open a terminal window, run thelocalecommand, and show us the output by editing your question.
– Gunnar Hjalmarsson
Mar 9 at 23:59
I've found the solution!! I was saving the file in the original .xlsx format as I imported it from my OSX days. Now that for the first time I've saved it as an .ods file the again corrected number format, has stuck.
– Garoolgan
Mar 10 at 10:18
bob@bob-ThinkPad-W530:~$ locale LANG=en_GB.UTF-8 LANGUAGE=en_GB:en_US:en LC_CTYPE="en_GB.UTF-8" LC_NUMERIC=en_GB.UTF-8 LC_TIME=en_GB.UTF-8 LC_COLLATE="en_GB.UTF-8" LC_MONETARY=en_GB.UTF-8 LC_MESSAGES="en_GB.UTF-8" LC_PAPER=en_GB.UTF-8 LC_NAME=en_GB.UTF-8 LC_ADDRESS=en_GB.UTF-8 LC_TELEPHONE=en_GB.UTF-8 LC_MEASUREMENT=en_GB.UTF-8 LC_IDENTIFICATION=en_GB.UTF-8 LC_ALL= bob@bob-ThinkPad-W530:~$ ^C
– Garoolgan
Mar 10 at 10:19
1
Ok, good. Can you please submit that as an answer (it's perfectly fine to answer your own question). Then, in a couple of days, you'll be able to accept the answer to mark the problem as resolved.
– Gunnar Hjalmarsson
Mar 10 at 10:29
Can you please open a terminal window, run the
locale command, and show us the output by editing your question.– Gunnar Hjalmarsson
Mar 9 at 23:59
Can you please open a terminal window, run the
locale command, and show us the output by editing your question.– Gunnar Hjalmarsson
Mar 9 at 23:59
I've found the solution!! I was saving the file in the original .xlsx format as I imported it from my OSX days. Now that for the first time I've saved it as an .ods file the again corrected number format, has stuck.
– Garoolgan
Mar 10 at 10:18
I've found the solution!! I was saving the file in the original .xlsx format as I imported it from my OSX days. Now that for the first time I've saved it as an .ods file the again corrected number format, has stuck.
– Garoolgan
Mar 10 at 10:18
bob@bob-ThinkPad-W530:~$ locale LANG=en_GB.UTF-8 LANGUAGE=en_GB:en_US:en LC_CTYPE="en_GB.UTF-8" LC_NUMERIC=en_GB.UTF-8 LC_TIME=en_GB.UTF-8 LC_COLLATE="en_GB.UTF-8" LC_MONETARY=en_GB.UTF-8 LC_MESSAGES="en_GB.UTF-8" LC_PAPER=en_GB.UTF-8 LC_NAME=en_GB.UTF-8 LC_ADDRESS=en_GB.UTF-8 LC_TELEPHONE=en_GB.UTF-8 LC_MEASUREMENT=en_GB.UTF-8 LC_IDENTIFICATION=en_GB.UTF-8 LC_ALL= bob@bob-ThinkPad-W530:~$ ^C
– Garoolgan
Mar 10 at 10:19
bob@bob-ThinkPad-W530:~$ locale LANG=en_GB.UTF-8 LANGUAGE=en_GB:en_US:en LC_CTYPE="en_GB.UTF-8" LC_NUMERIC=en_GB.UTF-8 LC_TIME=en_GB.UTF-8 LC_COLLATE="en_GB.UTF-8" LC_MONETARY=en_GB.UTF-8 LC_MESSAGES="en_GB.UTF-8" LC_PAPER=en_GB.UTF-8 LC_NAME=en_GB.UTF-8 LC_ADDRESS=en_GB.UTF-8 LC_TELEPHONE=en_GB.UTF-8 LC_MEASUREMENT=en_GB.UTF-8 LC_IDENTIFICATION=en_GB.UTF-8 LC_ALL= bob@bob-ThinkPad-W530:~$ ^C
– Garoolgan
Mar 10 at 10:19
1
1
Ok, good. Can you please submit that as an answer (it's perfectly fine to answer your own question). Then, in a couple of days, you'll be able to accept the answer to mark the problem as resolved.
– Gunnar Hjalmarsson
Mar 10 at 10:29
Ok, good. Can you please submit that as an answer (it's perfectly fine to answer your own question). Then, in a couple of days, you'll be able to accept the answer to mark the problem as resolved.
– Gunnar Hjalmarsson
Mar 10 at 10:29
add a comment |Â
1 Answer
1
active
oldest
votes
up vote
0
down vote
I've found the solution!! I was saving the file in the original .xlsx format as I imported it from my OSX days. Now that for the first time I've saved it as an .ods file the again corrected number format, has stuck.
answered Mar 11 at 9:12
Garoolgan
256
add a comment |Â
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
I've found the solution!! I was saving the file in the original .xlsx format as I imported it from my OSX days. Now that for the first time I've saved it as an .ods file the again corrected number format, has stuck.
answered Mar 11 at 9:12
Garoolgan
256
add a comment |Â
up vote
0
down vote
I've found the solution!! I was saving the file in the original .xlsx format as I imported it from my OSX days. Now that for the first time I've saved it as an .ods file the again corrected number format, has stuck.
answered Mar 11 at 9:12
Garoolgan
256
add a comment |Â
up vote
0
down vote
up vote
0
down vote
I've found the solution!! I was saving the file in the original .xlsx format as I imported it from my OSX days. Now that for the first time I've saved it as an .ods file the again corrected number format, has stuck.
answered Mar 11 at 9:12
Garoolgan
256
I've found the solution!! I was saving the file in the original .xlsx format as I imported it from my OSX days. Now that for the first time I've saved it as an .ods file the again corrected number format, has stuck.
answered Mar 11 at 9:12
Garoolgan
256
answered Mar 11 at 9:12
Garoolgan
256
answered Mar 11 at 9:12
Garoolgan
256
answered Mar 11 at 9:12
Garoolgan
256
256
add a comment |Â
add a comment |Â
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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%2faskubuntu.com%2fquestions%2f1013460%2fhow-to-change-the-default-number-format-for-a-calc-spreadsheet%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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');
var $window = $(window),
onScroll = function(e)
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom))
StackExchange.using('gps', function() StackExchange.gps.track('embedded_signup_form.view', location: 'question_page' ); );
$window.unbind('scroll', onScroll);
;
$window.on('scroll', onScroll);
);
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
Can you please open a terminal window, run the
localecommand, and show us the output by editing your question.– Gunnar Hjalmarsson
Mar 9 at 23:59
I've found the solution!! I was saving the file in the original .xlsx format as I imported it from my OSX days. Now that for the first time I've saved it as an .ods file the again corrected number format, has stuck.
– Garoolgan
Mar 10 at 10:18
bob@bob-ThinkPad-W530:~$ locale LANG=en_GB.UTF-8 LANGUAGE=en_GB:en_US:en LC_CTYPE="en_GB.UTF-8" LC_NUMERIC=en_GB.UTF-8 LC_TIME=en_GB.UTF-8 LC_COLLATE="en_GB.UTF-8" LC_MONETARY=en_GB.UTF-8 LC_MESSAGES="en_GB.UTF-8" LC_PAPER=en_GB.UTF-8 LC_NAME=en_GB.UTF-8 LC_ADDRESS=en_GB.UTF-8 LC_TELEPHONE=en_GB.UTF-8 LC_MEASUREMENT=en_GB.UTF-8 LC_IDENTIFICATION=en_GB.UTF-8 LC_ALL= bob@bob-ThinkPad-W530:~$ ^C
– Garoolgan
Mar 10 at 10:19
1
Ok, good. Can you please submit that as an answer (it's perfectly fine to answer your own question). Then, in a couple of days, you'll be able to accept the answer to mark the problem as resolved.
– Gunnar Hjalmarsson
Mar 10 at 10:29