[Libreoffice-bugs] [Bug 121096] Databaseconnection: Connecting Calc-tables to database shows more tables as Calc-tables defined

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #4 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(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?

-- 
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/20181103/3768a4be/attachment.html>