Spreadsheet data entry super slow!

Discuss setup / installation issues - Add a spell checker, Language pack?
Post Reply
jhenry
Posts: 8
Joined: Wed Mar 14, 2018 5:43 pm

Spreadsheet data entry super slow!

Post by jhenry »

I just downloaded the new version 4.1.5 and the data base entry is very slow. When entering info into my data base spread sheet it takes a couple of seconds for each entry to show up in its cell. Is there a way to speed it up?

Our data base is large with over 35,000 entries which we need to access and update regularly in our business.
OpenOffice.org 3.2.1
000320m18 (build:9502)
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Spreadsheet data entry super slow!

Post by RoryOF »

Revert to the older version if it was faster. Otherwise, you may have to consider migration to a proper database system, and not use a misapplied spreadsheet.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
jhenry
Posts: 8
Joined: Wed Mar 14, 2018 5:43 pm

Re: Spreadsheet data entry super slow!

Post by jhenry »

RoryOF wrote:Revert to the older version if it was faster. Otherwise, you may have to consider migration to a proper database system, and not use a misapplied spreadsheet.
We've been using this application for years and have not had the slowdown since updating. The application also is very slow to load.

We are presently in the "openoffice calc" application. Is there a simple way to migrate our spreadsheet to the database format?
OpenOffice.org 3.2.1
000320m18 (build:9502)
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Spreadsheet data entry super slow!

Post by Zizi64 »

We've been using this application for years and have not had the slowdown since updating. The application also is very slow to load.

Try the LibreOffice Calc.
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.
jhenry
Posts: 8
Joined: Wed Mar 14, 2018 5:43 pm

Re: Spreadsheet data entry super slow!

Post by jhenry »

Zizi64 wrote:Try the LibreOffice Calc.
Thank you, I will.
OpenOffice.org 3.2.1
000320m18 (build:9502)
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Spreadsheet data entry super slow!

Post by UnklDonald418 »

Is there a simple way to migrate our spreadsheet to the database format?
While not difficult there are a few steps involved.
First you need to create a database. Since you are using it in a business application I would recommend using the approach detailed here:
[Wizard] Create a new 'split' HSQL 2.x database

On your spreadsheet make sure the first row contains names so they can be used as field names in the database.
Then select all the cells including the first row that you want to copy.
Drag the selected cells into the Tables area of the database.
That will open the Copy Table dialog in the database, where you can either accept the default table name or change it if you prefer. Also make sure the box is checked in front of Use first line as column names.
Select Next
On the Apply Columns page select all the fields you want to copy to the database
Select Next to get to the Type formatting page.
By default all the fields are copied as Text fields, but you can change that by selecting a different Field type. The most common field types on a spreadsheet are Date, Integer and Decimal. For Decimal fields be sure the change the Length to something realistic like 12 and also specify number of Decimal places.
When you select Create you will get a message asking if you want to create a primary key value, answer Yes and the database table containing your data will be created.
Any error reports are usually caused by Text strings longer than what was specified in the Copy Table dialog. If that happens delete the table from the database and start over, this time making the Text field longer on the Type formatting page.
Double click on the database table to open it. Look to make sure everything looks good then jump or scroll to the bottom of the table and take note of the value in "ID" column for the last record in the table, because you will need that “last id” value in the next operation
In the database select Tools>SQL and enter the following command. Changing the table name and last ID values

Code: Select all

ALTER TABLE "Your Table Name" ALTER COLUMN "ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (start with "Last ID value +1");
Once you have successfully Executed the SQL command the database table is ready to use.
While you can enter data into the table directly it is best to create and use a database Form. In the Forms area of the database you can Use Wizard to Create Form.
Forms can be edited to display data in numerous formats.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
jhenry
Posts: 8
Joined: Wed Mar 14, 2018 5:43 pm

Re: Spreadsheet data entry super slow!

Post by jhenry »

Thank you so much for the detailed instructions!
OpenOffice.org 3.2.1
000320m18 (build:9502)
Post Reply