Powerpoint embeeded Excel

[Joern Muehlencord <jo...@muehlencord.de>]

Hi,

I have tested the capabbilties of 3.7beta2 on updateing embeeded excel in 
powerpoint. It works quite well - I can extract the embedded data from the 
slide, create a HSSFWorkbook from stream, do the update, and write the updated 
workbook back to the ppt.

BUT:  powerpoint still shows the old data when I open the ppt. I have to 
refresh manually within powerpoint to get the new figures displayed. Is there 
any possibility to trigger the update automatically / programatically?

Regards
Joern

Re: Powerpoint embeeded Excel

[David Fisher <df...@jmlafferty.com>]

>> BUT:  powerpoint still shows the old data when I open the ppt. I have to refresh manually within powerpoint to get the new figures displayed. Is there any possibility to trigger the update automatically / programatically?
> 
> As I understand it, an embedded document is made up of two parts. One is the real document, the other is an EMF image of the rendering of that document. That way, opening the parent document is much quicker, as you don't have to open up potentially a dozen other office documents.
> 
> Unfortunately, as POI is unable to render office documents to an image (well, other than powerpoint files with a fair number of caveats), we can't re-generate the rendered version.

I've experimented with PPTX files and included PDFs.

PowerPoint automatically creates a bitmap version of included PDF files. If I just use zip tools built into my MacOSX finder I can unzip the PPTX, find the bitmap objects and remove the files. I then zip back up the PPTX.

When I open PPT automatically generates a bitmap version for each PDF in my PPTX. There is no warning, it just does the fix up.

I wonder if the same happens if the EMF version of an embedded XLS is deleted. I wonder if that is true for PPT and PPTX files?

Regards,
Dave
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: Powerpoint embeeded Excel

[Nick Burch <ni...@alfresco.com>]

On Tue, 21 Sep 2010, Joern Muehlencord wrote:
> BUT:  powerpoint still shows the old data when I open the ppt. I have to 
> refresh manually within powerpoint to get the new figures displayed. Is 
> there any possibility to trigger the update automatically / 
> programatically?

As I understand it, an embedded document is made up of two parts. One is 
the real document, the other is an EMF image of the rendering of that 
document. That way, opening the parent document is much quicker, as you 
don't have to open up potentially a dozen other office documents.

Unfortunately, as POI is unable to render office documents to an image 
(well, other than powerpoint files with a fair number of caveats), we 
can't re-generate the rendered version.

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org