You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2009/09/30 16:01:53 UTC

DO NOT REPLY [Bug 47920] New: Can't embed HSSF into HSLF

https://issues.apache.org/bugzilla/show_bug.cgi?id=47920

           Summary: Can't embed HSSF into HSLF
           Product: POI
           Version: 3.5-dev
          Platform: PC
        OS/Version: Windows Vista
            Status: NEW
          Severity: major
          Priority: P2
         Component: HSLF
        AssignedTo: dev@poi.apache.org
        ReportedBy: roman.durdik@volny.cz


When the embedded Excel Workbook is opened and stored again into PowerPoint
presentation, it is not possible to access it again. Please see the attachment
for the program doing the action. There is also the template which consists the
embedded excel workbook.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

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


DO NOT REPLY [Bug 47920] Can't embed HSSF into HSLF

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47920

--- Comment #4 from pichlermeister@gmail.com 2010-01-28 07:29:55 UTC ---
Created an attachment (id=24901)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24901)
Eclipse Example Project showing the bug

Here is my Eclipse Example Project. 
I used the latest development build (poi-3.7-SNAPSHOT-20100126.jar and
poi-scratchpad-3.7-SNAPSHOT-20100126.jar) of of apache poi because in Release
3.6 I couln't open the new workbook in my output presentation

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

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


DO NOT REPLY [Bug 47920] Can't embed HSSF into HSLF

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47920

Yegor Kozlov <ye...@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

--- Comment #2 from Yegor Kozlov <ye...@dinom.ru> 2009-12-15 01:40:56 UTC ---
Fixed in r890714

When embedding a workbook, MS Office modifies the .xls file and sets a special
property called StorageClassID. It turned out that this property is important
for embedded objects - MS Office uses it to activate the document's
application. HSSFWorkbook did't preserve this property across read-write and it
was the reason why PowerPoint could not open embedded .xls after modification.

Yegor

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

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


DO NOT REPLY [Bug 47920] Can't embed HSSF into HSLF

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47920

Yegor Kozlov <ye...@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|REOPENED                    |RESOLVED
         Resolution|                            |INVALID

--- Comment #5 from Yegor Kozlov <ye...@dinom.ru> 2010-02-14 17:03:05 UTC ---
> Preview of embedded workbooks are not automatically updated when the content of
> the workbook gets overwritten.
> 
Sorry, it's beyond the scope of POI. Generating of preview images is a feature
of GUI (MS Office or OpenOffice). POI is a library to read/write office files,
it can't emulate Excel UI and update the preview image. 

Yegor

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

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


DO NOT REPLY [Bug 47920] Can't embed HSSF into HSLF

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47920

--- Comment #1 from Roman Durdik <ro...@volny.cz> 2009-09-30 09:16:22 PDT ---
Created an attachment (id=24326)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24326)
Program showing the bug.

The Eclipse project. The program opens powerpoint template and excel workbook
inside it. Then it stores the workbook back to the powerpoint presentation and
saves it into output directory. It is needed to put poi-3.5-FINAL-20090928.jar
and poi-scratchpad-3.5-FINAL-20090928.jar into lib directory to run the
program.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

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


DO NOT REPLY [Bug 47920] Can't embed HSSF into HSLF

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47920

pichlermeister@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Priority|P2                          |P1
                 CC|                            |pichlermeister@gmail.com
            Version|3.5-dev                     |3.7-dev
         OS/Version|Windows Vista               |Windows XP

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

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


DO NOT REPLY [Bug 47920] Can't embed HSSF into HSLF

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47920

pichlermeister@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |REOPENED
         Resolution|FIXED                       |

--- Comment #3 from pichlermeister@gmail.com 2010-01-28 07:13:34 UTC ---
Preview of embedded workbooks are not automatically updated when the content of
the workbook gets overwritten.

When the embedded workbook is inline (shown as table/preview - not as icon as
the example above) and gets opened and stored again with the content of another
workbook, the workbook-preview of the output PowerPoint is still the same as
before. 
When double-clicking on the embedded workbook of the output-PPT Excel opens
with the new data and the preview gets updated.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.

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