Bug 150239 - Show progress while performing lengthy operations and allow to interrupt
Summary: Show progress while performing lengthy operations and allow to interrupt
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
: 150437 (view as bug list)
Depends on:
Blocks: Cut-Copy
  Show dependency treegraph
Reported: 2022-08-02 22:39 UTC by elias estatistics
Modified: 2023-03-22 10:31 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description elias estatistics 2022-08-02 22:39:48 UTC
Selecting whole column to copy data, by accident, freeze - how to hard limit numbers of rows when running calc?

It is the 2nd process that i am driven to do reset due to such accidents. 
By accident, i select the whole row, and content is populated until the end. 
However, my system has not so many resources, and hungs. 

I would like PERMANTLY to limit the number of rows that i can manipulate in each running of Libre calc in order to minimize the risk for hungs. 

How i can to do that?
I can hide rows permantly for each run?


ps 1. you may put a warning (as an option) to prohibit someone to do such nonsenses. 
If it is able libre calc to precalcualate time / resources needed and exceed in large available resources.. then such warning must be displayed. 

ps 2. I am not able to stop the process on the fly. 
You must employ such method for a user to be able to stop immediatelly any calculation on the fly. I pressed as a maniac ESC before hungs but nothing.... 

Note that I think most users dont like reseting their machine. Me too. 

Version: / LibreOffice Community
Build ID: 566ee17c2709f9939145ddc7fbb1d61c35049321
CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: kf5 (cairo+xcb)
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded Jumbo
Comment 1 raal 2022-08-06 11:46:36 UTC
Hello, I do not understand the problem - only selecting the column is sufficient for freeze Calc? Please attach test sheet and provide steps to reproduce.
As I see, you have enabled Large spreasheets (Calc: threaded Jumbo), try to disable this option.
Comment 2 elias estatistics 2022-08-09 00:31:59 UTC
Sorry, my incovenience

Steps to reproduce 

1. Copy a single digit or number.
2. Select A1 cell to paste it with ctr+v
3. Cause u are super mutlitasking and fast person, instead of selecting a1 cell,
u select by error whole column A, and before stop your self you pressed cntr+V.
--No big problem. U will wait some minutes in a not so fast machine to copy eg. "1" into 2 million rows. 
4. BUT if u have selected to paste complicated formulas with Index+match type or 1000 string characters... and u select column A instead of cell A1, then i think the PC of most users cannot anticipate that.
5. It hangs. 

It is one of the most reasons that my PC hangs in linux. 

---To be able to stop any calculation in the fly ( a stop button somewhere?) 
---Best: Libreoffice (calc) to self-limit itself based on the free resources of system of every given time.
Comment 3 elias estatistics 2022-08-09 00:34:05 UTC
ps. i need large spreadsheats in many cases. 
It is a problem to get these on/off... but this does not solve the problem either way as you will read
Comment 4 m.a.riosv 2022-08-16 14:58:24 UTC
*** Bug 150437 has been marked as a duplicate of this bug. ***
Comment 5 Buovjaga 2023-01-27 10:12:36 UTC
This and various other reports asking for more alerts makes me think people would like some kind of "babysitting mode" where it asks quite often "do you really want to do this?".
Comment 6 Heiko Tietze 2023-01-31 07:54:52 UTC
Maybe no confirmation but a chance to interrupt long lasting operations. Could imagine a progress bar or an infobar with a cancel button. Eike, is this feasible?
Comment 7 elias estatistics 2023-01-31 13:15:00 UTC
@Helko, i think this is the best solution :) if possible. Thank you for creating Libre office guys! :)