Re: [libreoffice-users] scalc interchange ods between english and spanish

2017-06-27 Thread Philip Jackson
Hi Uwe, Regardless of the version of calc you are using, you can change the decimal indicator. In the spreadsheet, select the cells concerned and then Format > Cells > Numbers and select Language to Spanish (Spain) and your numbers will go from 3.4 to 3,4 So your colleagues won't know you ever

Re: [libreoffice-users] scalc interchange ods between english and spanish

2017-06-27 Thread Remy Gauthier
Hello, I exchange ODS and XLS files between the French Canadian (decimal separator « , ») and English US/Canada locales (decimal separator « . ») without issues. When the number is already in a cell on a worksheet, the application will use the locale to display a decimal number in the correct

[libreoffice-users] Re: scalc interchange ods between english and spanish

2017-06-27 Thread Uwe Brauer
> Hello, > I exchange ODS and XLS files between the French Canadian (decimal > separator « , ») and English US/Canada locales (decimal separator « . > ») without issues. When the number is already in a cell on a worksheet, > the application will use the locale to display a decimal

[libreoffice-users] Re: scalc interchange ods between english and spanish

2017-06-27 Thread Uwe Brauer
>>> "Philip" == Philip Jackson writes: Hi Philip > Hi Uwe, > Regardless of the version of calc you are using, you can change the > decimal indicator. In the spreadsheet, select the cells concerned and > then Format > Cells > Numbers and select Language

[libreoffice-users] scalc interchange ods between english and spanish

2017-06-27 Thread Uwe Brauer
Hi I am using the english version of LO 5.3 and therefore I use the «.» to indicate decimals: 3.4 However I have to interchange the documents with my colleagues which using the Spanish version (of excel) so I must send xlsx or xls format anyhow. How I can I ensure that the spanish excel