Ask Your Question
1

OLE-objects in Calc [closed]

asked 2013-03-06 14:17:00 +0200

Grookie gravatar image

Is it possible to do the same as in MS Office?

In MS there is the possibility to have a Word-file as an icon in Excel (created as an object) and inside the word you can make chains to calculations in Excel. These are automatically updated with changes made in Excel (values, fonts, proporties ect.)

If not we hope it wil be a possibility in the future because without thes feature, we can not use the product in our company.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-03 17:42:43.226462

3 Answers

Sort by » oldest newest most voted
0

answered 2014-09-12 21:34:31 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hello, if you still need this information, you can insert OLE objects in documents Libreoffice.

Insert-> Object -> OLE Object

I recommend selecting from the list of types, the option other objects, and raising a new dialog that allows you to insert the object as an icon, which should be more common if you used her tool of monopoly.

edit flag offensive delete link more
0

answered 2014-09-13 10:23:38 +0200

oweng gravatar image

updated 2014-09-13 10:24:44 +0200

If this is possible, it would only be so for the Windows build of LO as that is the only build offering a "display as icon" option for an OLE object. Refer the answer here. The answer here lists the related bug report to get this feature implemented on other platforms.

edit flag offensive delete link more

Comments

Thank you for your answer. We are using LO on Windows mashines only - so it is perfect for us :)

Grookie gravatar imageGrookie ( 2014-09-23 11:34:09 +0200 )edit
0

answered 2013-03-06 20:30:49 +0200

qubit gravatar image

Hi @Grookie,

Here's my understanding of what you'd like to do:

  • Embed a Writer document "Foo" as an OLE object in a Calc document "Bar"
  • Be able to open up Foo and add/edit references to data in Bar
  • Whenever the data in Bar changes, the Bar data displayed in Foo must be automatically updated

Does that cover it?

edit flag offensive delete link more

Comments

Yes it is about correct. We would like to have a document as an icon inside calc - so when we write the document we are able to inset calculations from calc inside the document - and these are automacially updater in the future.

Grookie gravatar imageGrookie ( 2013-04-11 10:38:20 +0200 )edit

@Grookie - Thanks for the update! I don't know too much about OLE objects, but hopefully we can find you someone who has this expertise.

qubit gravatar imagequbit ( 2013-04-11 18:23:29 +0200 )edit

Question Tools

Stats

Asked: 2013-03-06 14:17:00 +0200

Seen: 865 times

Last updated: Sep 13 '14