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.
[Solved] Data entry pauses after every click
[Solved] Data entry pauses after every click
Last edited by Hagar Delest on Mon Sep 20, 2021 6:30 pm, edited 1 time in total.
Reason: tagged solved.
Reason: tagged solved.
Libre Office 7.0.4.2 on Windows 10 Home 64 bit
Re: data entry pauses after every click
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.
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.
Re: data entry pauses after every click
The Calc is NOT a text editor.Some of the individual text fields are up to 4KB in size.
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.
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.
Re: Data entry pauses after every click
RUSSELB:
Thanks, but that does not fix the problem.
zizi64:
Understood, I store no more than a long paragraph in a cell.
Thanks
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
Re: Data entry pauses after every click
You are misusing a calculator as an inadequate database surrogate.I have a large (30 KB and growing) spreadsheet with only text fields, and with no formulas.
Select all cells (Ctrl+A)... entered data including text copied from websites ...
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Data entry pauses after every click
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
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
Re: Data entry pauses after every click
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.What are "objects", and how did they get in my spreadsheet?
(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.
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.
Re: Data entry pauses after every click
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Data entry pauses after every click
I understand. Thank you both. Problem solved.
Libre Office 7.0.4.2 on Windows 10 Home 64 bit