You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2011/10/21 17:34:39 UTC

DO NOT REPLY [Bug 118537] New: When there are a large number of Charts in a spreadsheet a number of charts just display OLE

https://issues.apache.org/ooo/show_bug.cgi?id=118537

             Bug #: 118537
        Issue Type: DEFECT
           Summary: When there are a large number of Charts in a
                    spreadsheet a number of charts just display OLE
    Classification: Application
           Product: Spreadsheet
           Version: OOo 3.3 RC10
          Platform: PC
        OS/Version: Windows 7
            Status: UNCONFIRMED
          Severity: blocker
          Priority: P5
         Component: code
        AssignedTo: spreadsheet@openoffice.org
        ReportedBy: paulzchinn@hotmail.com
                CC: ooo-issues@incubator.apache.org


Created attachment 76908
  --> https://issues.apache.org/ooo/attachment.cgi?id=76908
Initial view of one of the sheets

I have a complex macro that propulates a speadsheet with multiple formatted
sheets, each with an embedded chart, from external data.  The macro has worked
fine historically with about 50 sheets.  I am now using more data and
generating about 130 sheets within one document.  During macro execution the
first sheets initially display fine, but as more sheets are added by the macro
a large number of the sheets which were initially fine now display the chart as
only "OLE".

If the macro is rerun the with the same data the affected sheets change.

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

DO NOT REPLY [Bug 118537] When there are a large number of Charts in a spreadsheet a number of charts just display OLE

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

--- Comment #7 from brinzing <br...@openoffice.org> 2012-03-13 12:38:12 UTC ---
user "delgarot" reports a similar problem:
https://issues.apache.org/ooo/show_bug.cgi?id=110692#c15

the problem he describes is different from "Sheet lost in
incorporated Calc OLE". he was working with math formula 
ole objects in writer and uses oo321.
have a look at his two attachments.

i can confirm that ole objects can get lost in oo32, if one 
inserts ole objects (cell ranges from calc) into writer.
but i do not know how to reproduce the bug. it seems to
happen sometimes, if one works with several ole objects.

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

[Bug 118537] When there are a large number of Charts in a spreadsheet a number of charts just display OLE

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

Edwin Sharp <el...@mail-page.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |elish@mail-page.com
         Resolution|---                         |IRREPRODUCIBLE

--- Comment #8 from Edwin Sharp <el...@mail-page.com> ---
BASIC runtime error. Device I/O error. when running attachment 76910 in
OpenOffice Basic.

Rev. 1520602 Win 7

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.

DO NOT REPLY [Bug 118537] When there are a large number of Charts in a spreadsheet a number of charts just display OLE

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

mla@openoffice.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|OOo 3.3 RC10                |OOo 3.3

--- Comment #2 from mla@openoffice.org 2011-10-21 15:48:30 UTC ---
Thanks for the screenshots that show the problem. However, the mentioned
spreadsheet and macro are need, please attach to this issue. Otherwise the
problem cannot analyzed.

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

DO NOT REPLY [Bug 118537] When there are a large number of Charts in a spreadsheet a number of charts just display OLE

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

leiw@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |leiw@apache.org
           Severity|blocker                     |critical

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

DO NOT REPLY [Bug 118537] When there are a large number of Charts in a spreadsheet a number of charts just display OLE

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

brinzing <br...@openoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |brinzing@openoffice.org

--- Comment #6 from brinzing <br...@openoffice.org> 2012-03-13 11:45:22 UTC ---
.

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

DO NOT REPLY [Bug 118537] When there are a large number of Charts in a spreadsheet a number of charts just display OLE

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

Wang Lei <le...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |lei.wang.leiw@gmail.com

--- Comment #5 from Wang Lei <le...@gmail.com> 2012-03-09 08:16:59 UTC ---
How to reproduce this issue?

Can you provide the original Spreadsheet file, not the generated Spreadsheet
file. I need this file and the VBA codes to reproduce this issue.

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

DO NOT REPLY [Bug 118537] When there are a large number of Charts in a spreadsheet a number of charts just display OLE

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

--- Comment #1 from paulzchinn@hotmail.com 2011-10-21 15:35:52 UTC ---
Created attachment 76909
  --> https://issues.apache.org/ooo/attachment.cgi?id=76909
Same sheet later in execution

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

[Bug 118537] When there are a large number of Charts in a spreadsheet a number of charts just display OLE

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

liupingtan <do...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         QA Contact|                            |psfobbe.qa@gmail.com

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

DO NOT REPLY [Bug 118537] When there are a large number of Charts in a spreadsheet a number of charts just display OLE

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

Armin Le Grand <Ar...@me.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |Armin.Le.Grand@me.com

--- Comment #4 from Armin Le Grand <Ar...@me.com> 2012-02-27 17:25:32 UTC ---
ALG: Lot of asserts when loading from
C:\aoo\svn_trunk\main\embeddedobj\source\general\xcreator.cxx:209, also
problems in
C:\aoo\svn_trunk\main\svx\source\sdr\contact\viewcontactofsdrole2obj.cxx:101
where the test if it is a chart says false. This should probably not happen.

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

DO NOT REPLY [Bug 118537] When there are a large number of Charts in a spreadsheet a number of charts just display OLE

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

--- Comment #3 from paulzchinn@hotmail.com 2011-10-21 17:12:05 UTC ---
Created attachment 76910
  --> https://issues.apache.org/ooo/attachment.cgi?id=76910
This is the macro that generates the spreadsheet


The entry point to the very complex macro is at waypoint_extractor

The  generated spreadsheet file is too big to upload and so here is a URL to a
copy:

http://www.pilgrimagepublications.com/paul/Generated%20Spreadsheet.ods

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