[ubuntu-za] [Fwd: OLE object in OOO Spreadsheet]

[Robin Bownes]

Hi All, 

I hope that you can help. My sister-in-law, whom I recently migrated to
Ubuntu and OpenOffice is experiencing the following problem. 

She is an accountant who receives spreadsheets from various companies.
One company embeds a scan of an actual statement into a cell of the
spreadsheet (.tif file) as an OLE object. The spreadsheet in question
was set up, by the company, in Excel, and is sent to her in that format.
In Excel, one just double clicks on the OLE object to open it in the
default graphics viewer. However, in OpenOffice Spreadsheet, there is no
"link" to the OLE object. Double clicking on the place-holder (a
rectangle) for the OLE object does nothing. It would seem that the
embedding process is semi-automated within Excel by use of the =embed()
function (gather this by looking at file in Excel on a Windows machine).
My current guess is that OpenOffice does not have (cannot find it), and
is unable to use this function.

If I cannot find a solution to this problem, my sister-in-law will have
to revert to a Microsoft system, as this forms an important aspect of
the work she does for this company. Is there an add-in, setting, etc.
that we can use?

Please help. Thanks.

Robin 

PS. A little more info that I've just discovered.
OpenOffice Spreadsheet only sees a "drawing object" where originally an
OLE Object was embedded. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://lists.ubuntu.com/archives/ubuntu-za/attachments/20100312/7c5d331b/attachment.htm