Bug 76161

Summary: [NEW] Import more than one spreadsheet ODS/XLS into BASE as separate tables
Product: LibreOffice Reporter: wabik <wabik>
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED INVALID    
Severity: major CC: iplaw67, wabik
Priority: medium    
Version: 4.2.3.1 rc   
Hardware: x86 (IA32)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description wabik 2014-03-14 08:02:35 UTC 
One cannot import XLS or ODS tables into Base. Why? 
By now, it is possible to import one table XLS/ODS and then you cannot add any new table XLS/ODS into Base.

Thanks for adding :)
Comment 1 Alex Thurgood 2014-03-14 08:31:37 UTC 
Please explain in detail, and in a reproducible manner, what it is you are doing, and which version of LO you are using. Are you really using 4.2.3.1 release candidate ?

Setting to NEEDINFO as there are too many unknown parameters to deal with at the moment.


Alex
Comment 2 Alex Thurgood 2014-03-14 08:49:00 UTC 
On my Linux 64 bit master 4.3 alpha build, I can :

1) Create a new empty ODB file containing no tables
2) Create a Calc file containing two or more Sheets with varying data, including column headings

3) Click on a first Sheet tab and drag and drop this onto my open ODB file in the Tables area of the Base window - the import wizard is started, and the data gets imported into a first table

4) Repeat step 3, choosing the next Sheet tab of my Calc file, and dragging and dropping it into the Tables area of the ODB file - the import wizard is started again, and the data gets imported accordingly.


The above also works in my Mint provided LO 4.1.3.2


What are you not doing, or what is different in the way I have explained above from what you want to do ? 


Alex
Comment 3 Alex Thurgood 2014-03-14 08:53:25 UTC 
Am closing this as invalid, as it seems to me that this is a user misunderstanding of how the Calc to Base import works.


@wabik : if you feel that I have misunderstood what you are trying to do, please reopen this issue and give further information and an explanation.