Download it now!
Bug 46381 - PIVOTTABLE: Display / Edit Source Ranges in case of DB Tables / Queries
Summary: PIVOTTABLE: Display / Edit Source Ranges in case of DB Tables / Queries
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Master old -3.6
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
Reported: 2012-02-21 02:55 UTC by famo
Modified: 2016-10-21 11:02 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description famo 2012-02-21 02:55:42 UTC
This issue is related / a follow up to the OOo issue "Need ability to change datapilot source range" (

In the OOo issue the display & editing of the source range in Datapilot dialog was introduced. However only for source ranges within the spreadsheet, in case of database tables and queries the source range is not editable or even displayed.

This issue is about to *at least* display the source range in case of DB tables / queries and at best to make it also editable - I leave it to the assignee to decide this.
Comment 1 famo 2012-02-21 03:04:23 UTC
Note that in the OOo issue a patch for the DB case was proposed by sragavan, see: "Fix for remote database" ( and his comment:
sragavan 2005-02-09 11:33:45 UTC
> nn: I have fixed the remote database crash issue i think so(?) :-).
> This patch in combi with the prev patch wrt to m65 would solve the issue.
> The edit field update works but may not be the right way. Ill try to put it
> the right way and submit again.
> Please correct me of any issues.

Maybe this can be (still) used as a starting point...
Comment 2 Alex Thurgood 2015-01-03 17:39:50 UTC Comment hidden (no-value)