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 <[email protected]> wrote: > On Sun, 21 Feb 2021 00:40:56 +0000 > Brian Barker <[email protected]> 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: [email protected] > 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: [email protected] 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
