Welcome to DU! The truly grassroots left-of-center political community where regular people, not algorithms, drive the discussions and set the standards. Join the community: Create a free account Support DU (and get rid of ads!): Become a Star Member Latest Breaking News Editorials & Other Articles General Discussion The DU Lounge All Forums Issue Forums Culture Forums Alliance Forums Region Forums Support Forums Help & Search

grumpyduck

(6,647 posts)
Sun May 24, 2020, 02:52 PM May 2020

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 = new reply since forum marked as read
Highlight: NoneDon't highlight anything 5 newestHighlight 5 most recent replies
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

LuvLoogie

(7,534 posts)
3. You probably have to open it up in Calc.
Sun May 24, 2020, 04:48 PM
May 2020

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.

Recursion

(56,582 posts)
4. Don't paste it into a cell in a table, paste directly into the "Tables" tab
Wed May 27, 2020, 07:10 AM
May 2020

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

Latest Discussions»Retired Forums»Website, DB, & Software Developers»Anyone use LibreOffice Ba...