Bug 158604 - UI: Warning when applying Autoformat > Styles for a large (empty) range
Summary: UI: Warning when applying Autoformat > Styles for a large (empty) range
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.0.0 alpha1+
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Table-AutoFormat
  Show dependency treegraph
 
Reported: 2023-12-08 19:31 UTC by Telesto
Modified: 2024-07-09 05:44 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2023-12-08 19:31:17 UTC
Description:
UI: Warning when applying Autoformat > Styles to extreme range 

Steps to Reproduce:
1. Open Calc
2. Left click on column A and drag until S
3. Format -> Autoformat Styles -> Choose some box list type

Actual Results:
Observations: 
* It's easy to select an idiotic range (by incident)
* If you apply autoformat -> styles LibreOffice will Freeze/hang for long time

Expected Results:
* Do a suggestion for proper range?
* Or a warning about extend of the selection?
* something else.. 




Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 24.2.0.0.alpha1+ (X86_64) / LibreOffice Community
Build ID: a9ad36ae46ff76c0d59b0d170314fdd3a9ee5d35
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL threaded
Comment 1 Eyal Rozenberg 2023-12-08 20:16:10 UTC
So, why am I CCed? :-)
Comment 2 Telesto 2023-12-08 21:44:10 UTC
(In reply to Eyal Rozenberg from comment #1)
> So, why am I CCed? :-)

Well mostly because of your idea's/opinions/suggestions on plenty of topics and the ability of expressing those clearly. Or put it differently I appreciate your view.. But well it's totally voluntary.. If so say, I'm uninterested, also fine.

But well I should probably added the question: options? instead of blank cc
Comment 3 Eyal Rozenberg 2023-12-08 22:22:16 UTC
> If you apply autoformat -> styles LibreOffice will Freeze/hang for long time

This is the problem. Why can't we interrupt such operations while they're ongoing?

There are are operations which could potentially take a long time; like - parsing a huge input CSV for example.
Comment 4 Heiko Tietze 2023-12-11 10:43:13 UTC
In general, lengthy operations should have a feedback (hourglass, throbber, progressbar, etc.) or run in the background (with the opportunity to cancel). Just telling the user that something might have negative consequences is not actionable. For example, on some systems your example could take hours to finish and on other some seconds. And it's very difficult to predict.
Comment 5 Eyal Rozenberg 2023-12-11 10:56:21 UTC
(In reply to Heiko Tietze from comment #4)
> In general, lengthy operations should have a feedback (hourglass, throbber,
> progressbar, etc.)

There might already even be a progress indication in this case, although this must be verified of course. The thing is, we have to let the user understand that the overall time might be exceedingly high. And, like I said, let the user abort.