Spreadsheet data entry super slow!

Discuss setup / installation issues - Add a spell checker, Language pack?

Spreadsheet data entry super slow!

Postby jhenry » Thu Jun 14, 2018 4:55 pm

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)
jhenry
 
Posts: 8
Joined: Wed Mar 14, 2018 5:43 pm

Re: Spreadsheet data entry super slow!

Postby RoryOF » Thu Jun 14, 2018 4:58 pm

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.5 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 27472
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Spreadsheet data entry super slow!

Postby jhenry » Thu Jun 14, 2018 5:09 pm

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)
jhenry
 
Posts: 8
Joined: Wed Mar 14, 2018 5:43 pm

Re: Spreadsheet data entry super slow!

Postby Zizi64 » Thu Jun 14, 2018 5:15 pm

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; LO4.4.7, LO6.1.1 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.2 and AOO4.1.5
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
Zizi64
Volunteer
 
Posts: 7355
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Spreadsheet data entry super slow!

Postby jhenry » Thu Jun 14, 2018 5:36 pm

Zizi64 wrote:Try the LibreOffice Calc.


Thank you, I will.
OpenOffice.org 3.2.1
000320m18 (build:9502)
jhenry
 
Posts: 8
Joined: Wed Mar 14, 2018 5:43 pm

Re: Spreadsheet data entry super slow!

Postby UnklDonald418 » Thu Jun 14, 2018 7:34 pm

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   Expand viewCollapse view
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.5 & LibreOffice 6.1.1.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 968
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Spreadsheet data entry super slow!

Postby jhenry » Thu Jun 14, 2018 8:56 pm

Thank you so much for the detailed instructions!
OpenOffice.org 3.2.1
000320m18 (build:9502)
jhenry
 
Posts: 8
Joined: Wed Mar 14, 2018 5:43 pm


Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: RusselB and 4 guests