Ask Your Question

Convert Openoffice Base Fields

asked 2018-06-19 18:01:17 +0100

hollrm gravatar image

I imported a table through calc to base but the numerical column is now text. How can I convert the thousands of cells in that column from text back to integers? I am using OpenOffice 4.1.5 (no SQL).

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-06-19 18:27:42 +0100

Ratslinger gravatar image


Your conversion of where you actually started is not quite clear.

If you were using OpenOffice Base to start you should be able to simply open that .odb in LO without a problem. You should also be able to copy the table from OpenOffice and then paste in LO Base.

If you started from a Calc sheet how did you move the data? If you had the table pre-defined there should be no problem. Maybe you have just created a table based upon a CSV file in which case it is all in the import and how you accepted the defaults. If from the spreadsheet how the data was defined there makes a difference also.

If after this you are still having a problem, more information on exactly what you did is necessary. As you can see there are many possible variations.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-06-19 18:01:17 +0100

Seen: 61 times

Last updated: Jun 19 '18