Created attachment 146228 [details] Unpack the folder. Open the database-file in the folder. 4 tables instead of 2 tables were shown. Open the attached database-file, which connects to the attached Calc-file. Open on the left "Tables". You could see 4 tables: "Importieren1", "Importieren2", "Tabelle1" and "Tabelle2" I have created the Calc-document and imported the data from a Base-document. Calc shows 4 tables instead of 2. Open the calc-file and have a look: Only 2 tables.
Haven't written down configuration of the software: LO 6.1.3.2 on OpenSUSE 15 64bit rpm Linux.
Ok so I'm using Ubuntu 18.04 and LibreOffice 6.1.3.1 (also used 6.1, 5.4 and OOo 4.1.6 same results in all of them) Yes, there are four tables displayed. Two are the full Calc sheets. Two are defined data ranges in the file. I believe this is the expected behavior.
I have a calc document with only sheet2 (sheet1 was deleted long ago) I get the following tables: 1. Table: „Importieren1“ with only 67 of 69 columns 2. Table: „Tabelle2“ with all data Both tables refer to sheet2. Maybe the deleted sheet1 contained 67 columns No named data ranges defined LO 6.0.6; Windows 10 64bit
(In reply to ge60 from comment #3) > I have a calc document with only sheet2 (sheet1 was deleted long ago) > > I get the following tables: > > 1. Table: „Importieren1“ with only 67 of 69 columns > 2. Table: „Tabelle2“ with all data > > Both tables refer to sheet2. Maybe the deleted sheet1 contained 67 columns > No named data ranges defined > > LO 6.0.6; Windows 10 64bit When you import data (such as dragging a Table or Query from the beamer window onto sheet) it automatically creates a named range (in English Import[x]). To not have that named range in the file you have to explicitly remove it. Perhaps you have inadvertently created a range?
Data ranges were indeed automatically defined by importing data from Base to Calc. So let us close this one as WORKSFORME.