[sc-issues] [Issue 81857] Charts slow down macros
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81857 User iha changed the following: What|Old value |New value CC|''|'iha' Assigned to|iha |mav Component|Spreadsheet |framework QA contact|[EMAIL PROTECTED] |[EMAIL PROTECTED] Subcomponent|programming |code --- Additional comments from [EMAIL PROTECTED] Fri Oct 5 13:53:37 + 2007 --- ->Mikhail, I am unsure whether the absolut immediate request of a new replacement image is really correct. If someone would like to make a kind of animation of the chart then the current behavior is what he needs. On the other hand normally the repaint behavior is controlled by the vcl repaint timer via invalidate call. When you replace the call UpdateReplacement() with UpdateReplacementOnDemand() in the methods EmbedEventListener_Impl::modified() and EmbedEventListener_Impl::notifyEvent() in svtools/source/misc/embedhlp.cxx you will get a fast execution of the original macro also without locking the charts explicitly. As said I am unsure whether this would be correct for visible charts, but I think at least non visible ole objects should recreate their replacement image only on demand and not for every notified change. What do you think? - 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]
[sc-issues] [Issue 81857] Charts slow down macros
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81857 --- Additional comments from [EMAIL PROTECTED] Fri Oct 5 13:26:38 + 2007 --- Created an attachment (id=48710) corrected macro thus charts are locked during multiple updates - 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]
[sc-issues] [Issue 81857] Charts slow down macros
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81857 --- Additional comments from [EMAIL PROTECTED] Fri Oct 5 13:21:56 + 2007 --- The changes on the calc cells are notified to the chart which than notifies the framework. The framework then requests a new image from the modified chart. This is why the charts are recreated and repainted after each according cell modification. There is an API to prevent the notification of changes for a while and thus do several changes at once and notify only afterwards. These are the methods lockControllers() and unlockControllers() at the interface com::sun::star::frame::XModel. I will added an according sub called 'lockCharts' to the macro in the attached example. The function does lock or unlock all charts in the spreadsheet. It is important to call lock and unlock in pairs, so be careful when using this new sub. But as far as I can see no new charts are created in this example. When you try the fixed macro which makes use of the locking API you will find it as fast or even faster in OOo 2.3 than before in OOo 2.2. - 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]
[sc-issues] [Issue 81857] Charts slow down macros
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81857 User fst changed the following: What|Old value |New value Target milestone|--- |OOo 2.4 --- Additional comments from [EMAIL PROTECTED] Mon Sep 24 09:33:42 + 2007 --- set target to 2.4 as we had done it better with the old chart - 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]
[sc-issues] [Issue 81857] Charts slow down macros
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81857 User fst changed the following: What|Old value |New value Assigned to|spreadsheet |iha Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from [EMAIL PROTECTED] Mon Sep 24 09:32:25 + 2007 --- Hi Ingrid, as discussed this onefor you. Frank - 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]
[sc-issues] [Issue 81857] Charts slow down macros
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81857 --- Additional comments from [EMAIL PROTECTED] Sun Sep 23 10:55:53 + 2007 --- There's something else. If I delete the charts, undo until the charts are back it's fast again - until I save. Then it becomes slow again. Lots of Greetings! Volker - 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]
[sc-issues] [Issue 81857] Charts slow down macros
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81857 --- Additional comments from [EMAIL PROTECTED] Sun Sep 23 10:49:21 + 2007 --- Created an attachment (id=48429) I've uploaded the file to this issue. I'ts the same file the link in the URI field points to. - 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]
[sc-issues] [Issue 81857] Charts slow down macros
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=81857 Issue #|81857 Summary|Charts slow down macros Component|Spreadsheet Version|OOo 2.3 Platform|PC URL|http://www.mediafire.com/?fznnrmzzdkj OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|hetzi --- Additional comments from [EMAIL PROTECTED] Sun Sep 23 10:45:53 + 2007 --- Hi! I've experienced a slowdown of the macro execution speed by a factor of 10 or more when going from 2.2 to 2.3. This seems to be connected to the charts. I'm not sure whether this is a problem within the charts module or between calc and charts (too frequent updates perhaps?) so I'm posting it here. I'm sorry if I got this wrong. I've uploaded a testcase to mediafire, the link is in the URL field of this issue. The sheet has a module called "Depotzins" in which is a macro called "Rate". This function can be called by "run macro" or by clicking on the "Rate" Button, if the Toolbar is visible. It sets the field "Macro Execution time" to -1, runs, and sets it to the elapsed time. Now, on my notebook the times are like this: 2.2.1: 1s 2.3: 28s 2.3 with charts deleted: 1s. Maybe someone can look into this? Lots of Greetings! Volker - 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]
