Bug 126156 - Pivot table with external Database table won't work anymore
Summary: Pivot table with external Database table won't work anymore
Status: RESOLVED DUPLICATE of bug 125808
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-06-29 09:37 UTC by frank.hanke
Modified: 2019-06-29 15:55 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description frank.hanke 2019-06-29 09:37:40 UTC 
Description:
Hello,

since Libre Office Version 6.2.4.2 it is not possible to create a Pivot-Table with an registered Database Table.

Environment:
LibreOffice Version 6.2.4.2
Mac-OS Mojave 10.14.5
Java 1.8.0_191

Steps:
Data->Pivot-Table->create

in the dialog Choose Source (in german version "Quelle wählen")
I use the second option - "registered Source" (german "in LibreOffice angemeldete Datenquelle")
[OK]
Logon to Database and [OK]
in the following dialog I choose a Table of the Database
--so far so good
But, the following Dialog - define the Layout of the Pivot Table - is empty. 

It can also be reproduced with the Bibliography-Database. 

Steps to Reproduce:
1.create Pivot Table
2.choose external Source / registered Source
3.logon to Database or use Bibliography-Database


Actual Results:
=> the Dialog "Defining Layout" is empty

Expected Results:
=> choose the columns of the Table to define the Pivot-Table Layout


Reproducible: Always


User Profile Reset: No



Additional Info:
I tried this in safe-Mode -- same result
so I suppose it has nothing to do with my user Profile
Comment 1 Oliver Brinzing 2019-06-29 15:55:25 UTC 
seems to be a dup of:
Bug 125808 - A pivot table cannot be created from a registered data source

cannot confirm this with:

Version: 6.2.5.1 (x64)
Build-ID: 9a940173fab1747f02322bc89779759d52b3a086
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE
Calc:

*** This bug has been marked as a duplicate of bug 125808 ***