date display in Calc Linux/Windows

users
#1

Good evening
I am using LibreOffice both on Windows and Linux (not that frequently)
machines.
Recent I noticed, that when I open a Calc file using dates (Japanese
format) on a Linux machine,
save that file via cloud services (here TeamDrive) and then open the
file on a Windows machine,
the dates are still there (as dates), but the font is all garbled up.
I tried all sort of settings, like specifying "date", tried several
different fonts etc.,
but so far nothing has helped.
I assume, there is a trick to do that?

Fonts: as far as I can see, there are no fonts with the same name in
Linux/Windows.
Does that then mean, I cannot work on the same file using both Linux and
Windows?

* I have not really started checking, but it seems, Japanese names
(characters) DO NOT get garbled up.

Thank you in advance
Thomas

#2

Thomas Blasejewicz-3 wrote

I assume, there is a trick to do that?

Fonts: as far as I can see, there are no fonts with the same name in
Linux/Windows.
Does that then mean, I cannot work on the same file using both Linux and
Windows?

Open the file in the Windows machine, go to File > Properties, switch to the
Font tab and check the "Embed fonts in the document" box.
In theory the fonts are cross platform and should work on both OSes...
Please be warned that the file will increase substantially in size.
LibreOffice currently has a bug that causes some unneeded fonts to be
embedded
https://bugs.documentfoundation.org/show_bug.cgi?id=65353

Hope this helps.

#3

Good evening
I am afraid, I still have problems with this trick.
I have a "schedule" file on a Windows 10 machine.
On the left edge are dates. I specified the format for that column "number -> date -> (Japanese) date format".
However on opening the file today, everything was garbled up.
Resetting the format to date -> closing the file -> reopening it => again everything is messed up.
I tried this several time with different formats, removing the "language" argument from that column etc. ...
so far the ONLY thing that seems to help is setting the date to alphanumeric style.
That is basically OK, but I am wondering why all of a sudden I am not permitted to use something that has been working for years ...
Thomas

#4

What format is used to save the file: ods, xlsx, xls? Sometimes the
filters used to save in formats other than ods fail to retain all
formatting.

#5

Good evening
Nativ ODS format, since I use this file ONLY with LibreOffice.