https://bugs.documentfoundation.org/show_bug.cgi?id=161562
Bug ID: 161562
Summary: Sluggish behaviour in large(ish) spreadsheets
Product: LibreOffice
Version: 24.2.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Description:
I have previously reported (couple of years ago?) this and was given a
workaround of ctrl-M. I could then apply my formatting and it wpould be OK for
a while. Now as soon as I start formatting again the sluggish behaviour is
immediate.
Background: I proofread/verify files which come to me in csv format. I load
them into ods format and then format them by changing font to courier new,
resize columns, freeze the first two rows. Then as I check blocks of rows I
change font colour to green to bookmark my progress. The files can contain 3500
to 6500 rows.
Usually the sluggishness sets in around 1000 rows in, obvious because scrolling
is not smooth and a Save takes a minute or more to complete. Auto save is ON
which might be relavent to the scrolling? But it is now happening almost as
soon as I start formatting away from the default font and layout. Behaviour is
better if I don't change font, but I find it easier to use a sans-serif one.
I am using vn 24.2.3.2, installed in the last week, but the behaviour has been
there across previous versions too (I was previously using vn 7.x.x) on Windows
11.
Steps to Reproduce:
1. open .csv in .ods format
2. change default font to courier new across all rows (click top left to select
all), freeze top 2 rows, resize columns to better fit the data and show max
cols on a 15" laptop screen
3. scroll through data, select last in a group of rows change font colour to
green.
4. auto save is ON, but manually save approx every 25 rows.
Actual Results:
Saving and scrolling is intially quick and smooth but quickly deteriorates.
Expected Results:
Saving and scrolling should be fast and not lumpy.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (11)
OS is 64bit: yes
Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba
CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
