Re: [libreoffice-users] Language setting in Calc

Hi, I have been using English and Japanese both in msexcel and LO calc for
many years.
I receive an excel file and then make a duplicate. When I want to send a
draft, I save it as an excel file and send it to the editor.
I sometimes have problems when special characters are used.

   I use the the input method frameworks fcitx and ibus. It allows me to
flip between languages in any document.
Libreoffice Version: 6.4.6.2 on Linux mint 20.0
and Language settings > languages>Default language for documents> Western
-Default: English. Asian: Japanese

Hope this helps.




On Sun, 21 Feb 2021 at 18:22, Dave Howorth <dave@howorth.org.uk> wrote:

> On Sun, 21 Feb 2021 00:40:56 +0000
> Brian Barker <b.m.barker@btinternet.com> wrote:
>
> > 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
>
> Apparently it is possible,since the OP originally stated:
>
> "The original file is so formatted that there are font settings for
> English and Japanese.
> When I work at home (right now) I select the relevant columns and
> change the language setting to German."
>
> For that to be the case, the original file must encode the language for
> individual columns.
>
> --
> To unsubscribe e-mail to: users+unsubscribe@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+unsubscribe@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