Guaka, This is upstream issue 13467, there is an example file attached showing how to achieve the desired functionality.
See: http://qa.openoffice.org/issues/show_bug.cgi?id=13467 The names of the rows and columns do not change, this is an upstream feature. Philosophical comment: In the real world you may go anywhere and do anything, without wishing to change the names of "latitude" or "longitude". thanks jim
