Apache OpenOffice (AOO) Bugzilla – Issue 104848
Imported OLE object from calc to Writer or Draw does not stay scrolled to correct location or on correct sheet
Last modified: 2010-05-22 09:52:05 UTC
If I import a spreadsheet as an OLE object, linked, into a Draw or Writer file, and scroll down in the object then click off, it does not always stay scrolled to the same location. This is especially noticeable when you have the spreadsheet imported multiple times so that I can display different data from the same sheet, and make changes to the spreadsheet. I have been unable to determine the exact circumstances that cause it to change the scrolled location, but often it scrolls back to the top of the spreadsheet. Furthermore, If I have multiple sheets in the spreadsheet, and attempt to have one ole object on one sheet, and another ole object on another sheet, the scrolling issue remains, as well as formatting issues. The table zoom (stretching might be more correct) often gets horribly messed up between the multiple ole objects. This is true of other cases as well, but it is especially apparent when working with multiple sheets with multiple OLE linked objects (linked to the same file), to the point that OLE is unusable. NOTE: I have not tried to see if the problems remain if linking to different files. I have only needed to link to different sheets withing the same file, so you should likely test that as well.
I forgot to mention that the OLE objects will also change which sheet they are set to display all by themselves in the scenarios described by my original post.
- confirmed on Windows XP with 3.1.1 and 3.2.0 - confirmed on Linux X64: OOo 3.2.0 and OOO320m14 This is a duplicate of at least #64202 and even perhaps an older one. *** This issue has been marked as a duplicate of 64202 ***
duplicate -> closed