Bug 58653

Summary: : Writing content in a cell and passing to adiacent cell is extremely slow
Product: LibreOffice Reporter: vimot2
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: mariosv, stgohi-lobugs
Version: 3.6.4.3 release   
Hardware: Other   
OS: Linux (All)   
Whiteboard: BSA
i915 platform: i915 features:
Attachments: The file with the issue

Description vimot2 2012-12-22 16:18:22 UTC
Created attachment 71983 [details]
The file with the issue

Problem description: 
The spreadsheet is composed of 6 sheets. One of them, named "2012" reports the daily amount of Photovoltaic production of my PV plant.
For each day I report the kWs and the external Temperature. All the cells have conditional formatting so that the max an min production and the max and min temperature cells are colored.
Aside the table, there is a chart representing the daily production in kWh.
From a couple of weeks, inserting the new data of production and temperature require a lot of time.

Steps to reproduce:
1. try to insert a production value and a temperature value in one of the blank cells of the table.
2. move the cursor to one of the adiacent cells
3. You wil see that Calc freezes for some time.

Current behavior:
Calc freezes for long time when simply you enter a value in a cell
Expected behavior:

NOTES: I have search the internet for issues like this. As suggested in some forum, I have tried to eliminate all the objects in the sheet (the chart), but the issue remain.
I have also tried to save the file in other formats (even .ods) obtaining no differences.
              
Operating System: Ubuntu
Version: 3.6.4.3 release
Comment 1 m.a.riosv 2012-12-22 22:43:17 UTC
Hi vimot2, thanks for reporting.

Confirmed.
Win7x64 Ultimate
Version 3.6.4.3 (Build ID: 2ef5aff)
Version 4.0.0.0.beta2 (Build ID: 4104d660979c57e1160b5135634f732918460a0)

Seems to works right deleting all conditional formatting.

I think is the same/similar issue as this bugs:

https://bugs.freedesktop.org/show_bug.cgi?id=49764
RESOLVED FIXED

https://bugs.freedesktop.org/show_bug.cgi?id=57028
NEW
Comment 2 A (Andy) 2014-10-18 20:04:31 UTC
I tested it with LO 4.3.2.2 (Win 8.1).

I can only see a very small delay, but I would say it is no real freeze, but of course LO could be faster.

Was this the issue you had reported or was your issue maybe already resolved in the meantime?  Or is this a Linux only issue?

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.