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: 126.96.36.199.alpha0+ / 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
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.
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.
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
*** Bug 150437 has been marked as a duplicate of this bug. ***
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?".
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?
@Helko, i think this is the best solution :) if possible. Thank you for creating Libre office guys! :)