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

users
#1

Hello,

Before I go open a bug (didn't find an existing one), can someone please
confirm this for me? Been meaning to do this for a while, but something
always got in the way, but it is just started to annoy me even more...

I have been experiencing this for some time, and if memory serves it was
still a problem on the 4.1.x series...

I'm currently on 4.3.6

The problem is in Calc, has to do with selecting discontiguous rows and
a subsequent right-click action....

The more discontiguous rows you select, the slower the right-click is to
respond.

If one or more can confirm I'll go open a bug for it...

Thanks

#2

Yes same here.

The more discontiguous rows selected -

right click is painfully slow to respond
selecting subsequent rows is slow to respond

Good luck

#3

I've just tried this with a new empty sheet in LO 4.3.2.2 and haven't noticed anything - right-click seems to respond quite instantly. I have 7 non-contiguous columns selected - is that enough? Or perhaps it makes a difference if a fully populated sheet is used. I don't think I've got one handy here, I'll try when I get home later - but won't be able to post back for a few days.
/Gary

#4

Hi Gary - but my problem description specifically said ROWS.

Interestingly - I hadn't thought to try columns, since the spreadsheet
I'm working in I'm only doing the rows, but I can confirm that my
problem is ONLY present for ROWS.

#5

Tanstaafl wrote

The problem is in Calc, has to do with selecting discontiguous rows and
a subsequent right-click action....

The more discontiguous rows you select, the slower the right-click is to
respond.

Right click is immediate regardless of the number of discontiguous cells
selected in my Windows XP Pro x86 SP3 machine (a 7 year "old" Core 2 Duo
with 2GB RAM) running LibreOffice 4.4.3.1

Maybe the problem you are experiencing has already been solved?

#6

<sigh>

ROWS. NOT CELLS. AND NOT COLUMNS.

#7

Tanstaafl wrote

<sigh>
ROWS. NOT CELLS. AND NOT COLUMNS.

The same applies to selecting rows or columns. No delay.

No need to shout. You are being unnecessarily rude.

#8

Using 4.4.2.2 under Linux Mint 17 the right-click menu appeared immediately
when I selected 25 non-contiguous rows.

Graham

#9

Hello Tanstaafl,

I'm working in I'm only doing the rows, but I can confirm that my
problem is ONLY present for ROWS.

It also takes longer for the selected dis-contiguous rows to get
highlighted the more you add. Again, not so for columns.

I could understand it if the same applied to rows & columns. Weird.

#10

Hi Brad,

What version are you on? This may already be fixed in 4.4.x since 2
others with different 4.4.x versions have said they don't see the problem...

#11

Sorry - I must have had a blind spot.  Just tried with rows, and yes, it does indeed seem to take increasing time as the number of discontiguous rows increases.

#12

Confirmed. To help testing, the following Basic code selects 500
discontinuous rows. Context menu and tabbing is very slow.

#13

Should have mentioned that I originally tested on 4.3.6 which exhibited the problem as described by Tanstaafl.

I've subsequently tried it on 4.4.2 and the problem appears fixed.

Alex

#14

Hello Tanstaafl,

What version are you on? This may already be fixed in 4.4.x since 2

4.3.3.2 from the Debian testing repos. So, I'm a bit off the latest.

#15

LibreOffice 4.4.2.2 on Windows Vista 32 bit. Using a new, empty sheet.

It only seems to happen with rows, not columns. Or at least, if it does happen with columns, more need to be selected before the delay becomes noticeable.

With rows 1, 3, 5, etc. for a total of 7 selected, the delay was barely noticeable, but with 15 selected it was.

There seems to be more of a delay right-clicking in the row labels, rather than clicking in the highlighted cells, although there is a delay in both cases.

Mark.

Gary Collins wrote:

#16

Thanks Mark...

After prior replies, it appears it may still be there in the 4.4.x
series, but maybe only on Windows.

I'll be installing the latest 4.4 soon, and will test some more before
opening a bug. Will report back here, and ask others to test a bit more
and comment, to try to determine

a) if it is indeed still there, and

b) if it is, is it windows only.

Thanks to all for replying...

#17

Same behaviour with
LO 3.5
LO 4.4.2
AOO 4.1.1
tested under Windows (the latter 2) and Linux (all 3).

#18

Hmmm... Graham replied that he saw no evidence of the problem on Linux
Mint with 4.4.2...

Graham? Can you confirm?

#19

I don't get the problem on 4.4.2 running Slackware 14.1

I do get the problem on 4.3.2 and 4.3.6 running Slackware 14.1

I get an erratic selection bug on 4.4.2 under writer which has caused be to go back to 4.3.6.

Alex

#20

I'm currently on 4.3.6

The problem is in Calc, has to do with selecting discontiguous rows and
a subsequent right-click action....

The more discontiguous rows you select, the slower the right-click is to
respond.

If one or more can confirm I'll go open a bug for it...

Thanks

I am not able to verify this problem.
Test 1: Selected 15 non-contiguous rows. Test 2: Selected 30 non-contiguous rows.

Windows 8.1 all updates, 64b OS, LibreOffice 4.1.2.3: No problem. Right-clicking opens the menu immediately.
Windows 8.1, all updates, 64b OS, LibreOffice 4.3.4.1: No problem.
Windows 7, all updates,64b OS, LibreOffice 4.4.2.2: No problem.

But, if I selects the entire rows by clicking on the row numbers at the left side, the Windows 8.1 computer running LO 4.3.4.1 (laptop) slows down. Perhaps something to do with the computer?
Kolbjoern