Hello Christoph,<br><br><div class="gmail_quote">2011/6/5 Christoph Noack <span dir="ltr"><<a href="mailto:christoph@dogmatux.com">christoph@dogmatux.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi Markus, Kohei, all!<br>
<br>
Am Sonntag, den 05.06.2011, 13:23 -0400 schrieb Kohei Yoshida:<br>
<div class="im">> Hi Markus,<br>
><br>
> On Sat, Jun 4, 2011 at 8:04 PM, Markus Mohrhard<br>
> <<a href="mailto:markus.mohrhard@googlemail.com">markus.mohrhard@googlemail.com</a>> wrote:<br>
><br>
> > I would like to here any suggestions before I change anything UI related.<br>
<br>
</div>Cool :-)<br>
<br>
Although Kohei already proposed an alternative, I'd like ask you<br>
something. In you initial mail, you've stated "it turns out that we need<br>
<div class="im">much more time updating the progress bar than we need to move the<br>
</div>sheet". How much is needed for such stuff - also considering rare cases?<br></blockquote><div><br>The problem is that we have to differentiate between two cases. We have the case with a lot of formulas, then most work is done in updating every cell, if we have few formulas most work will be done relocating the sheet and at the moment updating the progress bar.<br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
If we could guarantee that moving stuff around will never take more than<br>
(let's say) 1 second (complex document, old computer), then there is no<br>
need to visualize the status of this operation. If not, then the user<br>
has to be informed about that ... thus, Kohei's suggestion (as far as I<br>
understand it (I'm not a developer) sounds very reasonable.<br></blockquote><div><br>Yes I think I have to implement Kohei's suggesstion. I think a slow computer, several sheets and a lot of formulas will need some seconds. At least it should be faster than in the 3.4 releases. My test case with 5000 empty sheets will need without a progress bar around 4 seconds and around 12 seconds with the progress bar.( I hope than no one will ever get the impression that working with 5000 sheets is a normal use case for calc, it just makes profiling much easier)<br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="im"><br>
> So, there are two things that I could see us changing.<br>
><br>
> One is to update the progress bar only once per sheet, instead of once<br>
> per column in each sheet. I find the latter simply a bit silly, not<br>
> to mention it has terrible performance consequences.<br>
<br>
</div>[...]<br>
<div class="im"><br>
> The key is to not eliminate the progress bar, but simply reduce the<br>
> frequency of updating which can be very expensive especially when<br>
> using GTK to draw the progress bar.<br>
<br>
</div>Cheers,<br>
<font color="#888888">Christoph<br>
<br>
</font></blockquote></div><br>