To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111390 Issue #|111390 Summary|OOo Calc 3.0.1 and higher --> Notes bug Component|Spreadsheet Version|OOo 3.1 Platform|PC URL|http://sugar.realopenit.nl/downloads/Forecast4developm |ent.ods OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|viewing Assigned to|spreadsheet Reported by|jsteenks
------- Additional comments from jstee...@openoffice.org Wed May 5 08:12:47 +0000 2010 ------- Hello support, We used OpenOffice.org as our native office application. We have build a lot of templates and customized OOo sheets within our company for over 5 years now. We where until the OOo release 3.0.1 very happy with the product. But after the releases 3.0.1 till 3.2 we have some serious issues with a very pour performance on the same sheets. If we use a previous version like OOo 3.0 it works perfect! I think there is something changed by a developer in a way that had a very bad influence on the performance of OpenOffice.org Calc above version 3.0.1. You can find a part of a huge sheet at one of the following links, so you can check the issue by yourself: http://sugar.realopenit.nl/downloads/Forecast4development.ods or http://www.mijnbestand.nl/Uitnodiging-OYRCAUMK6XB4&download=PHZ4ZVNAG3F3 To simulate the problem you can do it on 2 ways: 1) Change on sheet “Januari” the group (view) details by clicking on 2 and after that on 1 and than back to 2. This take a little while. While in version 3.0 there was no delay!! 2) If you hit the “Optimizesheetview” macro button in the tool-bar on sheet “Januari”. You can filter items on the sheet. This is now a very VERY slow process. This macro was fast in the older versions. The “Forecast4development” sheet is a part of a huge sheet we used every hour of the day and helps us to organize, plan en calculate our business. With the latest versions of OOo we have a serious problem. I did some research myself and found that the problems are the notes in the sheet. If you delete all and only the notes it is fast again. But the notes are a must have. The use of notes in the previous versions of OOo where never a problem? What and why is this changed? I had before logging this issue a mail conversation with Elizabeth Matthis (elizabeth.matt...@sun.com). She ask me to file a new issue in IssueTracker because this one is not the same as the ones in the issues she quoted in her original response. For a complete log of our conversation I have this conversation included below this message. I think that if support is able to scan this whole conversation and test my sheet. This will be a complete and clear description of our problem with OOo 3.1 and higher. I hope there is a way you can fix this problem? Kind Regards, Johan Steenks Consulting manager RealOpen IT B.V. - Informaticalaan 7 - 2628 ZD Delft - The Netherlands Tel (+31) 15-2568969 - Mobiel (+31) 6-42705672 e-mail jstee...@realopenit.nl - http://www.realopenit.nl ----------------------------------------------------------------------------------------------------------------------------------------------- Below my previous conversation with Liz. This was here first reaction on my above call ----------------------------------------------------------------------------------------------------------------------------------------------- Op 4/8/2010 om 05:36 nm is in bericht <4bbdf804.5060...@sun.com> door Elizabeth Matthis <elizabeth.matt...@sun.com> geschreven: Hello Johan, Speed regarding *hidden* notes was improved in OOo 3.2 so I'm guessing you are having a problem with visible notes. I asked a Calc developer and he said that your document must have tons of notes in order for there to be such a delay. Unfortunately, we didn't get your attachment because attachments are blocked from mailing lists. I found two similar issues already in issue tracker. Please add any additional insights to help the QA team get to the bottom of the problem and attach your document to one of the issues: http://www.openoffice.org/issues/show_bug.cgi?id=102716 http://www.openoffice.org/issues/show_bug.cgi?id=109276 I hope the developers will figure out what is creating the delay and get it fixed so you and others can enjoy working with OOo Calc again. Best regards, Liz p.s. If you are new to Issue Tracker you might want to read this for future reference: http://qa.openoffice.org/issue_handling/pre_submission.html ----------------------------------------------------------------------------------------------------------------------------------------------- Below my reply on this mail from Liz. ----------------------------------------------------------------------------------------------------------------------------------------------- Hello Liz, Thank you for very much for your quick response. I think that my document is a must have for a developer! This document is a part of a huge sheet. But the problems we have are easy to simulate in a part of this sheet and therefore very easy to thoubleshoot by a developer a guess. You can find our sheet at one the following links: http://sugar.realopenit.nl/downloads/Forecast4development.ods or http://www.mijnbestand.nl/Uitnodiging-OYRCAUMK6XB4&download=PHZ4ZVNAG3F3 We are working with hidden notes and we absolutely don´t use tons of notes (We have mostly between the 30 and 50 notes on a month sheet). It is the combination of notes and the use of outlines I guess. Check the above file please. If you delete the notes by selecting all cells and use delete contents (only the notes). The sheet is fast again. Remember this was fast in the OOo Calc versions before 3.1! What you also can see is that OOo makes sometimes a mess of the note view. I think this had also something to do with the outlines. When I read the issues you found in the issue tracker. I see that both issues had a lot of notes. This is not our case or we can maybe on this case help development to find also the performance bug in the notes. Because I think in the design change between OOo Calc 3.0.1 and OOo Calc 3.1. There is big performance difference in Calc. For your information we are working with Sun OOo version 3.2. Best regards, Johan Steenks Consulting manager RealOpen IT B.V. ▪ Informaticalaan 7 ▪ 2628 ZD Delft ▪ The Netherlands Tel (+31) 15-2568969 ▪ Mobiel (+31) 6-42705672 e-mail jstee...@realopenit.nl ▪ www.realopenit.nl ----------------------------------------------------------------------------------------------------------------------------------------------- Below Liz her reaction to file a new issue for this problem ----------------------------------------------------------------------------------------------------------------------------------------------- -------- Original Message -------- Subject: Re: [ux-request] OpenOffice.org Calc 3.1 and higher --> develop bug? (resent) Date: Mon, 19 Apr 2010 12:10:34 +0200 From: Elizabeth Matthis <elizabeth.matt...@sun.com> Reply-To: requ...@ux.openoffice.org To: requ...@ux.openoffice.org References: <4bcc3d6b020000440001a...@mail.realopenit.nl> Hi Johann, On 04/19/10 11:24, Johan Steenks wrote: > Hello support, > > > > I was very surprised that on my first sign for help that there was a > very quick response! > :-) > I think (and there are a lot off users having performance issues with > OOo). That my case where we can easy re-produce the problem will help to > solve one piece of the performance puzzle there is with OOo 3.1 and > above. > > > True! > But is there someone who can give me a status on this case? Because now > I have the feeling after a good and quick start that this case does not > have the attention anymore. > > Not true. I just only work part time and the ux-request mailing list is not "support". ;-) > > I did a small test with to similar workstations and the same sheet. On > the workstation with version 3.0, the save time (including running a > macro and building a planning) is 42 seconds. On a workstation running > OOo 3.2, doing exact the same steps, it will take 2 minutes and 13 > seconds!! You can say we have a delay of 3 times by working with OOo > 3.2. > > I realize that your problem is not the same as the ones in the issues I quoted in my original response, so please file a new issue in IssueTracker. http://qa.openoffice.org/issue_handling/pre_submission.html It is important that the problem you are experiencing is handled properly, and email does not have the necessary "weight" in the process. Please note the issue number here and then I'll help get the issue attention. Add all your insights from these messages into the issue and add the documents as attachments. You have been very thorough in your description, so your text is valuable in getting a solution. > > Please read the following comments from the previous e-mails, because I > think that a lot of OOo users who is having performance issues on OOo > 3.2 have may be a similar problem. Why the still don´t use tons of > notes. > > > > I hope that development will take a closer look between OOo 3.0 and OOo > 3.1 and the use of notes in particular. Please again check my example. > > > > Best regards, > > > > Johan Steenks > Consulting manager > > Best regards, Liz --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org