[Libreoffice-bugs] [Bug 143168] New: Cannot read in excel spreadsheet to libreoffice base database

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=143168

            Bug ID: 143168
           Summary: Cannot read in excel spreadsheet to libreoffice base
                    database
           Product: LibreOffice
           Version: 7.1.3.2 release
          Hardware: All
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: hcantrell1 at unm.edu

Description:
I am trying to "read in" an excel spreadsheet to libreoffice database. It was
easier for me to make the spreadsheet in excel, but I wish to enter my data and
store my data using base. However, I cannot load the spreadsheet into the
database and am getting errors when it tries to copy my data. The errors
consist of "character F" or "character M" problems and I am unsure what those
mean. I am using:
https://dominoc925.blogspot.com/2013/05/import-csv-file-into-libreoffice-base.html
website's instructions to attempt to load it in. I am able to create a "read
only" version of the spreadsheet in another window of the database, but when I
go to copy it into my database in order to get an edit version, that is when it
is giving me the errors. It seems to be only affecting some of the fields from
my spreadsheet as I have tried entering them one at a time. Most of them can
load, but there are at least 3 of my fields that result in an error. 

Steps to Reproduce:
1. I converted my excel spreadsheet into a csv and then loaded that into a
blank database which creates a "read only" copy. End goal is to "read in" my
excel spreadsheet to base as a format for the database I want to use in base. 
2. I open the database in which I want the table to have an "edit" version in. 
3. Drag the "read only" table into the table section of the desired database. 
4. Then it will ask me what I want to copy in and I choose "definition and
data"
5. Hit next and move all columns listed on the left over to the right box 
6. Hit next and go on to edit column information. I list every one of these as
"TEXT (VARCHAR)" just to be safe. There are only numbers (without decimals and
negatives) and letters that I will be entering. 
7. Click create when done editing the columns 
8. This is when it asks me if I want to "create a primary key" and I click yes. 
9. It gives me an error. 

Actual Results:
Errors. Cannot copy in my excel spreadsheet and end up with an editable version
in base. 

Expected Results:
Loaded my excel spreadsheet (which is in csv format) into the base so I can
start entering in my data. 


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Not sure what information from "Help - About LibreOffice" you were asking me to
put here?

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210703/5aace77d/attachment.htm>