Apache OpenOffice (AOO) Bugzilla – Issue 89168
Embedded Excel spreadsheet in Word document opens in Read Only within Writer
Last modified: 2017-05-20 10:11:50 UTC
My users frequently receive Word documents containing Excel graphs. When using Word and Excel, double clicking a graph allows you to edit cell values. With Writer and Calc, the spreadsheet opens in Read Only and cannot be edited. This is a problem I have with all versions of OOo (including Beta 3.0.0)
These OLE objects must be converted to OOo own objects before they can be edited on systems where no MS Office is installed on. This can be activated in "Tools.Options.LoadSave.MS Office".
Closed.
I wonder whether we should re-think that. I believe that conversion on loading is wrong anyway and our new docx filter will not do that anymore. So perhaps we reopen this issue as an enhancement called "don't require conversion of OLE objects in Worxelpoint documents to make them editable?
MRU->MBA: of course we could that... but from my POV I do not see any possibility to open external objects without converting them - please clear me up in my simple view of a common tester. I mean they also have to go through the filter when displaying them in read-only mode. Perhaps this issue should should just slightly be renamed to "OO does not really need r/o mode for external objects". What do you think about this?
Reopening issue.
Reassigned to 'MAV.
The point is that we don't need to open external objects at all before the user starts to edit them. Instead of that we can just copy the bits from the external document to our internal storage. For display purposes we still have the embedded metafile (that since OOo2.0 is the original wmf or emf anyway!) so indeed we don't need to load and convert the external object before the user wants to edit it. This is the way how the new docx filter handles it. So perhaps we could do the same in the "old" doc filter.
*** Issue 93154 has been marked as a duplicate of this issue. ***
I followed the process: 1) Create a graph of some data in Microsoft Excel. 2) Copy graph and paste in Open Office Word. 3) Double Click any area of the graph. When doing this, I am only allowed to change certain features of the graph, but not the values themselves. I have the same issue as you do. Though this is not necessarily a bug as much as it is just the way the Word Processor handles objects from other programs, I'd suppose. I'm using OOo 3.4.1 on Windows 7 64 bit.
Please attach example (link in URL above isn't working).
No info from author.