Bug 138235

Summary:	Database creation from Calc spreadsheet not happening
Product:	LibreOffice	Reporter:	Linde Merrick <linde.merrick>
Component:	Base	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	robert
Priority:	medium
Version:	6.4.3.2 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Linde Merrick 2020-11-15 11:53:20 UTC

Description:
Using the "New Database" process, I can't create a database from my existing Calc spreadsheet.  Have uninstalled LO 6.4 and reinstalled LO 7.0 but no improvement. The first screen on Database for create a new database shows embedded database of HSQLDB.  Is this what is causing the problem?

Steps to Reproduce:
1.Open Calc spreadsheet, then File, New , Database
Use Database wizard to create and register database
Save database
Open database to use data in tables
2.
3.

Actual Results:
New database not listed

Expected Results:
New database should be in list and should be able to see Calc sheets


Reproducible: Always


User Profile Reset: No



Additional Info:
Need created database and tables to generate labels for posting large number of letters.

Comment 1 Robert Großkopf 2020-11-15 13:56:06 UTC

The first step seem to be wrong for you:
When you want to connect to a spreadsheet (Calc) you have to choose "Connect to an existing database" - not: "Create a new database". Base is only the GUI for different databases, an the data are stored in a «database» like your Calc file.

Comment 2 Linde Merrick 2020-11-18 21:07:19 UTC

(In reply to Robert Großkopf from comment #1)
> The first step seem to be wrong for you:
> When you want to connect to a spreadsheet (Calc) you have to choose "Connect
> to an existing database" - not: "Create a new database". Base is only the
> GUI for different databases, an the data are stored in a «database» like
> your Calc file.

Thank you for this Robert.  Now managed to get the database and print off my labels.

Comment 3 Robert Großkopf 2020-11-19 06:31:31 UTC

(In reply to Linde Merrick from comment #2)
> 
> Thank you for this Robert.  Now managed to get the database and print off my
> labels.

So I have set this bug to RESOLVED and NOTABUG.