Bug 108762 - in a spreadsheet, some of the cells are not seeable any more, some are, comments are note readable and cannot seem to be reformattable
Summary: in a spreadsheet, some of the cells are not seeable any more, some are, comme...
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.7.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Cells
  Show dependency treegraph
 
Reported: 2017-06-25 12:43 UTC by Full
Modified: 2017-11-14 16:58 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
example of the bugged display and of the correct display (25.40 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-06-25 12:43 UTC, Full
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Full 2017-06-25 12:43:32 UTC
Created attachment 134264 [details]
example of the bugged display and of the correct display

As one can see on the attached exemple: lines that were supposed to be see-able are white, can be reformatted by the paste format icon, but not by the cell formatting process : so nothing is lost, but require enormously tedious reformatting, with fear it may occur again
the comments, that are still there, cannot be read directly (see attachment)
This affects different spreadsheets
Comment 1 m_a_riosv 2017-06-25 13:36:27 UTC
I can't see what you comment, on line 10 there is only a value on J column apart from title in A and sum in N.
Comments are editable.

Please test changing OpenGL status on Menu/Tools/LibreOffice/View.

Otherwise please try resetting the user profile, sometimes solves strange issues.
https://wiki.documentfoundation.org/UserProfile
Usually it's enough renaming/deleting the file "user/registrymodifications.xcu",  it affects 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 2 Full 2017-06-25 16:40:14 UTC
Thanks for quick return

    renaming the file did not help (I tried that before reporting bug)

    -your comment on line 10: my mistake I meant line 11 of the sample file
   - I tried the profile change: this did not work out

    Please test changing OpenGL status on Menu/Tools/Options/View : 

:-)This last attempt worked! Many blessings on you and kudos for your mastery
Comment 3 m_a_riosv 2017-06-26 08:06:35 UTC
Please can you copy here the 'cache\opengl_device.log' that is in the LibreOffice installation folder.
Comment 4 Full 2017-06-26 15:41:25 UTC
Hello
I searched for the requested file: the only present thing under "cache" is "uno_packages" folder which itself is empty
Comment 5 m_a_riosv 2017-06-26 17:34:10 UTC
In my windows 10 with x64 LibreOffice:

C:\Program Files\LibreOffice 5\share\uno_packages\cache
Comment 6 Timur 2017-11-14 16:58:22 UTC
Looks like this one was resolved. I'll mark ID, although it could be WFM.
Full, if there sth. else, please comment. Bug makes no sense to stay like this.
Since you use 5.2.7.2, please also test 5.3.7.2 (last Still).