Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to change Pivottable datasource when datasource is registered database?

In LibreOffice Calc: I cannot change the Pivottable datasource when the datasource is a table/query from a registered database. Any suggestions/workaround?

Show problem:

a) Open LibreOffice Calc.

b) Build a Pivottable using a registered database as a source and save.

Now try to change:

c) Put cursor into Pivottable.

d) Rightclick, choose Edit Layout; window Pivot Table Layout opens

e) Click on Source and Destination

f) Source is greyed out. The current source cannot be identified and it cannot be changed.

Any workarounds? Suggestions? Where do I find this setting in the code of the *.ods-file, so I could change it there?

System: Linux Mint 18.1, cinnamon 64 bit (based on Ubuntu 16.04 LTR) LibreOffice 5.1.6.2

How to change Pivottable datasource when datasource is registered database?

In LibreOffice Calc: I cannot change the Pivottable datasource when the datasource is a table/query from a registered database. Any suggestions/workaround?

Show problem:Prerequisites:

a) Open LibreOffice Calc.

Calc. b) Build a Pivottable using a registered database as a source and save.

Now try Problem (trying to change:change data source):

c) Put cursor into Pivottable.Pivottable.

d) Rightclick, choose Edit Layout; window Pivot Table Layout opens

e) Click on Source and Destination

f) Source is greyed out. The current source cannot be identified and it cannot be changed.

Any workarounds? Suggestions? Where do I find this setting in the code of the *.ods-file, so I could change it there?

System: Linux Mint 18.1, cinnamon 64 bit (based on Ubuntu 16.04 LTR) LibreOffice 5.1.6.2

How to change Pivottable datasource when datasource is registered database?

In LibreOffice Calc: I cannot change the Pivottable datasource when the datasource is a table/query from a registered database. Any suggestions/workaround?

Prerequisites:

a) Open LibreOffice Calc. b) Build a Pivottable using a registered database as a source and save.

Problem (trying to change data source):

c) Put cursor into Pivottable.

d) Rightclick, choose Edit Layout; window Pivot Table Layout opensopens.

e) Click on Source and DestinationDestination.

f) Source is greyed out. The current source cannot be identified and it cannot be changed.

Any workarounds? Suggestions? Where do I find this setting in the code of the *.ods-file, so I could change it there?

System: Linux Mint 18.1, cinnamon 64 bit (based on Ubuntu 16.04 LTR) LibreOffice 5.1.6.2

How to change Pivottable datasource when datasource is registered database?

In LibreOffice Calc: I cannot change the Pivottable datasource when the datasource is a table/query from a registered database. Any suggestions/workaround?

Problem Description:

Prerequisites:

a)

  1. Open LibreOffice Calc. b)
  2. Build a Pivottable using a registered database as a source and save.

Problem (trying to change data source):

c)

  1. Put cursor into Pivottable.

  2. d)

  3. Rightclick, choose Edit Layout; window Pivot Table Layout opens.

  4. e)

  5. Click on Source and Destination.

  6. f)

  7. Source is greyed out. The current source cannot be identified and it cannot be changed.

Any workarounds? Suggestions? Where do I find this setting in the code of the *.ods-file, so I could change it there?

System: Linux Mint 18.1, cinnamon 64 bit (based on Ubuntu 16.04 LTR) LibreOffice 5.1.6.2