[Libreoffice-ux-advise] new range name dialog proposal

[Kohei Yoshida]

Hi Christoph,

On Thu, 2011-10-27 at 23:15 +0200, Christoph Noack wrote:

> In such a case, what's the impact we talk about? I simply don't have a
> clue ... it could be 100 ms ... 10 seconds per update on an average PC
> (whatever average means). Would it be possible to get such a file?

Well, we are not talking about just a single file.  This question is
similar to "what's the average time Calc spends to open a file?", in
other words, it's impossible to just give you a single number to work
with.  It could be a few seconds, or it could be more than 4 minutes.

I've seen re-calculation take from just a fraction of a second, few
seconds, 10 seconds, up to more than a minute in an extreme case.  And
that can also vary with other factors such as the speed of your CPU,
what functions are used (some functions are more expensive than others),
whether a chart needs to be updated etc.

But just for the sake of the argument, let's say the re-calc takes on
average 5 to 10 seconds in a moderately worse case scenario.  This
means, on every name update, the user has to wait for 5 to 10 seconds
for the re-calc to finish, during which time the dialog becomes
unresponsive (because we are single-threaded).  This scenario is not far
removed from reality especially with some of the moderately large and
complex documents that I've seen.

Now, we could still argue that those worse case scenarios are rare
enough that we could dismiss it.  The fact that I've seen them doesn't
mean they are common.  I'm just stating that they can happen.

Kohei

-- 
Kohei Yoshida, LibreOffice hacker, Calc