https://bugs.documentfoundation.org/show_bug.cgi?id=155891
Bug ID: 155891
Summary: Add an option to DISABLE direct data entry to prevent
accidental data modification
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Hi.
Before you say I can solve my issue with protect cell/sheet commands, or by
building a form, or by switching to database program, please, understand, NONE
of that answers my need, for my work REQUIRES the use of Calc (or any
spreadsheet like program) as UI for INSTANT data entry with complex FORMULAS
and SORT/FILTER functionality to allow for on-the-fly analysis while being on a
really tight time constraint.
Okay, so, currently if you want to enter data to a cell you just type in
numbers and text and hit enter or move the cursor with an arrow key etc.
This is standard, because it is quick, convenient, and not a problem in 99% of
cases, until you get to a place, like me, where you have a large amount of data
to enter and AT THE SAME TIME you have to process it, analyze it (by sorting,
filtering, sum and average formulas etc.) and sometimes modify what's already
there on the screen, while also constantly shuffling paper documents spanning
your entire desk.
While focused on that, you will always end up losing track of your keyboard and
mouse whereabouts, especially when sifting through documents, moving them
around you will eventually hit a key by accident or even click and drag mouse
cursor a bit (it DOES happen), which easily goes unnoticed if your eyes are not
glued to the screen at all times (which they are not), resulting in unwanted
data manipulation or deletion.
Then after a while your sums stop adding up, and your averages are off, and you
start wondering why, and of course, you then question all the mental labor
you've just gone through that last hours or so. Then you have to waste time
checking your data again, and again. It's torture.
To prevent this, I need an option in Calc to ignore ANY KEYSTROKES and ANY
MOUSE CLICKS/MOVEMENT related to cell / cell CONTENT manipulation, UNLESS I
SPECIFICALLY ALLOW IT by pressing F2 (or ENTER, if that option is enabled in
the general settings), which enables cell edit mode.
It would be optimal if Calc sounded a bell when such an accidental change is
attempted and blocked.
Mind you, I do NOT want to disable my entire keyboard or Calc UI, for I still
need to sort and filter the existing data. I just want NOT to mess up the
things that are already there, but still have the ability to quickly change it.
Therefor I don't want to use protect cell or sheet, because I'd have to
constantly switch it on and off to allow for sorting/data entry.
Thank you.
Steps to Reproduce:
1. Open new document, select A1.
2. Type in "ABC", hit enter.
3. Select A1 again and type in "XYZ", hit right arrow key.
Actual Results:
3. Cell edit mode is enabled, "ABC" in A1 is replaced by "XYZ", then the change
is commited and B1 is selected.
Expected Results:
3. Cell edit mode is NOT enabled and "XYZ" input is IGNORED, then B1 is
selected.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Alternatively, to replace "ABC" in A1 with "XYZ":
3. Hit F2 (or ENTER if you enabled that in general options) to manually enable
cell edit mode.
4. Type in "XYZ", hit enter or any arrow key.
--
You are receiving this mail because:
You are the assignee for the bug.
