Please confirm Calc bug - discontiguous selection of rows, right-click is very slow

users
#21

It really depends on how many rows you have selected.
And it does not happen with a selection of columns as you can see when
using my macro with the word Rows replaced with Columns.

With 500 selected rows there is a lag of several seconds.
With 5000 selected rows the CPU is used up for minutes.

#22

In "Getting started with Math" I found this: "To write function names with primes, as is usual in school notations, you must first add the signs to the catalog". (The catalog is a list of characters in a font).
What are "primes" in this context?
How and for what are they used?

Some Americans (or others) able to explain this to a non American?
Kolbjoern

#23

Kolbjørn Stuestøl wrote:

> In "Getting started with Math" I found this: "To write function names
> with primes, as is usual in school notations, you must first add the
> signs to the catalog". (The catalog is a list of characters in a font).
> What are "primes" in this context?
> How and for what are they used?
>
> Some Americans (or others) able to explain this to a non American?
> Kolbjoern

A prime is the symbol ' or also written as ′ or ’
so in school math you often has variables x and x' or even x'' or x'''
These are called x prime x double prime or x triple prime.

for example x' = 2x. x'' = x' + y.

#24

In "Getting started with Math" I found this: "To write function names with primes, as is usual in school notations, you must first add the signs to the catalog". (The catalog is a list of characters in a font). What are "primes" in this context?

Something like a single quotation mark or apostrophe - but different. See http://en.wikipedia.org/wiki/Prime_(symbol) . It's Unicode 2032 and HTML ′ .

How and for what are they used?

I don't know about schools, but mathematicians use them to indicate derivatives, so f'(x) is shorthand for df(x)/dx.

Some Americans (or others) able to explain this to a non American?

Sorry: I'm only an "other".

I trust this helps.

Brian Barker

#25

So, suspect' would be prime suspect? :wink:

#26

at times'

#27

Thank you all for answering me.
It helped a lot, Americans or not :-).

Kolbjoern

Den 19.04.2015 21:29, Brian Barker skreiv:

#28

As Andreas writes, it depends on the number of rows. Originally I tried
with only a small number and it was not a problem. With 500 there is a
delay of several seconds. When I tried 5000 Calc froze completely.

On a not completely unrelated topic, it slightly annoys me that when in a
Calc sheet I open the right-click menu and then select "Format" it takes
more than 5 seconds before the format box appears.

Using 4.4.2.2 under Linux Mint 17.

Graham

#29

On Slackware 14.1

My timings are

4.4.2

15 discontiguous rows - instant response
500 discontiguous rows - about 5 seconds

4.3.6

15 discontiguous rows - about 15 secods
500 discontiguous rows - over 600 seconds and still waiting

Clearly one of the developers has done something which has dramatically improved things in Linux world. Whether 5 seconds, in 4.4.2, for 500 discontiguous rows is acceptable, I'll let others be the judge. If not raise a bug to draw out comments from the developers.

Regards

#30

Ummm...

Clicking on the ROW NUMBER is precisely what is meant by 'selecting a row'.

If you were just selecting discontiguous CELLS, then you were not
testing the bug.

So, it sounds like you are confirming the problem?

#31

With 500 selected rows there is a lag of several seconds.

For me, if I only have 15 or 20 discontiguous rows selected, the delay
can be 10+ seconds.

With 5000 selected rows the CPU is used up for minutes.

Haven't bothered testing even close to that many - no need, I already
confirmed - for me - that the more you select, the slower it gets.

#32

As Andreas writes, it depends on the number of rows. Originally I tried
with only a small number and it was not a problem. With 500 there is a
delay of several seconds. When I tried 5000 Calc froze completely.

Sounds like maybe the problem is more evident on Windows.

I just tested a little more, and, just selecting every other row:

- with 10 selected, the delay is about 4 seconds
- with 20 selected, the delay increased to about 20 seconds

This is on a Win7 64bit, Intel Core-i5-4670S, 8GB RAM, running on an SSD.

On a not completely unrelated topic, it slightly annoys me that when in a
Calc sheet I open the right-click menu and then select "Format" it takes
more than 5 seconds before the format box appears.

Interesting - I saw maybe a 2 second delay the first time I just tested,
then tried a bunch more times with many variations of the number of
cells selected, and each time it opened almost immediately (within a
second)...

I tested on a blank spreadsheet, and one of our internal ones that has a
bit of data on it, as well as 15+ worksheet tabs. Maybe that one is
linux only, or has something to do with the type of content?

#33

Hi Alex,

Apparently Pedro and Graham don't see this problem on 4.4.x...

What version are you on?

#34

I see this problem on Linux LO 4.3.6