After changing (increasing) of Selection from field in Datapilot dialog new column headers do not appear in the Datapilot form so it is not possible to add them to the Datapilot layout. The issue is 100 % repeatable on Ubuntu 10.10. The same issues is also in Openoffice.org 3.3 (http://qa.openoffice.org/issues/show_bug.cgi?id=116504)
Known issue. This got broken when someone made a major change in this area in the OOo code base which we unfortunately inherited. Right now, you need to click OK to dismiss the dialog and re-open it in order for the changed source range to take effect. I've briefly looked into this, but no solution yet. I'd like to get this fixed by 3.4.
Changes in source takes place only if I refresh datapilot before reopening.
This one is now fixed on master. The fix will be in 3.4.