Calc crashes when copying entire column

Discuss the spreadsheet application

Calc crashes when copying entire column

Postby SteveBros » Sun Feb 02, 2020 11:50 pm

This started happening suddenly and is persisting: When I select an entire column, as soon as I select Copy (or use cmd-c) Openoffice crashes. I'm on OpenOffice 4.1.7 on MacOS Mojave 10.14.6. Rebooting does not help. Any advice? Thanks!
Apache OpenOffice 4.1.7 (Build 9800)
macOS Mojave 10.14.6, Retina 5K, Radeon Pro 580
SteveBros
 
Posts: 17
Joined: Sun Apr 19, 2015 1:31 am

Re: Calc crashes when copying entire column

Postby RusselB » Mon Feb 03, 2020 12:43 am

You could try resetting your OpenOffice User Profile as described here
We have found that resetting the User Profile resolves many issues that suddenly come up when the same command(s) were working properly previously.
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6117
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Calc crashes when copying entire column

Postby Zizi64 » Mon Feb 03, 2020 7:33 am

Try to install the LibreOffice. If it crashes too, then the problem may related to a hardware device (memory) or to the operating system.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
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: 9548
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calc crashes when copying entire column

Postby SteveBros » Mon Feb 03, 2020 9:04 am

Thanks to RusselB & Zizi64 for the quick assistance! I've already tried resetting the User Profile but to no avail. I've also tried deleting the OpenOffice folders, uninstalling, and reinstalling OpenOffice. However, I installed LibreOffice and it does not crash when I copy an entire column. I guess I'll switch to LibreOffice if I can't find a solution... on second thought perhaps not. LibreOffice seems to have a serious font problem. The characters are fuzzy and thick.
Apache OpenOffice 4.1.7 (Build 9800)
macOS Mojave 10.14.6, Retina 5K, Radeon Pro 580
SteveBros
 
Posts: 17
Joined: Sun Apr 19, 2015 1:31 am

Re: Calc crashes when copying entire column

Postby Zizi64 » Mon Feb 03, 2020 10:41 am

LibreOffice seems to have a serious font problem. The characters are fuzzy and thick.


It seems as a videocard problem. Check the OpenGL settings of the LO, and switch off the OpenGL function, if your videocard is not fully compatible with the latest version of the OpenGL standard.

Second tip:
Set the Zoom factor to the ideal value.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
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: 9548
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calc crashes when copying entire column

Postby SteveBros » Mon Feb 03, 2020 10:52 am

Turning OpenGL on or off makes no difference in the fonts. Zoom has no effect either. So far LibreOffice is not usable for me. Any further help on either problem would be appreciated. Thanks for the help again!
Apache OpenOffice 4.1.7 (Build 9800)
macOS Mojave 10.14.6, Retina 5K, Radeon Pro 580
SteveBros
 
Posts: 17
Joined: Sun Apr 19, 2015 1:31 am

Re: Calc crashes when copying entire column

Postby Zizi64 » Mon Feb 03, 2020 11:17 am

There is not any problem with the fonts in my LO 6.1.6 on Win7x64Prof and on Win10x64Prof.

The fuzzy font is a rendering problem, and it related to the videocard or to its driver or to the OpenGL feature.

Can you upload two small but high resolution partial screenshot picture (saved from the AOO and the LO) about the problem?
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
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: 9548
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calc crashes when copying entire column

Postby SteveBros » Mon Feb 03, 2020 11:24 pm

Sorry, my signature was out of date. I'm on a Mac (see configuration below). I tried to attach a screenshot but it is too big for this forum. I put it on Google Drive at this link. You can see that even the font dropdown items are not sharp.
https://drive.google.com/file/d/121uutH ... sp=sharing
Apache OpenOffice 4.1.7 (Build 9800)
macOS Mojave 10.14.6, Retina 5K, Radeon Pro 580
SteveBros
 
Posts: 17
Joined: Sun Apr 19, 2015 1:31 am

Re: Calc crashes when copying entire column

Postby Zizi64 » Tue Feb 04, 2020 7:44 am

You can see that even the font dropdown items are not sharp.


I never use the graphical font preview option in the dropdown. it is enough the names of the fonts for me.
Tools (Preferences on MAC) - Option - Libreoffice - View - Font list - Show preview of fonts.


But, I just tried it in my LO 6-2-8 version. I have not such exotic fonts as you have, but there are other exotic fonts on my Operating system. Here is my sample:

FontPreview.png
With font preview


FontPreview2.png
Without font preview - you can see more font names in the list


The possible roots of the problem:
- The dropdown (and the font size in the dropdown) too small relative to the display resolution.
- Display driver bug
- The videocard (and its driver) is incompatible with the latest OpenGL standard
https://www.khronos.org/opengl/wiki/History_of_OpenGL
My old, integrated videocard has a very low compatible level. See the AIDA64 report:
OpenGL.png
OpenGL compatibility of my integrated videocard
OpenGL.png (6.68 KiB) Viewed 599 times
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
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: 9548
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calc crashes when copying entire column

Postby SteveBros » Tue Feb 04, 2020 9:39 am

Here's my compatibility report below. I also put 2 more screenshots on the google drive to compare OpenOffice the LibreOffice.

https://drive.google.com/drive/folders/ ... sp=sharing
Attachments
Screen Shot 2020-02-03 at 11.20.16 PM.png
Screen Shot 2020-02-03 at 11.20.16 PM.png (55.81 KiB) Viewed 590 times
Apache OpenOffice 4.1.7 (Build 9800)
macOS Mojave 10.14.6, Retina 5K, Radeon Pro 580
SteveBros
 
Posts: 17
Joined: Sun Apr 19, 2015 1:31 am

Re: Calc crashes when copying entire column

Postby Zizi64 » Tue Feb 04, 2020 10:28 am

Always optimize the pictures before you insert/upload them somewhere.

The .png extension is appropriate, because it uses a lossless compression.
You can decrease the color depth to 256 color (it will reduce the 3 bytes/pixel value to 1 byte/pixel)
And you can crop the unrelevant part of the picture.

I am using the free IrfanView image manager software for this tasks. (The IrfanView is not a full featured image editor.)

Here are your huge files directly uploaded (with less than 128 KiB file size):

libreoffice.png


openoffice.png


Screen Shot 2020-02-03 at 1.13.57 PM.png
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
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: 9548
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calc crashes when copying entire column

Postby Zizi64 » Tue Feb 04, 2020 10:40 am

How these settings are set in the AOO and LO on your computer? (the Graphics output options)

Graphics output.jpg
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
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: 9548
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Calc crashes when copying entire column

Postby SteveBros » Wed Feb 05, 2020 11:09 am

I've tried every combination of the Graphics Output option and the result is identical for each. I've seen more than a few posts on the web complaining about the font rendering in LibreOffice, so perhaps the situation is hopeless. Although, I've also seen some similar complaints regarding macOS Mojave in general. It's interesting that OpenOffice renders the fonts very well... just some strange "distortions" of text in Writer that go away when you scroll. Thanks for the tips on uploading image files.
Apache OpenOffice 4.1.7 (Build 9800)
macOS Mojave 10.14.6, Retina 5K, Radeon Pro 580
SteveBros
 
Posts: 17
Joined: Sun Apr 19, 2015 1:31 am

Re: Calc crashes when copying entire column

Postby RoryOF » Wed Feb 05, 2020 11:20 am

Such "distortions of text" are probably edge effects from the tiling of areas of the video driver; they may perhaps be eliminated by changing the "antialiasing" and "hardware acceleration" settings in /Tools /Options /OpenOffice /View. On a Mac, Options is under preferences.
Apache OpenOffice 4.1.7 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31446
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland


Return to Calc

Who is online

Users browsing this forum: No registered users and 10 guests