[Libreoffice-bugs] [Bug 48381] Pasting a formula in a full column appears to hang Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48381

Buovjaga  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
   Keywords||perf
   Severity|enhancement |normal
 Resolution|--- |WORKSFORME

--- Comment #9 from Buovjaga  ---
The pasting is rather quick now, so I will close this.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48381] Pasting a formula in a full column appears to hang Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48381

Buovjaga  changed:

   What|Removed |Added

 CC||srbrodd...@yahoo.co.uk

--- Comment #8 from Buovjaga  ---
*** Bug 106474 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48381] Pasting a formula in a full column appears to hang Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48381

--- Comment #7 from David Fischer davidfischer...@gmail.com ---
It took me ~20 seconds to paste =TODAY() into an entire column.  I am not sure
this should be unexpected, Calc is pasting and evaluating 1,048,576 rows.  Does
Microsoft Excel have this problem?

LO: 5.0.0.5
OS: Linux Mint 17.2

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48381] Pasting a formula in a full column appears to hang Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48381

steve -_- st...@openmailbox.org changed:

   What|Removed |Added

 Status|NEW |NEEDINFO

--- Comment #2 from steve -_- st...@openmailbox.org ---
Clement, does this persist with LO 4.4?

What are the exact steps to reproduce this problem? NEEDINFO and please back to
NEW once the requested information has been provided.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48381] Pasting a formula in a full column appears to hang Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48381

clem clement.marsh...@free.fr changed:

   What|Removed |Added

 CC||clement.marsh...@free.fr

--- Comment #3 from clem clement.marsh...@free.fr ---
Created attachment 114852
  -- https://bugs.documentfoundation.org/attachment.cgi?id=114852action=edit
testcase for bug 48381

An ODS document with 2 sheets :
 one is invoice with columns (invoice_id, client_id, invoice_amount)
 two is client with columns (client_id, total_invoiced)

There are 100 invoice rows and 300 client rows both filled with random
generated test data.

Where the formula in client.B2 is : 
=somme.si(invoice.B$2:B$1000; A2 ; invoice.C$2:C$1000)
(which function would likely be SUM.IF in english)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48381] Pasting a formula in a full column appears to hang Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48381

clem clement.marsh...@free.fr changed:

   What|Removed |Added

 Status|NEEDINFO|NEW

--- Comment #5 from clem clement.marsh...@free.fr ---
To reproduce :

- open testcase
- select client.B2
- Copy
- select client.B (whole column)
- remove client.B1 (column title) from selection
- paste

Saving the resulting file is equally long.

This teaches me that pasting complicated formulae into 1 million cells could
have you wait a little time.

However, LibreOffice aiming to be a trouble free experience for it's users
might want to deal with long calculations in an appropriate manner that lets
the user know what happens and eventually cancel the process if it takes too
long.

In that instance, there are no need to calculate 1M cells, just 300, and that
is done in a snap.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48381] Pasting a formula in a full column appears to hang Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48381

--- Comment #4 from clem clement.marsh...@free.fr ---
Created attachment 114853
  -- https://bugs.documentfoundation.org/attachment.cgi?id=114853action=edit
Mac OS stack trace sample for bug 48381

Output of the Apple /usr/bin/sample analysis tool showing 3 seconds of sampling
every 1ms entirely within the duration of the hung interface.

The interesting parts are where the statistics of where the program spends most
of it's time are supplied : search for these :
- Total number in stack
- Sort by top of stack

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48381] Pasting a formula in a full column appears to hang Calc

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=48381

--- Comment #6 from clem clement.marsh...@free.fr ---
And yes, it persists in 4.4.

I have reproduced them today 2015-04-17 in Version: 4.4.1.2
Build ID: 45e2de17089c24a1fa810c8f975a7171ba4cd432
Locale : fr_

I hope it helps. I have software development training but no practice in 20
years, if there is anything I can do more, i'd be willing to help but i'm a bit
scared to dive in LO code and mess things around !

On Mac intel 64b / Yosemite / Xcode installed

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48381] Pasting a formula in a full column appears to hang Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=48381

Nino nn.l...@kflog.org changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||nn.l...@kflog.org
 Ever Confirmed|0   |1
Version|unspecified |LibO 3.5.2 Release

--- Comment #1 from Nino nn.l...@kflog.org 2012-04-20 05:53:52 PDT ---
confirmed in 3.5.2/Linux rpm/32.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 48381] Pasting a formula in a full column appears to hang Calc

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=48381

clem clement.marsh...@free.fr changed:

   What|Removed |Added

   Priority|medium  |low

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
--- You are receiving this mail because: ---
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs