[Solved] Data entry pauses after every click

Discuss the spreadsheet application
Locked
manoman
Posts: 62
Joined: Sat Aug 25, 2018 7:17 pm

[Solved] Data entry pauses after every click

Post by manoman »

I have a large (30 KB and growing) spreadsheet with only text fields, and with no formulas. Some of the individual text fields are up to 4KB in size. I created the spreadsheet, entered data including text copied from websites, saved the spreadsheet, then re-opened it and entered more data. I click on fields to view or enter data and the box opens instantly. All went well until I selected all fields and changed the font name and size. Right after that, every time I click on a field to view or enter data, there is a 4 second pause while the cursor turns to an hourglass and the green progress bar at the bottom of the screen shoots right and left. This slows my work. Oddly, if I save, close, and reopen the spreadsheet, it returns to instant action.

It seems to me to be something similar to a recalculation process after each click. Is there a way to stop this in order to speed up data entry, and only turn it on when I need recalculation (or whatever it is)?

Thanks.
Last edited by Hagar Delest on Mon Sep 20, 2021 6:30 pm, edited 1 time in total.
Reason: tagged solved.
Libre Office 7.0.4.2 on Windows 10 Home 64 bit
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: data entry pauses after every click

Post by RusselB »

Options to try: Automatic Spell Checking (Shift +F7), Tools -> Autoinput
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: data entry pauses after every click

Post by Zizi64 »

Some of the individual text fields are up to 4KB in size.
The Calc is NOT a text editor.

Although the number of characters that can be stored in one cell has a very high value (in LibreOffice), it is not advisable to store a short story or novel in a single cell.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
manoman
Posts: 62
Joined: Sat Aug 25, 2018 7:17 pm

Re: Data entry pauses after every click

Post by manoman »

RUSSELB:
Thanks, but that does not fix the problem.

zizi64:
Understood, I store no more than a long paragraph in a cell.

Thanks
Libre Office 7.0.4.2 on Windows 10 Home 64 bit
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Data entry pauses after every click

Post by Villeroy »

I have a large (30 KB and growing) spreadsheet with only text fields, and with no formulas.
You are misusing a calculator as an inadequate database surrogate.
... entered data including text copied from websites ...
Select all cells (Ctrl+A)
menu:Sheet>Clear Cells...
Deselect everything, select "Objects".
[OK]
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
manoman
Posts: 62
Joined: Sat Aug 25, 2018 7:17 pm

Re: Data entry pauses after every click

Post by manoman »

VILLEROY:
Select all cells (Ctrl+A)
menu:Sheet>Clear Cells...
Deselect everything, select "Objects".
[OK]

That seems to have fixed the problem. What are "objects", and how did they get in my spreadsheet?

Thanks for your help
Libre Office 7.0.4.2 on Windows 10 Home 64 bit
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Data entry pauses after every click

Post by Zizi64 »

What are "objects", and how did they get in my spreadsheet?
When you paste some data from a foreign source into your document (even if it is a text- or spreadsheet document) by usage the "normal" paste function, it will be pasted many unwanted formatting properties and visible/unvisible objects too.

(Objects: some graphical elements, and/or control objects what work in a website, but they are unnecessary and harmful in a spreadsheet document.)

Use the "Paste special - Unformatted text" option for pasting text from the foreign sources.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Data entry pauses after every click

Post by Villeroy »

All that heavy dark matter copied from the internet calling home.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
manoman
Posts: 62
Joined: Sat Aug 25, 2018 7:17 pm

Re: Data entry pauses after every click

Post by manoman »

I understand. Thank you both. Problem solved.
Libre Office 7.0.4.2 on Windows 10 Home 64 bit
Locked