Ask Your Question

Charts in Calc showing as OLE icons

asked 2017-06-27 22:03:14 +0200

bobg gravatar image

updated 2017-07-04 20:55:16 +0200

I am using LibreOffice Build ID: 350m1(Build:2) under Ubuntu. I have plotted some data in Calc, which was initially displaying correctly as a chart. However, the chart is now no longer visible, but is displayed only as a transparent grey bordered box with a small "OLE" document icon at the centre. All the data is still there and can be edited and formatted without a problem (the is correctly displayed during editing!), but as soon as I click away from the chart the boxed icon is again all that is visible. I have searched for a solution online and also looked through all the menu Options for a solution but am unable to find one. This problem occurs on all of my spreadsheets, so it seems to be is global issue. Does any know how to set the charts to display as normal please?

Here is a test file which does exhibit the issue - and a screen dump of the chart, as it appears --- test.ods --- screen.png...

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-06-27 23:21:10 +0200

m.a.riosv gravatar image

updated 2018-03-18 23:53:57 +0200

Please test the options on Menu/Tools/Options/LibreOffice Calc/View - Objects

Edited 20170704

No problem here.

image description

Looks something is wrong with you installation.

Please test reinstalling.

edited 20180318

No issue here with your file.

image description

edit flag offensive delete link more


Thanks very much for your help. In answer to your question... In Menu/Tools/Options/LibreOffice Calc/View - Objects, all three of the drop down boxes in that section; "Objects/Charts", "Graphics", and "Drawing Objects", are already set to the "Show" option.

bobg gravatar imagebobg ( 2017-06-28 22:09:47 +0200 )edit

Please try resetting the user profile, sometimes solves strange issues. 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.

m.a.riosv gravatar imagem.a.riosv ( 2017-06-29 15:56:52 +0200 )edit

Thanks for your continuing help... I tried resetting my user profile as you suggested. I closed LO, renamed "user/registrymodifications.xcu" and then restarted Calc. A new file was created, but unfortunately the charts were still showing as boxes-with-icons. I then tried renaming the entire "user" directory in the same way. Again, a new directory was created as the program restarted - but with still no effect on the charts. (The View-Objects options were still at "Show" after both attempts.)

bobg gravatar imagebobg ( 2017-06-29 21:04:35 +0200 )edit

Please can you share a sample file with the issue?

m.a.riosv gravatar imagem.a.riosv ( 2017-06-30 02:15:25 +0200 )edit

I will send you a Cakc file on Sunday, as I am away from the computer at the moment. I actually have about 6 Calc spreadsheets - all of which have this same problem, including a very trivial Calc which I made just as a test case to make sure it wasn't a problem in the calculation itself. I can send you this one. There doesn't seem to be a way to attach files to comments - what is the best way to get it to you?

bobg gravatar imagebobg ( 2017-06-30 12:49:06 +0200 )edit

I have voted you question, so I think you have now enough karma to edit your question and attach the file.

m.a.riosv gravatar imagem.a.riosv ( 2017-07-01 14:52:00 +0200 )edit

Sorry about the longer than expected delay - here are the files. A copy of test.ods, which appears as shown in the image screen.png... Thanks again.

bobg gravatar imagebobg ( 2017-07-04 20:56:43 +0200 )edit

Any solution for this? I'm having exactly the same problem. Thanks.

wcorvi gravatar imagewcorvi ( 2018-03-18 16:18:55 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2017-06-27 22:03:14 +0200

Seen: 734 times

Last updated: Mar 18 '18