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.
Spreadsheet data entry super slow!
Spreadsheet data entry super slow!
OpenOffice.org 3.2.1
000320m18 (build:9502)
000320m18 (build:9502)
Re: Spreadsheet data entry super slow!
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
Re: Spreadsheet data entry super slow!
We've been using this application for years and have not had the slowdown since updating. The application also is very slow to load.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 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)
000320m18 (build:9502)
Re: Spreadsheet data entry super slow!
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.
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.
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: Spreadsheet data entry super slow!
Thank you, I will.Zizi64 wrote:Try the LibreOffice Calc.
OpenOffice.org 3.2.1
000320m18 (build:9502)
000320m18 (build:9502)
-
- Volunteer
- Posts: 1544
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Spreadsheet data entry super slow!
While not difficult there are a few steps involved.Is there a simple way to migrate our spreadsheet to the database format?
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");
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
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Re: Spreadsheet data entry super slow!
Thank you so much for the detailed instructions!
OpenOffice.org 3.2.1
000320m18 (build:9502)
000320m18 (build:9502)