[Solved] Errors in Calc - LO Version 7.1.5

Discuss the spreadsheet application
Post Reply
crusader
Volunteer
Posts: 506
Joined: Sun Jan 20, 2008 5:06 am

[Solved] Errors in Calc - LO Version 7.1.5

Post by crusader »

Last week, I upgraded from LibreOffice 7.1.4 to 7.1.5 (I routinely upgrade when a newer version is released). I was shocked to see the spreadsheet I need daily displaying serious errors. I took all standard steps (uninstall, reinstall, shutdown, restart, check other spreadsheets, etc.) to no avail. The display continues to be erroneous - and many times different (the LO logo doesn't display each time, but the grayed/blacked out area does - for the most part). I have been dealing with this for several days (feels like years)!

I uninstalled version 7.1.5 and reinstalled version 7.1.4, but that did not change the outcome - even though version 7.1.4 ran perfectly fine before I upgraded to version 7.1.5. In the hope of resolving the "instability" of the newer versions, I uninstalled all of them, and installed LO 7.0.6 ("stable version"); however, I continued to get the fancy errors.

As a desperate measure, I installed the latest Portable version of LO (7.1.4) - and got the relief I was looking for: the same spreadsheet which was giving me a fancy erroneous display opened "normally" with Portable version 7.1.4!

I am planning to "File a bug" on the LO "Testing - QA" website. In the interim, I am requesting assistance/answers to my questions, please.

Questions:

Am I the only privileged one to get these fancy displays? :)
Is this a LO issue, my laptop issue, or both?
Most importantly, what is the solution to this problem?

All help will be greatly appreciated.

Note: I had to shave off the image to meet file size limitations.
Attachments
PrintScreen.pdf
(116.04 KiB) Downloaded 123 times
Last edited by crusader on Mon Jul 26, 2021 6:55 pm, edited 1 time in total.
LO 7.x on Linux Mint
In a world without walls, who needs Window$.
A candle loses nothing by lighting another candle.
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Errors in Calc - LO Version 7.1.5

Post by Villeroy »

On the screenshot II see a heavily formatted sheet. I don't know how it looks under normal conditions. My sheets look fine with LO 7.1.5 on LInux, however I avoid heavy formatting on all my sheets. You have to upload a document which shows the problem on your computer. Then we can open the same document on different systems with different office versions.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
crusader
Volunteer
Posts: 506
Joined: Sun Jan 20, 2008 5:06 am

Re: Errors in Calc - LO Version 7.1.5

Post by crusader »

I have uploaded the file; I have deleted the 20+ sheets and private data that the original file contained. A version of the error is still visible. What I see when using "regular" LO 7.1.5 and Portable LO 7.1.4 are quite different.

Your assistance is greatly appreciated.
Attachments
Actual File.ods
(14.44 KiB) Downloaded 122 times
LO 7.x on Linux Mint
In a world without walls, who needs Window$.
A candle loses nothing by lighting another candle.
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Errors in Calc - LO Version 7.1.5

Post by Villeroy »

The file looks identically with AOO, LO 6.0 and LO 7.1.5 on Linux.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
crusader
Volunteer
Posts: 506
Joined: Sun Jan 20, 2008 5:06 am

Re: Errors in Calc - LO Version 7.1.5

Post by crusader »

Thank you for the support, Villeroy.

Based on your findings, the problem may be at my end. I wonder what accounts for the differences in view when using "regular" LO vs Portable LO.
LO 7.x on Linux Mint
In a world without walls, who needs Window$.
A candle loses nothing by lighting another candle.
crusader
Volunteer
Posts: 506
Joined: Sun Jan 20, 2008 5:06 am

Re: Errors in Calc - LO Version 7.1.5

Post by crusader »

Villeroy wrote:The file looks identically with AOO, LO 6.0 and LO 7.1.5 on Linux.
I wonder how the file looks to others using Windows, especially comparing "regular" LO to Portable LO.

Feedback would be greatly appreciated.
LO 7.x on Linux Mint
In a world without walls, who needs Window$.
A candle loses nothing by lighting another candle.
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Errors in Calc - LO Version 7.1.5

Post by Villeroy »

LO 7.1.5 on Windows
Attachments
LO7.1.5 (4).png
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Errors in Calc - LO Version 7.1.5

Post by John_Ha »

Strange problems are often fixed by resetting the user profile - see Resetting the user profile.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
crusader
Volunteer
Posts: 506
Joined: Sun Jan 20, 2008 5:06 am

Re: Errors in Calc - LO Version 7.1.5

Post by crusader »

John_Ha wrote:Strange problems are often fixed by resetting the user profile - see Resetting the user profile.
Hallelujah! Resetting my user profile did the trick.

John_Ha and Villeroy, your support is greatly appreciated!

I will mark this post as solved and withdraw/mark solved my post on "Testing - QA" website.
LO 7.x on Linux Mint
In a world without walls, who needs Window$.
A candle loses nothing by lighting another candle.
Post Reply