Bug 96893 - Calc Sheet Edit Refresh Issues
Summary: Calc Sheet Edit Refresh Issues
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.3.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-01-04 19:58 UTC by pebkacs
Modified: 2016-01-15 16:52 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description pebkacs 2016-01-04 19:58:47 UTC
User-Agent:       Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.106 Safari/537.36
Build Identifier: LibreOffice 5.0.3.2

After editing, adding, or modifying a cell or its contents, the sheet does not refresh, and display the new cell value, or formatting.  However, if I scroll down the sheet, the sheet updates properly.

I am also noticing that this affects the system menus too (such as the "Help" menu).

I have a multi-sheet (12-18 sheets I'd say), and I am using mostly vlookup functions between sheets.

I originally saw this issue in an early release of LibreOffice v5.0.0.x, but I could reproduce the issue every time, just by creating a new worksheet.  v5.0.3.2 (from Linux-Mint 17.3 repos) has thus-far been more reliable.

Reproducible: Sometimes

Steps to Reproduce:
1.Copy formula from cell ("=LEFT(E2626, LEN(E2626)-3)" in this case)
2.Paste formula in cell below original
  - Cell contents don't visibly update until something such as scrolling refreshes the view

OR

1.Adjust column width
  - Column width does not visibly change until something such as scrolling refreshes the view

OR

* Just about any modification to the sheet produces the issue
Actual Results:  
Cell contents/sheet format does not visibly update until something such as scrolling refreshes the view

Expected Results:  
Cell contents and sheet formatting should visibly refresh after modifications are complete to the cell/sheet

[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes


Reset User Profile?No
Comment 1 m_a_riosv 2016-01-04 23:52:17 UTC
Please test disabling the option Menu/Tools/Options/LibreOffice/View - Use OpenGL for all rendering.
Comment 2 pebkacs 2016-01-05 17:33:33 UTC
It appears that the OpenGL rendering option is disabled already.

I have purged and upgraded to v5.0.4.2 to see if the issue persists in this latest release.
Comment 3 m_a_riosv 2016-01-05 18:02:29 UTC
Please try resetting the user profile, sometimes solves strange issues. It is not deleted when reinstall.

https://wiki.documentfoundation.org/UserProfile
Usually it's enough renaming/deleting the file "user/registrymodifications.xcu",  it affect all the options in Menu/Tools/Options, and the files "user/basic/dialog.xlc" and "scrip.xlc" are overwritten, additionally custom colors in "user/config/standard.soc" are lost.
Comment 4 pebkacs 2016-01-07 21:36:44 UTC
After doing a purge with apt-get, and then installing from the download package from your site (rather than the Mint repositories), I have not seen the problem re-occur yet.  Seeing as it is an intermittent issue, I will continue looking for the issue to pop-up again over the next week.  If so, I will report back, and attempt to reset my profile.
Comment 5 pebkacs 2016-01-15 00:56:48 UTC
I have not seen this issue resurface.  I will close this issue now.  Thank you for your help.