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

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 had a problem.

Philip

On 27/06/17 12:55, Uwe Brauer wrote:
> 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 version of my colleagues
> interpret 3.4 as a number, since in Spanish the convention is either 3,4
> or 3'4?. I hoped that could be internally solved without any
> specification but it seems not to be the case.
>
> Any suggestion would be welcome. Thanks
>
> Uwe Brauer 


-- 
Philip Jackson
Domain le Theron
34210 Siran
France                                  Tel : +33.780508769

Open pgp public key : fingerprint = 92B9 5310 37BE C6FE 2B2C  B922 26BD
500A 2354 3A63

author of "The Circle of Fifths" for improvising musicians
Get it here  https://www.books2read.com/u/bWnRM4

auteur : "Le Cycle des Quintes" pour musiciens improvisateurs
disponibilité : https://www.books2read.com/u/bw8rv9

-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted