Calc freezes/shows strange behavior after changing font

[alex5720]

I have a strange behavior that I can reproduce myself like this:

1. I open an existing calc document
2. On a new sheet I type something in a cell
3. I change the font to "FreeSans"

After that I see the following behavior:

1. I am not able to enter something in the sheet
2. I can change the sheets, but they are mixed up (i.e. the first sheet now shows the content of the second sheet)

I cannot work AT ALL. What can I do to fix this problem?

[Zizi64]

Open Office 5.1.6.2, Ubuntu 16.04.5

The 5.1.6 version is not Apache OpenOffice, but it is LibreOffice.
Please update your signature.

[alex5720]

Sorry about that - done.

Does it mean I have to search another forum...?

[Zizi64]

Does it mean I have to search another forum...?

Not, it is a common forum for AOO and LO, but (and "therefore") the exact information is very important.

The FreeSans font works fine for me in my LO 4.4.7, LO 5.4.7 and LO 6.1.0 versions on Windows 7.

[RoryOF]

When you "change the font", was the font already installed on computer, or did you install then select in Calc. OpenOffice (and presumably LibreOffice) only detects fonts on startup.

[alex5720]

Its one of the fonts I was able to select. As far as I know I never installed any fonts.

The 'funny' thing is that when I type something in a new cell the font type is 'Arial', but that is not even in the list of fonts (to me that makes absolutely no sense...)

Also, the same effect/behavior seems to happen for ANY font I choose (tried with two other fonts, same behavior)...

It looks like an issue with updating the screen/window. Because when I click on the 'X' to close the window, an empty popup appears (where I can choose to save, do not save). But its empty. Even if I wait. If I change the workplace on the computer, however, the content of that popup reappears...

[Zizi64]

As far as I know I never installed any fonts.

Somebody had installed them... If I know it exactly, the FreeSans in not part of the LO installer.

The 'funny' thing is that when I type something in a new cell the font type is 'Arial', but that is not even in the list of fonts (to me that makes absolutely no sense...)

Maybi it is a "Missing Font" problem.
The arial is an MS related commercial font. The LO/AOO softwares display the name of the assigned font, even if it not installed on your computer. Use the TestFont extension for testing the existing fonts. It works in the Writer application only.

[alex5720]

This sounds like a bug in LibreOffice: Why display a font if the font is not there. Does not make sense for me...

Anyway, here is the result:

Code: Select all

File: 

Missing fonts - found:  0 times

Direct formatting fonts - found:  0 times

Fonts assigned to used paragraph styles - found:  1 times
   Default Style              Liberation Serif          Regular 

Fonts assigned to used character styles - found:  0 times

[Zizi64]

This sounds like a bug in LibreOffice: Why display a font if the font is not there.

It will not display in a newly created document. But it always will be displayed the name of the assigned font in an existing document, what was created on a computer where the font exists AND the author has assigned it to some text.

[alex5720]

Anyway, it looks like I have no missing font. Everything seems to be in order.

However, the problem is still there...

[RoryOF]

Your .sig line says you are using Ubuntu. If you install ttf-mscorefonts-installer from the Ubuntu repositories, you will get the standard MS Windows fonts.

If it is a distro-related display card driver problem, using Settings / Additional Drivers will display alternate drivers you might use for your display card. if inxi is installed, using inxi -G in a terminal will show your current display card type and drivers.

Note that LibreOffice does not like OpenGL fonts (it prefers ttf)

[Zizi64]

Anyway, it looks like I have no missing font.

It possibly is not correct. Maybe there is not missing font problem in a newly created Writer document:

Code: Select all

File:

Missing fonts - found:  0 times

Direct formatting fonts - found:  0 times

Fonts assigned to used paragraph styles - found:  1 times
   Default Style              Liberation Serif          Regular

Fonts assigned to used character styles - found:  0 times

But maybe there is missing font in your older, existing Calc document. Do you have Arial font? If the answer is 'not', and the Calc document tried to use it, then it is a "missing font related problem"

Can you upload the problematic document here?

[jrkrideau]

As far as I know I never installed any fonts.

Somebody had installed them... If I know it exactly, the FreeSans in not part of the LO installer.

I do not remember installing any fonts on this new computer and I have FreeSans. Perhaps FreeSans is a Linux/Ubuntu font.

[RoryOF]

I think FreeSans is a standard Ubuntu installed font - I certainly have it on my Xubuntu machines.

[alex5720]

I have attached an example document. I just change the font of the word 'Example' in the 'BadSheet' to something else, and then the described effects happen (at least for me).

[RoryOF]

Worked OK for me.

[Zizi64]

Works fine in my LO 4.4.7 permanently installed, and the portable versions on Win 7

Try to uncheck the Tools - Options - View - Font Lists - Show preview of fonts option. The software will be slower, when this option is switched ON. (Tested with the LO 6.1.0 WinPenPack portable version)

[alex5720]

Thanks for your replies so far. I will reboot the computer (tomorrow) and see if the issue persists...

[alex5720]

Even after a reboot of the computer the problem is still there.

My best guess is that it is a Mac issue! I created the document on a mac, and wanted to use it on Linux as well. And as Mac is instrinsicly bad, maybe that is the problem (which only manifests on Linux then or something)...

[alex5720]

My signature is correct. I created that document on a Mac with openoffice, but the problem arised on Ubuntu with LibreOffice. My signature is correct...

Maybe its an OpenOffice/LibreOffice issue.

[RoryOF]

I have no problem with OO 4.1.5 on Xubuntu 18.04.1 on several computers. If you are using LibreOffice, disable OpenGL (I don't use LibreOffice, but see that there are some problems with it and OpenGL)

[alex5720]

Thanks, I will try to disable OpenGL.