Number of Fields

Discuss the spreadsheet application

Number of Fields

Postby paynalton » Tue Jan 22, 2008 9:30 pm

Hi, I-m using calc to manage DBF databases.

The program is great to that, but i have a problem:

The numer of Horizontal Fields are limit to 9198 and my bases are rounding 12000 fields.

How can i do to increase the number of fields to Calc???
Posts: 1
Joined: Tue Jan 22, 2008 9:24 pm

Re: Number of Fields

Postby Villeroy » Tue Jan 22, 2008 10:02 pm

Like most spreadsheets Calc supports 256 columns, so you may handle your database tables by a database.
Save your database files in a dedicated directory
[X]Connect to existing database, type:dBase
Specify directory
You get a Base document (*.odb) which shows the *.dbf files in the connected directory as tables. You can set up indices and use some functions in queries: ... tions.html
Unfortunately the dBase driver does not support relations. However, you could use any other odbc driver for dBase.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
User avatar
Posts: 28851
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Return to Calc

Who is online

Users browsing this forum: No registered users and 29 guests