Bug 161562

Summary:	Sluggish behaviour in large(ish) spreadsheets
Product:	LibreOffice	Reporter:	Brian P <vannerwinner>
Component:	LibreOffice	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	24.2.3.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	example of sluggish ods file

Description Brian P 2024-06-14 07:01:28 UTC

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

Comment 1 Brian P 2024-06-14 07:03:13 UTC

Created attachment 194723 [details]
example of sluggish ods file

Comment 2 m_a_riosv 2024-06-14 22:30:03 UTC

I think you are setting the font incorrectly, applying a direct format that is not the default.

If you want to set the default font, you need to edit 'Default style' and change the font there. This style is the root of all styles in the spreadsheet.

Also remember that you can modify the templates, to set default parameters when you create a new file.
https://help.libreoffice.org/latest/en-US/text/shared/guide/template_manager.html?&DbPAR=WRITER&System=WIN

Comment 3 Brian P 2024-06-15 07:14:44 UTC

Thank you for this.
I have created a template based on the formatting I need, and saved it as the Default template.
If I create a new spreadsheet the formatting is there which is great.
However, when I create a new spreadsheet by double-clicking on a .csv file, or using File-Open, the template is not applied to the data in that file.
Instead the font is LiberationSans so I'm no further forward.

I have tried creating an empty spreadsheet then copying the data in but it retains the original font.

I've searched through Help but can't find anything that relates to applying a template as a file is imported in this way.

There must be a way to do what I need to. Can you advise please?

Regards,
Brian

Comment 4 m_a_riosv 2024-06-15 22:44:56 UTC

Have you set up the template as default template?
Menu/File/Templates/Manage templates
Right-click on it and set as Default.

Comment 5 Brian P 2024-06-16 20:01:15 UTC

Yes it is the default template.
Doesn't seem to apply when opening a .csv

Comment 6 m_a_riosv 2024-06-16 20:37:27 UTC

Have you tried instead open the CSV directly, creating a new spreadsheet and use Menu/sheets/Insert sheet.. or External link.

*** This bug has been marked as a duplicate of bug 131274 ***

Comment 7 Brian P 2024-06-17 07:03:44 UTC

Have tried both of these but with same result. Default template is ignored.