Calc freezes/shows strange behavior after changing font
Calc freezes/shows strange behavior after changing font
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?
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?
Libre Office 5.1.6.2, Ubuntu 16.04.5
Re: Calc freezes/shows strange behavior after changing font
The 5.1.6 version is not Apache OpenOffice, but it is LibreOffice.Open Office 5.1.6.2, Ubuntu 16.04.5
Please update your signature.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Calc freezes/shows strange behavior after changing font
Sorry about that - done.
Does it mean I have to search another forum...?
Does it mean I have to search another forum...?
Libre Office 5.1.6.2, Ubuntu 16.04.5
Re: Calc freezes/shows strange behavior after changing font
Not, it is a common forum for AOO and LO, but (and "therefore") the exact information is very important.Does it mean I have to search another forum...?
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.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Calc freezes/shows strange behavior after changing font
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.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Calc freezes/shows strange behavior after changing font
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...
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...
Libre Office 5.1.6.2, Ubuntu 16.04.5
Re: Calc freezes/shows strange behavior after changing font
Somebody had installed them... If I know it exactly, the FreeSans in not part of the LO installer.As far as I know I never installed any fonts.
Maybi it is a "Missing Font" problem.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...)
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.
Last edited by Zizi64 on Thu Sep 13, 2018 9:34 am, edited 1 time in total.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Calc freezes/shows strange behavior after changing font
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:
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
Libre Office 5.1.6.2, Ubuntu 16.04.5
Re: Calc freezes/shows strange behavior after changing font
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.This sounds like a bug in LibreOffice: Why display a font if the font is not there.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Calc freezes/shows strange behavior after changing font
Anyway, it looks like I have no missing font. Everything seems to be in order.
However, the problem is still there...
However, the problem is still there...
Libre Office 5.1.6.2, Ubuntu 16.04.5
Re: Calc freezes/shows strange behavior after changing font
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)
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)
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Calc freezes/shows strange behavior after changing font
It possibly is not correct. Maybe there is not missing font problem in a newly created Writer document:Anyway, it looks like I have no missing font.
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"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
Can you upload the problematic document here?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Calc freezes/shows strange behavior after changing font
I do not remember installing any fonts on this new computer and I have FreeSans. Perhaps FreeSans is a Linux/Ubuntu font.Zizi64 wrote:Somebody had installed them... If I know it exactly, the FreeSans in not part of the LO installer.As far as I know I never installed any fonts.
LibreOffice 7.3.7. 2; Ubuntu 22.04
Re: Calc freezes/shows strange behavior after changing font
I think FreeSans is a standard Ubuntu installed font - I certainly have it on my Xubuntu machines.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Calc freezes/shows strange behavior after changing font
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).
- Attachments
-
- TestSpreadsheet.ods
- (9.58 KiB) Downloaded 125 times
Libre Office 5.1.6.2, Ubuntu 16.04.5
Re: Calc freezes/shows strange behavior after changing font
Worked OK for me.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Calc freezes/shows strange behavior after changing font
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)
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)
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Calc freezes/shows strange behavior after changing font
Thanks for your replies so far. I will reboot the computer (tomorrow) and see if the issue persists...
Libre Office 5.1.6.2, Ubuntu 16.04.5
Re: Calc freezes/shows strange behavior after changing font
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)...
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)...
Libre Office 5.1.6.2, Ubuntu 16.04.5
Re: Calc freezes/shows strange behavior after changing font
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.
Maybe its an OpenOffice/LibreOffice issue.
Libre Office 5.1.6.2, Ubuntu 16.04.5
Re: Calc freezes/shows strange behavior after changing font
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)
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Calc freezes/shows strange behavior after changing font
Thanks, I will try to disable OpenGL.
Libre Office 5.1.6.2, Ubuntu 16.04.5