To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96961 Issue #|96961 Summary|Chart duplicates data in spreadsheet Component|Spreadsheet Version|OOo 3.0 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|tom_h
------- Additional comments from [EMAIL PROTECTED] Fri Dec 5 21:03:22 +0000 2008 ------- Adding a chart to a spreadsheet results in creation of a copy of the data being charted. This data is stored in the "content.xml" data for the chart object. This is a design defect, resulting in larger than necessary spreadsheet files, and very, very slow execution for large numbers of rows being charted (e.g., 50K rows for 2 columns displayed in an XY graph). While I don't the details behind the design decision for this, the apparent solution from my viewpoint, is that chart object should store links to the data rather than a copy of the data. This issue degrades the performance of Calc to the point of making it unusable for large datasets. To illustrate this, create a sheet of two columns of numbers with 50K rows. Create an XY chart from the 2 columns. Try copy/paste a copy of the chart. Try to edit a chart's properties. Give yourself a few minutes for each chart operation, depending upon the speed of your computer. In one of my spreadsheets, with about 20 cols X 58400 rows, I created 6 XY charts on another sheet. Took awhile but worked. Saved it. Selected the range containing the graphs and "exported selected range to PDF". Calc hung - after about 30 minutes, killed process via Task Mgr. The soffice.bin process was using about 240MB -- the ODS file is about 6.3 MB with the 6 charts in it, and about 1+ MB with no charts. version: WinXP sp3, OOo 3.0 hardware: (1) 2GB mem. cpu = Athlon 64 3200, (2) 4GB mem., cpu = core-duo E6850 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
