Bug 121211 - IMPORT: Calc range 'table definition only option selected' fails to create table
Summary: IMPORT: Calc range 'table definition only option selected' fails to create table
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Import
  Show dependency treegraph
 
Reported: 2018-11-06 15:14 UTC by Robert Großkopf
Modified: 2022-02-23 18:10 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments
Screenshot: Where to choose definition of a table while importing ... (51.08 KB, image/png)
2018-11-06 15:14 UTC, Robert Großkopf
Details
bt with debug symbols from ODatabaseExport::executeWizard (10.22 KB, text/plain)
2018-11-11 13:36 UTC, Julien Nabet
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Robert Großkopf 2018-11-06 15:14:51 UTC
Created attachment 146363 [details]
Screenshot: Where to choose definition of a table while importing ...

See bug 121208 for start.
First step of the dialog of the table import wizard show the possibility to import only the definition of a table. 
Choose this option.
Go to the next steps.
At the end press "Create".
No table will be created.
This doesen't work with a table with field names and content and doesen't wor also with a table only created with field names.

This bug happens with LO 6.1.3.2 64bit rpm Linux.
Comment 1 Drew Jensen 2018-11-06 17:58:10 UTC
Confirmed using Ubuntu 18.04 and 6.1.3.2 rel.
For this one use case of a calc import (though a table form Writer might do the same, I wouldn't be surprised)

First what worked for definition only:
Using drag and drop from 
Source -> Target
hsql(emb) hsql(emb)
hsql(emb) fb(emb)
fb(emb)   hsql(emb)

Then what failed for definition only:
Calc(rows) hsql(emb)
Calc(rows) fb(emb)
Comment 2 Drew Jensen 2018-11-06 18:06:43 UTC
also I changed the summary to start with IMPORT:
Comment 3 Drew Jensen 2018-11-06 18:33:54 UTC
Confirmed the same behavior in LO 5.4.7 and AOo 4.1.6RC
Comment 4 Drew Jensen 2018-11-06 18:34:35 UTC
Setting the severity back to normal, also.
Comment 5 Julien Nabet 2018-11-10 20:44:55 UTC
I submitted a patch on gerrit https://gerrit.libreoffice.org/#/c/63250/
Comment 6 Julien Nabet 2018-11-11 13:36:50 UTC
Created attachment 146538 [details]
bt with debug symbols from ODatabaseExport::executeWizard
Comment 7 Julien Nabet 2018-11-11 20:30:14 UTC
Patch was wrong, can't help here->uncc myself.
Comment 8 QA Administrators 2019-12-06 04:18:35 UTC Comment hidden (obsolete)
Comment 9 Robert Großkopf 2019-12-06 18:29:08 UTC
Bug is the same in LO 6.3.3.2 on OpenSUSE 15.1 64bit rpm Linux
Comment 10 QA Administrators 2021-12-06 04:05:31 UTC Comment hidden (obsolete)
Comment 11 Robert Großkopf 2021-12-06 15:29:30 UTC
Still the same in LO 7.2.3.2 on OpenSUSE 15.2 64bit rpm Linux.
Comment 12 jcsanz 2022-02-21 16:56:33 UTC
This bug is still present in: 

Version: 7.3.0.3 (x64) / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: es-ES
Calc: CL
Comment 13 Longi 2022-02-21 19:41:05 UTC
Same behaviour in LOo 7.3.1.1 paralel in Windows10 in a firebird not embeded database trying to import from a calc sheet, but also from a HSQLDB 2.4 splitted database.
Comment 14 Longi 2022-02-23 18:10:48 UTC
Sorry, I have to correct myself. I had used other version. Now with LOO 7.3.1.1 seems to be working, except if the data source is a calc sheet. In this case the structure is not copied.
Windows 10, 
Version: 7.3.1.1 (x64) / LibreOffice Community
Build ID: 349cd3ad57dce98d6b54b76f8e9f456ac7d7edb7
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: es-ES
Calc: CL