[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2022-08-08 Thread Bug Watch Updater
** Changed in: df-libreoffice
   Status: Confirmed => Fix Released

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in LibreOffice:
  Fix Released
Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (<2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1034999/+subscriptions


-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2022-08-02 Thread Bug Watch Updater
Launchpad has imported 38 comments from the remote bug at
https://bugs.documentfoundation.org/show_bug.cgi?id=108560.

If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.


On 2017-06-16T00:13:18+00:00 Francewhoa+bugs-documentfoundation-org wrote:

Created attachment 134057
calc_spreadsheet---after---Slow_Edit_Large_Cell---Francewhoa---2017-06-15.ods

Hi LibreOffice enthusiasts :)


Challenge summary:
Using LibreOffice (LO) Calc, adding large amount of text to a text cell result 
in Calc hangs. Hang ranges from slow to unusable Calc. Same challenge with 
opening large cells.


Steps to reproduce challenge:
1. Install fresh LibreOffice 5.2.7.2

2. Create a fresh Calc spreadsheet. Find attached spreadsheet titled
"calc_spreadsheet---before---Slow_Edit_Large_Cell---Francewhoa---
2017-06-15.ods"

3. Paste into a cell any text with the following minimum values:
...• Lines: 235
...• Words: 11,604
...• Characters with space: 78,936
...• Calculations: None
...• Formatting on cell: No advanced formatting
For spreadsheet example, find attached file titled 
"calc_spreadsheet---after---Slow_Edit_Large_Cell---Francewhoa---2017-06-15.ods"

4. LibreOffice hang for ~30 seconds. One CPU is running at 100%. After
that hang the text is pasted.

5. Double click on that cell to open it. LibreOffice hangs again for
another ~30 seconds. And so on.

The amount of text in the cell is directly correlated to the length of
time required to open or edit the cell. So 470 lines is roughly double
the hang time than 235 lines.


Expected outcome:
• Expected result is the text should be added to the text cell within ~1 
second. Not ~30 seconds. 30 seconds is very fast if we need to do one operation 
within ~one day. But the issue is that we need to do multiple operations within 
1 minute. Then we need to do that multiple time per day, week, year. For 
example when we need to do 10 to 20 copy-paste operations per minute, the total 
freeze time range from 5 to 10 minutes. Which is too slow. Another example is 
with 100 to 200 copy-paste, which result in a total freeze ranges 50 to 100 
minutes. Again too slow. There is something slowing down both the copy-paste 
process of a large cell and opening a large cell. It's unclear what is causing 
that.


What we tried that was effective:
• Use LibreOffice 4.2. Instead of 5.2.7.2. This issue can not be reproduce on 
LibreOffice 4.2.
• Using 5.2.7.2, brake down the large cell content into multiple small cells. 
But that's not usable, as I need to add large amount of text to large amount of 
cells, and sheets.


What I tried that was ineffective:
• "Format" menu > "Cell" option > "Numbers" > Text 
• "Format" menu > "Clear Direct Formatting" option 
• Increase memory at “Tools > LibreOffice > Memory“
• Force LO to use the lastest installed Java 1.8 at “Tools > Options > 
LibreOffice > Advanced > Expert Configuration”
• Close the LO sidebar
• "Format" menu > "Cell" option > "Alignment" > unchecked "Wrap text 
automatically" 


Suggested fix:
• Allow users to add large amount of text without triggering whatever is 
triggering intensive CPU usage. Assuming the user is adding simple text and 
without complex formatting and without any calculation. No cell validation is 
requested, but maybe somehow LO is trying to validate the full content of the 
cell. If so, how about allowing the user to deactivate such automated 
validation per cell, per sheet, per spreadsheet, per LO global setting?


LibreOffice:
• Version: 5.2.7.2
• Build ID: 1:5.2.7-1~bpo8+1
• CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: gtk3;
• Locale: en-CA (en_CA.utf8); Calc: group
• Java 1.8.0_131 Oracle Corporation

System:
• Base: Debian 8.8 Jessie, 64-bit
• Gnome: 3.14.1
• Kernel: 4.9.0-0.bpo.3-amd64 #1 SMP Debian 4.9.25-1~bpo8+1 (2017-05-19) x86_64 
GNU/Linux


Hardware:
• Ram: 31GB. Only LibreOffice is open and active.
• Processor: Intel Core i7 @ 3.10 GHz
• CPU: 8


• Similar challenges:
...• https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999
...• 
https://askubuntu.com/questions/925383/libreoffice-calc-is-slowing-down-when-working-with-big-cells
...• 
https://ask.libreoffice.org/en/question/75074/libreoffice-5204-unbearably-slow-on-ubuntu-1404/

I would be happy to contribute testing and documentation if needed

Let me know if you have any questions or need anything else

Cheers,

Francewhoa

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/comments/15


On 2017-06-16T00:21:23+00:00 Francewhoa+bugs-documentfoundation-org wrote:

Created attachment 134058
calc_spreadsheet---before---Slow_Edit_Large_Cell---Francewhoa---2017-06-15.ods

Reply at:

[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2022-07-30 Thread Rico Tzschichholz
** Also affects: df-libreoffice via
   https://bugs.documentfoundation.org/show_bug.cgi?id=108560
   Importance: Unknown
   Status: Unknown

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in LibreOffice:
  Unknown
Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (<2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1034999/+subscriptions


-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2022-07-30 Thread Adolfo Jayme Barrientos
** Changed in: libreoffice (Ubuntu)
   Importance: Undecided => Medium

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (<2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions


-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2017-06-23 Thread Olivier Tilloy
Confirmed that this is still happening with libreoffice 5.3.3-0ubuntu1 on 
artful.
Pasting the text from comment #18 in a single cell takes 30 seconds on my 
machine.

@madbiologist: the commonality of that use case is not really the point
(although it might influence the importance of the bug report). People
use spreadsheets in lots of creative ways and it should never take that
long to paste some text, regardless of its size (the sample text in
comment #18 is only 11604 words, it's not even that big).

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (<2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2017-06-19 Thread madbiologist
Oops, I comment #20 should say that I tested with LibreOffice 5.3.1.2.

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (<2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2017-06-19 Thread madbiologist
I can reproduce this on LibreOffice 5.2.7.2 with the file from comment
18 when I paste the contents of that file into a single cell.  In fact
the first time I attempted to paste, calc crashed and then it's document
recovery dialog appeared.  The paste worked on the second attempt, but
was very slow.  Attempting to edit the text in the cell was also very
slow.

However this doesn't seem like a common use case for a spreadsheet.  I
would expect that text like this was stored and edited in a writer
document.  Do you mind if I ask why you want to put this large amount of
text into a spreadsheet cell?

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (<2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2017-06-17 Thread Francewhoa
To narrow down the source(s) of the issue I further tested. Confirming
the lag is both correlated with the number of lines and exponential with
the number of lines. With these latest tests the lag per action ranges
from ~2 seconds with 129 lines to more than 13+ minutes lag with 940+
lines, and so on and exponential.

Test results and steps to reproduce in comment 12 at
https://bugs.documentfoundation.org/show_bug.cgi?id=108560#c12

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (<2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2017-06-17 Thread Francewhoa
Here are more test results with LibreOffice (LO) using the attached file
"lorem_ipsum---Francewhoa---2017-06-15.txt"

• With LO 4.2 Francewhoa was NOT able to reproduce
• With LO 5.0.0.5 Telesto was NOT able to reproduce
• With LO 5.0.6.3 Telesto was ABLE to reproduce
• With LO 5.2.7.2 Francewhoa was ABLE to reproduce 
• With LO 6.0.0.0.alpha0+ Telesto was ABLE to reproduce 

So it seems something was introduce between 5.0.0.5 and 5.0.6.3. Which
in turn cause the slow performance.

The main difference between the files attached in comment #1 above and
the file attached to this comment #18 is their length. 129 lines compare
to 235 lines. So somehow the lag is triggered when the cell content is
between 130 and 235 lines.

Telesto's test results are in comment #4 at
https://bugs.documentfoundation.org/show_bug.cgi?id=108560#c4

** Attachment added: "lorem_ipsum---Francewhoa---2017-06-15.txt"
   
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+attachment/4897729/+files/lorem_ipsum---Francewhoa---2017-06-15.txt

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (<2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2017-06-17 Thread Francewhoa
Thanks for your testing madbiologist :) Same here I can not reproduce
with the file attached in comment #1 above and LibreOffice 5.2.7.2.

I'll post another comment shortly with another file. Which both me and
Telestro were able to reproduce with.

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (<2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2017-06-17 Thread madbiologist
I can't reproduce this with LibreOffice 5.3.1.2 on Ubuntu 17.04 64 bit
using the file attached to comment #1

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (<2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2017-06-15 Thread Francewhoa
I created a bug report using the official LibreOffice ticketing system
at https://bugs.documentfoundation.org/show_bug.cgi?id=108560

Feel really free to use either ticketing systems

If you are able to reproduce that bug, to speed up a fix, I suggest for
all to post a comment to the LibreOffice ticketing system. To let them
know this bug is confirmed.

Any volunteers for a patch? I would be happy to contribute testing and
documentation if needed. Again, to get a faster response I suggest to
reply at https://bugs.documentfoundation.org/show_bug.cgi?id=108560

** Bug watch added: Document Foundation Bugzilla #108560
   https://bugs.documentfoundation.org/show_bug.cgi?id=108560

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (<2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2017-06-15 Thread Francewhoa
Confirming this bug is still present with latest LibreOffice stable
version

The amount of text in the cell is directly correlated to the length of
time required to open or edit the cell.

Steps to reproduce:
1. Install fresh LibreOffice
2. Create a fresh calc spreadsheet
3. Paste into a cell any text with the following minimum values:
...• Lines: 500
...• Words: 4,000
...• Calculations: None
...• Formatting on cell: None

4. LibreOffice hang. After a few minutes the text is pasted.
5. Double click on that cell to open it. LibreOffice hang again. And so on.

Using:
• LibreOffice version: 5.2.7.2
• LibreOffice build ID: 1:5.2.7-1~bpo8+1
• LibreOffice CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: 
gtk3; 
• LibreOffice Locale: en-CA (en_CA.utf8); Calc: group
• 32GB ram
• Java 1.8.0_131 Oracle Corporation
• Gnome: 3.14.1
• Kernel: 4.9.0-0.bpo.3-amd64 #1 SMP Debian 4.9.25-1~bpo8+1 (2017-05-19) x86_64 
GNU/Linux
• Base: Debian 8.8 Jessie, 64-bit

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (<2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2017-06-15 Thread Francewhoa
** Changed in: libreoffice (Ubuntu)
   Status: Expired => Confirmed

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (<2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2014-11-10 Thread Launchpad Bug Tracker
[Expired for libreoffice (Ubuntu) because there has been no activity for
60 days.]

** Changed in: libreoffice (Ubuntu)
   Status: Incomplete = Expired

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in “libreoffice” package in Ubuntu:
  Expired

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 Maverick Meerkat - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2014-09-11 Thread madbiologist
Does this still occur on Ubuntu 14.04 Trusty Tahr with Libreoffice
4.2.6.3-0ubuntu1 ?  Calc had a lot of performance improvements in
Libreoffice 4.2 - see
https://wiki.documentfoundation.org/ReleaseNotes/4.2#Performance

The currently under development Ubuntu 14.10 Utopic Unicorn has the
recently released Libreoffice 4.3.

** Changed in: libreoffice (Ubuntu)
   Status: Confirmed = Incomplete

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in “libreoffice” package in Ubuntu:
  Incomplete

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 Maverick Meerkat - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2014-05-26 Thread Francewhoa
Confirming this issue, using:
* LibreOffice version 4.1.4, 64 bits
* Kernel Linux 3.2.0-4-amd64
* GNOME 3.4.2

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in “libreoffice” package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 Maverick Meerkat - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2014-05-26 Thread Francewhoa
I found a temporary workaround that improved the performance from 40
seconds to 1 second or less in my case, read more at
http://ask.libreoffice.org/en/question/32972/why-the-super-slow-saves-
in-calc/?answer=34636#post-id-34636

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in “libreoffice” package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 Maverick Meerkat - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2013-10-23 Thread Ivan Williams
I can confirm this bug:

Acer emachine E730G
Win7 Home Premium SP1
Core i3 CPU
4Gig ram
ATI Readon HD5470

File size 360kb 
LibreOffice 4.1.1.2
Calc .ods filetype
Tabs (5)
Max rows per tab 8849
Max Columns per tab 8
No formulas (flat data)
Some fomatting, cell colour etc.

Time to save 65 seconds!!

2 CPU cores maintan approx 50%

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in “libreoffice” package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 Maverick Meerkat - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2013-10-18 Thread Christopher M. Penalver
Mihai Dontu, please file a new report and feel free to subscribe me to it:
ubuntu-bug libreoffice-calc

** Attachment removed: perf top output
   
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+attachment/3871804/+files/localc-4.1.2.3.txt

** Tags added: regression-release

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in “libreoffice” package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 Maverick Meerkat - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2013-10-10 Thread Mihai Dontu
I have the same issue with an XLSX document of ~900K (uncompressed:
~14M), which is opened in ~5min. I have attached the output of 'perf top
-K -p soffice.bin-pid'. M$'s Excel opens it in ~5s.


** Attachment added: perf top output
   
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+attachment/3871804/+files/localc-4.1.2.3.txt

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in “libreoffice” package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 Maverick Meerkat - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2013-05-28 Thread Steve Magoun
This is reproducible in raring (13.04) with libreoffice
1:4.0.2-0ubuntu1. I used the sample document attached to this bug.

** Changed in: libreoffice (Ubuntu)
   Status: Incomplete = Confirmed

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in “libreoffice” package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 Maverick Meerkat - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2013-05-26 Thread Christopher M. Penalver
Steve Magoun, thank you for reporting this and helping make Ubuntu
better. This is unreproducible in Xubuntu. Could you please test for
this in Raring via http://releases.ubuntu.com/raring/ and/or Saucy via
http://cdimage.ubuntu.com/daily-live/current/ and report the results?

lsb_release -rd
Description:Ubuntu 13.04
Release:13.04

apt-cache policy libreoffice-writer
libreoffice-writer:
  Installed: 1:4.0.2-0ubuntu1
  Candidate: 1:4.0.2-0ubuntu1
  Version table:
 *** 1:4.0.2-0ubuntu1 0
500 http://archive.ubuntu.com/ubuntu/ raring/main i386 Packages
100 /var/lib/dpkg/status

** Changed in: libreoffice (Ubuntu)
   Status: Confirmed = Incomplete

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in “libreoffice” package in Ubuntu:
  Incomplete

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 Maverick Meerkat - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2013-03-05 Thread Johannes Gowin
Still present in Libreoffice 4.0 in Quantal with all the latest updates.
Gnumeric in comparison is blazing fast with this task.

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in “libreoffice” package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 Maverick Meerkat - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2012-08-09 Thread Steve Magoun
** Attachment added: libreoffice-large-cell-test.ods
   
https://bugs.launchpad.net/bugs/1034999/+attachment/3254826/+files/libreoffice-large-cell-test.ods

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in “libreoffice” package in Ubuntu:
  New

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 Maverick Meerkat - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2012-08-09 Thread Launchpad Bug Tracker
Status changed to 'Confirmed' because the bug affects multiple users.

** Changed in: libreoffice (Ubuntu)
   Status: New = Confirmed

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1034999

Title:
  libreoffice-calc very slow to open/save documents with large cell
  contents

Status in “libreoffice” package in Ubuntu:
  Confirmed

Bug description:
  Libreoffice-calc 3.6 takes a long time (30sec to minutes) to open/save
  spreadsheets containing cells with a lot of content. This is a
  regression from libreoffice 3.5 in 12.04 (tested with
  1:3.5.4-0ubuntu1)

  To reproduce:
  1) Open the attached spreadsheet, which contains 1 cell with ~4k characters 
in it

  Expected results:
  Spreadsheet opens quickly (2sec on my 2.4Ghz Core2Duo w/ SSD)

  Actual results:
  Libreoffice splash screen shows, libreoffice window is displayed as a gray 
rectangle with no content, and libreoffice window then becomes unresponsive. 
CPU usage is at 100% on one core. The system stays in this state for ~30sec. 
The document eventually opens and libreoffice functions normally.

  Saving documents with lots of data in a cell takes just as long as
  opening/reading those documents, with similar symptoms - libreoffice
  becomes unresponsive, one CPU core is at full utilization, etc.

  The amount of text in the cell is directly correlated to the length of
  time required to open/save the doc.

  ProblemType: Bug
  DistroRelease: Ubuntu 12.10
  Package: libreoffice-calc 1:3.6.0~rc4-0ubuntu2
  ProcVersionSignature: Ubuntu 3.5.0-8.8-generic 3.5.0
  Uname: Linux 3.5.0-8-generic x86_64
  ApportVersion: 2.4-0ubuntu6
  Architecture: amd64
  Date: Thu Aug  9 13:20:27 2012
  InstallationMedia: Ubuntu 10.10 Maverick Meerkat - Beta amd64 (20100901.1)
  ProcEnviron:
   TERM=xterm
   PATH=(custom, user)
   LANG=en_US.UTF-8
   SHELL=/bin/bash
  SourcePackage: libreoffice
  UpgradeStatus: Upgraded to quantal on 2012-08-07 (2 days ago)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1034999/+subscriptions

-- 
Mailing list: https://launchpad.net/~desktop-packages
Post to : desktop-packages@lists.launchpad.net
Unsubscribe : https://launchpad.net/~desktop-packages
More help   : https://help.launchpad.net/ListHelp


[Desktop-packages] [Bug 1034999] Re: libreoffice-calc very slow to open/save documents with large cell contents

2012-08-09 Thread Steve Magoun
This might be limited to .ods files - .xlsx files with the same content
do not suffer the problem. A quick check of the soffice.bin shows that
.ods import is spending all its time in XML_ParseBuffer() and its
children. Sample stack trace:

(gdb) bt
#0  0x7f8c7044868a in ?? ()
   from /usr/lib/libreoffice/program/../program/libeditenglo.so
#1  0x7f8c70449d33 in ?? ()
   from /usr/lib/libreoffice/program/../program/libeditenglo.so
#2  0x7f8c70457c74 in ?? ()
   from /usr/lib/libreoffice/program/../program/libeditenglo.so
#3  0x7f8c704583cc in ?? ()
   from /usr/lib/libreoffice/program/../program/libeditenglo.so
#4  0x7f8c7045c2f4 in ?? ()
   from /usr/lib/libreoffice/program/../program/libeditenglo.so
#5  0x7f8c7041877c in EditEngine::SetUpdateMode(unsigned char) ()
   from /usr/lib/libreoffice/program/../program/libeditenglo.so
#6  0x7f8c71481187 in ?? ()
   from /usr/lib/libreoffice/program/../program/libsclo.so
#7  0x7f8c70503ba9 in 
SvxUnoTextCursor::gotoRange(com::sun::star::uno::Referencecom::sun::star::text::XTextRange
 const, unsigned char) ()
   from /usr/lib/libreoffice/program/../program/libeditenglo.so
#8  0x7f8c72734f12 in ?? ()
   from /usr/lib/libreoffice/program/../program/libxolo.so
#9  0x7f8c727366d9 in ?? ()
   from /usr/lib/libreoffice/program/../program/libxolo.so
#10 0x7f8c72533fe3 in SvXMLImport::endElement(rtl::OUString const) ()
   from /usr/lib/libreoffice/program/../program/libxolo.so
---Type return to continue, or q return to quit---
#11 0x7f8c721f236d in ?? ()
   from /usr/lib/libreoffice/program/../program/expwrap.uno.so
#12 0x7f8c92714454 in ?? () from /lib/x86_64-linux-gnu/libexpat.so.1
#13 0x7f8c9271554e in ?? () from /lib/x86_64-linux-gnu/libexpat.so.1
#14 0x7f8c9271985d in XML_ParseBuffer ()
   from /lib/x86_64-linux-gnu/libexpat.so.1
#15 0x7f8c721f0c16 in ?? ()
   from /usr/lib/libreoffice/program/../program/expwrap.uno.so
#16 0x7f8c721f49ee in ?? ()
   from /usr/lib/libreoffice/program/../program/expwrap.uno.so
#17 0x7f8c711d8c9d in ?? ()
   from /usr/lib/libreoffice/program/../program/libsclo.so
#18 0x7f8c711dac87 in ?? ()
   from /usr/lib/libreoffice/program/../program/libsclo.so
#19 0x7f8c7129f502 in ?? ()
   from /usr/lib/libreoffice/program/../program/libsclo.so
#20 0x7f8c7129f8bd in ScDocShell::Load(SfxMedium) ()
   from /usr/lib/libreoffice/program/../program/libsclo.so
#21 0x7f8c9ac53d0d in SfxObjectShell::LoadOwnFormat(SfxMedium) ()
   from /usr/lib/libreoffice/program/libsfxlo.so
#22 0x7f8c9ac60c45 in SfxObjectShell::DoLoad(SfxMedium*) ()
   from /usr/lib/libreoffice/program/libsfxlo.so
#23 0x7f8c9aca3d8d in 
SfxBaseModel::load(com::sun::star::uno::Sequencecom::---Type return to 
continue, or q return to quit---
sun::star::beans::PropertyValue const) ()
   from /usr/lib/libreoffice/program/libsfxlo.so
#24 0x7f8c9acdd520 in ?? () from /usr/lib/libreoffice/program/libsfxlo.so
#25 0x7f8c7afc76b3 in ?? ()
   from /usr/lib/libreoffice/program/../program/libfwklo.so
#26 0x7f8c7afc8af8 in ?? ()
   from /usr/lib/libreoffice/program/../program/libfwklo.so
#27 0x7f8c7af4134e in ?? ()
   from /usr/lib/libreoffice/program/../program/libfwklo.so
#28 0x7f8c7af41838 in ?? ()
   from /usr/lib/libreoffice/program/../program/libfwklo.so
#29 0x7f8c9bc4ff94 in 
comphelper::SynchronousDispatch::dispatch(com::sun::star::uno::Referencecom::sun::star::uno::XInterface
 const, rtl::OUString const, rtl::OUString const, int, 
com::sun::star::uno::Sequencecom::sun::star::beans::PropertyValue const) ()
   from /usr/lib/libreoffice/program/libcomphelpgcc3.so
#30 0x7f8c9cf0dd47 in ?? ()
   from /usr/lib/libreoffice/program/libsofficeapp.so
#31 0x7f8c9cf1b661 in ?? ()
   from /usr/lib/libreoffice/program/libsofficeapp.so
#32 0x7f8c9cef0229 in ?? ()
   from /usr/lib/libreoffice/program/libsofficeapp.so
#33 0x7f8c9cef15dc in ?? ()
---Type return to continue, or q return to quit---
   from /usr/lib/libreoffice/program/libsofficeapp.so
#34 0x7f8c98e6dd14 in ?? () from /usr/lib/libreoffice/program/libvcllo.so
#35 0x7f8c98e768bc in SalGenericDisplay::DispatchInternalEvent() ()
   from /usr/lib/libreoffice/program/libvcllo.so
#36 0x7f8c8faa975f in ?? ()
   from /usr/lib/libreoffice/program/libvclplug_gtklo.so
#37 0x7f8c8faa97d9 in ?? ()
   from /usr/lib/libreoffice/program/libvclplug_gtklo.so
#38 0x7f8c8da32c65 in g_main_context_dispatch ()
   from /lib/x86_64-linux-gnu/libglib-2.0.so.0
#39 0x7f8c8da32f98 in ?? () from /lib/x86_64-linux-gnu/libglib-2.0.so.0
#40 0x7f8c8da33054 in g_main_context_iteration ()
   from /lib/x86_64-linux-gnu/libglib-2.0.so.0
#41 0x7f8c8faa94f1 in ?? ()
   from /usr/lib/libreoffice/program/libvclplug_gtklo.so
#42 0x7f8c98be6854 in Application::Yield(bool) ()
   from /usr/lib/libreoffice/program/libvcllo.so
#43 0x7f8c98be68f7 in Application::Execute() ()
   from /usr/lib/libreoffice/program/libvcllo.so