Calc freezes/shows strange behavior after changing font

Discuss the spreadsheet application

Calc freezes/shows strange behavior after changing font

Postby alex5720 » Thu Sep 13, 2018 7:45 am

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?
Libre Office 5.1.6.2, Ubuntu 16.04.5
alex5720
 
Posts: 10
Joined: Thu Sep 13, 2018 7:41 am

Re: Calc freezes/shows strange behavior after changing font

Postby Zizi64 » Thu Sep 13, 2018 8:40 am

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.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8152
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calc freezes/shows strange behavior after changing font

Postby alex5720 » Thu Sep 13, 2018 8:43 am

Sorry about that - done.

Does it mean I have to search another forum...?
Libre Office 5.1.6.2, Ubuntu 16.04.5
alex5720
 
Posts: 10
Joined: Thu Sep 13, 2018 7:41 am

Re: Calc freezes/shows strange behavior after changing font

Postby Zizi64 » Thu Sep 13, 2018 9:08 am

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.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8152
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calc freezes/shows strange behavior after changing font

Postby RoryOF » Thu Sep 13, 2018 9:16 am

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.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29295
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Calc freezes/shows strange behavior after changing font

Postby alex5720 » Thu Sep 13, 2018 9:19 am

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...
Libre Office 5.1.6.2, Ubuntu 16.04.5
alex5720
 
Posts: 10
Joined: Thu Sep 13, 2018 7:41 am

Re: Calc freezes/shows strange behavior after changing font

Postby Zizi64 » Thu Sep 13, 2018 9:28 am

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.
Last edited by Zizi64 on Thu Sep 13, 2018 9:34 am, edited 1 time in total.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8152
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calc freezes/shows strange behavior after changing font

Postby alex5720 » Thu Sep 13, 2018 9:34 am

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   Expand viewCollapse view
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
alex5720
 
Posts: 10
Joined: Thu Sep 13, 2018 7:41 am

Re: Calc freezes/shows strange behavior after changing font

Postby Zizi64 » Thu Sep 13, 2018 9:38 am

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.
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8152
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calc freezes/shows strange behavior after changing font

Postby alex5720 » Thu Sep 13, 2018 9:57 am

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

However, the problem is still there...
Libre Office 5.1.6.2, Ubuntu 16.04.5
alex5720
 
Posts: 10
Joined: Thu Sep 13, 2018 7:41 am

Re: Calc freezes/shows strange behavior after changing font

Postby RoryOF » Thu Sep 13, 2018 10:15 am

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)
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29295
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Calc freezes/shows strange behavior after changing font

Postby Zizi64 » Thu Sep 13, 2018 12:05 pm

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   Expand viewCollapse view
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?
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8152
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calc freezes/shows strange behavior after changing font

Postby jrkrideau » Thu Sep 13, 2018 1:51 pm

Zizi64 wrote:
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.
OpenOffice 4.1.6; Ubuntu 18.04
jrkrideau
Volunteer
 
Posts: 3690
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: Calc freezes/shows strange behavior after changing font

Postby RoryOF » Thu Sep 13, 2018 1:56 pm

I think FreeSans is a standard Ubuntu installed font - I certainly have it on my Xubuntu machines.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29295
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Calc freezes/shows strange behavior after changing font

Postby alex5720 » Thu Sep 13, 2018 3:16 pm

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 17 times
Libre Office 5.1.6.2, Ubuntu 16.04.5
alex5720
 
Posts: 10
Joined: Thu Sep 13, 2018 7:41 am

Re: Calc freezes/shows strange behavior after changing font

Postby RoryOF » Thu Sep 13, 2018 3:20 pm

Worked OK for me.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29295
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Calc freezes/shows strange behavior after changing font

Postby Zizi64 » Thu Sep 13, 2018 4:08 pm

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)
Tibor Kovacs, Hungary; LO6.1.6 on Win7-10 x64Prof.
PortableApps, winPenPack: LO3.3.0-6.2.5; AOO4.1.6
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.
User avatar
Zizi64
Volunteer
 
Posts: 8152
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calc freezes/shows strange behavior after changing font

Postby alex5720 » Thu Sep 13, 2018 4:39 pm

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
alex5720
 
Posts: 10
Joined: Thu Sep 13, 2018 7:41 am

Re: Calc freezes/shows strange behavior after changing font

Postby alex5720 » Fri Sep 14, 2018 8:03 am

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)...
Libre Office 5.1.6.2, Ubuntu 16.04.5
alex5720
 
Posts: 10
Joined: Thu Sep 13, 2018 7:41 am

Re: Calc freezes/shows strange behavior after changing font

Postby MrProgrammer » Fri Sep 14, 2018 5:44 pm

Hi, and welcome to the forum.

alex5720 wrote:I created the document on a Mac
alex5720 wrote:My best guess is that it is a Mac issue!
How would anyone here know you created the document on a Mac? This is the first that you've mentioned it and your signature doesn't show that as one of your environments. I note that your signature was also incorrect about LibreOffice/OpenOffice. Some issues affect only specific environments and you may not receive the correct assistance if your signature is wrong. What software did you use to create the document on the Mac? It would be wrong for us to assume it is the same LibreOffice 5.1.6.2 that you run on Linux. What's your Mac OS level? If you read the tutorial below, some issues affect only certain Mac OS levels.
Screen Shot 2018-09-14 at 10.17.58 .png
Screen Shot 2018-09-14 at 10.17.58 .png (12.25 KiB) Viewed 521 times

alex5720 wrote:I change the font to "FreeSans"
If you suspect a Mac issue, perhaps there is an idea in [Tutorial] Mac FAQ Q32/A32 which can help. I can't reproduce your problem since I do not have the FreeSans font installed and do not run LibreOffice.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know
Mr. Programmer
AOO 4.1.5 Build 9789 on MacOS 10.11.6.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
MrProgrammer
Moderator
 
Posts: 3785
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: Calc freezes/shows strange behavior after changing font

Postby alex5720 » Sat Sep 15, 2018 9:57 am

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.
Libre Office 5.1.6.2, Ubuntu 16.04.5
alex5720
 
Posts: 10
Joined: Thu Sep 13, 2018 7:41 am

Re: Calc freezes/shows strange behavior after changing font

Postby RoryOF » Sat Sep 15, 2018 10:08 am

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.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29295
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Calc freezes/shows strange behavior after changing font

Postby alex5720 » Sat Sep 15, 2018 10:21 am

Thanks, I will try to disable OpenGL.
Libre Office 5.1.6.2, Ubuntu 16.04.5
alex5720
 
Posts: 10
Joined: Thu Sep 13, 2018 7:41 am


Return to Calc

Who is online

Users browsing this forum: No registered users and 18 guests