[ubuntu-za] OLE object in OOO Spreadsheet

[miles]

On Fri, 2010-03-12 at 11:50 +0200, Robin Bownes wrote:
> 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
hi Robin,

I hope one of these will help you.

"Calc" http://www.openoffice.org/product/calc.html :: "sc: Spreadsheet
Project" http://sc.openoffice.org/ :: "OpenOffice.org Calc - Wikipedia,
the free encyclopedia"
http://en.wikipedia.org/wiki/OpenOffice.org_Calc :: "Differences in Use
between Calc and Excel - OpenOffice.org Wiki"
http://wiki.services.openoffice.org/wiki/Documentation/OOoAuthors_User_Manual/Migration_Guide/Calc_and_Excel :: "Personal Finance Spreadsheet Templates f 
I know nothing about office and all that stuff.
Sorry.
Miles