Re: [libreoffice-users] Language setting in Calc

2021-02-20 Thread Brian Barker

At 15:09 20/02/2021 -0800, Nobody Noname wrote:

On Sat, Feb 20, 2021 at 8:27 AM Thomas Blasejewicz wrote:
The (Excel) file is the draft for the preparation of a 
questionnaire - to be translated into several languages (although 
the one I am currently working on has only 3 languages). Means: I 
want certain columns ONLY to be set to German, while others next to 
it are set to English and Japanese. Applying the language to the 
entire document does not do this trick.


I did a little test and was able to reproduce your problem with the 
Column > Format Cells > Font > Polish (which is just the test 
language I used). I could reproduce the problem when working with 
the document as an .xlsx or .xls file, but the problem does NOT 
exist when I used a .ods file. So the issue seems to be specific to 
LibreOffice operating with Excel files. You might want to report it 
as a bug: https://wiki.documentfoundation.org/QA/BugReport


Sorry, but you are assuming that this is a problem with LibreOffice's 
ability to save in a Microsoft Excel format, and that the fault is 
therefore LibreOffice's. But do we know that it is possible to save a 
spreadsheet document in Excel format with different columns marked as 
being in different languages? That's the same question, effectively, 
as "Can you set different languages for different parts of a 
spreadsheet in Microsoft Excel itself?" I don't know that you can. If 
not, the deficiency is with Microsoft's formats, and the bug report 
should probably go to them instead.


Brian Barker  



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy



Re: [libreoffice-users] Language setting in Calc

2021-02-20 Thread cspi...@ieee.org
I did a little test and was able to reproduce your problem with the Column
> Format Cells > Font > Polish (which is just the test language I used).  I
could reproduce the problem when working with the document as an .xlsx or
.xls file, but the problem does NOT exist when I used a .ods file.  So the
issue seems to be specific to LibreOffice operating with Excel files.  You
might want to report it as a bug:
https://wiki.documentfoundation.org/QA/BugReport


On Sat, Feb 20, 2021 at 8:27 AM Thomas Blasejewicz wrote:

> On 2021/02/20 6:14, Paul D. Mirowsky wrote:
> > This may be an answer.
> >
> > Choose Tools - Options. Go to Language Settings - Languages. Under
> > Default languages for documents, select the document language for all
> > newly created documents. If you mark For the current document only,
> > your choice will only apply to the current document.
> >
> > https://help.libreoffice.org/4.4/Common/Selecting_the_Document_Language
>
> Thank you, but I am afraid, that is not the answer.
> The (Excel) file is the draft for the preparation of a questionnaire -
> to be translated into several languages (although the one I am currently
> working on has only 3 languages).
> Means: I want certain columns ONLY to be set to German, while others
> next to it are set to English and Japanese.
> Applying the language to the entire document does not do this trick.
>
> Thomas
>
> --
> To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
>
>

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy


Re: [libreoffice-users] Language setting in Calc

2021-02-20 Thread Thomas Blasejewicz

On 2021/02/20 6:14, Paul D. Mirowsky wrote:

This may be an answer.

Choose Tools - Options. Go to Language Settings - Languages. Under  
Default languages for documents, select the document language for all  
newly created documents. If you mark For the current document only,  
your choice will only apply to the current document.


https://help.libreoffice.org/4.4/Common/Selecting_the_Document_Language


Thank you, but I am afraid, that is not the answer.
The (Excel) file is the draft for the preparation of a questionnaire -  
to be translated into several languages (although the one I am currently  
working on has only 3 languages).
Means: I want certain columns ONLY to be set to German, while others  
next to it are set to English and Japanese.

Applying the language to the entire document does not do this trick.

Thomas

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy