Sun May 24, 2020, 03:52 PM

Anyone use LibreOffice Base?

I'm trying to do something very simple, but having a heckuva time and getting nowhere with the Help system. I have several (three-column, nothing exotic) Excel sheets that I want to import into one table in Base in order to create a couple of simple reports. I have tried Cut and Paste per the Help system, but everything winds up in one cell in the table. I also tried (per the LibreOffice community forum) saving the Excel sheet as an .ODS file and then cutting/pasting, but it still doesn't work. All the field types match.

Can anyone help? I'm thinking either something is corrupted in my install or I'm missing one tiny simple little step somewhere.

Thanks much.

4 replies, 2700 views

Thread info Bookmark this thread Trash this thread

Reply to this thread

Always highlight: 10 newest replies | Replies posted after I mark a forum

Replies to this discussion thread

4 replies	Author	Time	Post
Anyone use LibreOffice Base? (Original post)	grumpyduck	May 2020	OP
I'll take a peek when I fire up my laptop running Linux. Have	CentralMass	May 2020	#1
Thanks. Yup, I tried that still no-go.	grumpyduck	May 2020	#2
You probably have to open it up in Calc.	LuvLoogie	May 2020	#3
Don't paste it into a cell in a table, paste directly into the "Tables" tab	Recursion	May 2020	#4

Response to grumpyduck (Original post)

Sun May 24, 2020, 04:04 PM

CentralMass (14,625 posts)

1. I'll take a peek when I fire up my laptop running Linux. Have

you tried saving the spreadsheets as csv files and importing them that way ?
https://help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files

Reply to this post

Response to CentralMass (Reply #1)

Sun May 24, 2020, 04:23 PM

grumpyduck (5,358 posts)

2. Thanks. Yup, I tried that still no-go.

Reply to this post

Response to grumpyduck (Original post)

Sun May 24, 2020, 05:48 PM

LuvLoogie (6,262 posts)

3. You probably have to open it up in Calc.

Base is the database module, similar to Access.

You might have to do either like to like cross platform, or convert your excel doc into access first.

Reply to this post

Response to grumpyduck (Original post)

Wed May 27, 2020, 08:10 AM

Recursion (56,552 posts)

4. Don't paste it into a cell in a table, paste directly into the "Tables" tab

It will run through a Druid (I know; it's silly -- Microsoft trademarked "Wizard" at some point) to ask you about the data and generate a new table for you.

https://help.libreoffice.org/Common/Importing_and_Exporting_Data_in_Base

Reply to this post