Created attachment 84294 [details]
AAObug-printingSelectedChartAlwaysPrintsChartOnAlternateSheet

Assume multiple sheets each contain a chart. Exporting as pdf a selected chart on a sheet ("Selection") often exports the chart in the an alternate sheet (not the selected chart).

To reproduce;
1. Open Calc
2. enter some dummy data and create a chart on sheet 1
3. enter some dummy data and create a chart on sheet 2

Bug scenario 1;
4. select the chart on sheet 2
5. Export as pdf - select "selection" - Export
Actual behaviour: PDF is created of chart on sheet 1
Expected behaviour: PDF is created of chart on sheet 2

Bug scenario 2;
4. select the chart on sheet 1
5. Export as pdf - select "selection" - Export
Actual behaviour: PDF is created of chart on sheet 2
Expected behaviour: PDF is created of chart on sheet 1

I have not determined why bug scenario 2 sometimes occurs instead of scenario 1 (but in both cases it will decide to export a particular chart irrespective of which is actually selected).

Workaround 1: select the background cells of the chart and export the selection
Workaround 2: Save the file, and reopen it. This doesn't always work, but worked with example file attached. In some cases all AOO windows must be closed before reopening the file. In other cases, the problem will remain.

I have attached an example file (AAObug-printingSelectedChartAlwaysPrintsChartOnFirstSheet.ods), but note the problem often goes away when saving and reopening the file. As such the problem cannot be demonstrated by using this file (it must be reproduced manually).