Issue 22029 - DataPilot - allow to change labels
Summary: DataPilot - allow to change labels
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.1
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
Keywords: usability
Depends on:
Reported: 2003-11-02 17:36 UTC by wbruhin
Modified: 2017-05-20 10:20 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Changing labels is not possible (33.84 KB, image/png)
2007-12-28 13:17 UTC, pagalmes.lists
no flags Details
How this could be implemented (77.72 KB, image/png)
2007-12-28 13:17 UTC, pagalmes.lists
no flags Details
TCS (33.66 KB, text/html)
2010-01-07 08:21 UTC, oc
no flags Details
Testdocument for TCS (10.02 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-01-07 08:22 UTC, oc
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description wbruhin 2003-11-02 17:36:15 UTC
Using DataPilot to extract data from a database.

Column names in a database are often a bit technical and even more important are
only available in the language of the developer (often English).

It would be nice if one could change these labels during creation of a
DataPilot, so e.g. a tablename1.columnname1 becomes "Nice column name" in the

Keep the good work up and best regards.
Comment 1 frank 2003-11-03 08:44:17 UTC
Hi Bettina,

1 4 u.

Comment 2 pagalmes.lists 2007-12-28 13:16:34 UTC
I would add that even in a "simple" datapilot, it is not possible to modify
headers. It is possible to double click on the label but not to modify it. See
the attached screenshot.

It would be nice to be able to change this label, and that even if the datapilot
is refreshed that this name would stay. See the second screenshot for an idea on
how to implement it.
Comment 3 pagalmes.lists 2007-12-28 13:17:16 UTC
Created attachment 50585 [details]
Changing labels is not possible
Comment 4 pagalmes.lists 2007-12-28 13:17:51 UTC
Created attachment 50586 [details]
How this could be implemented
Comment 5 kyoshida 2008-11-24 14:48:59 UTC
I'm looking into this currently.
Comment 6 kyoshida 2008-11-24 14:49:36 UTC
accepting it.
Comment 7 kyoshida 2009-06-19 21:22:29 UTC
An initial spec page has been made.
Comment 8 kyoshida 2009-09-03 04:18:54 UTC
I think I've done everything I could think of, so I consider this fixed.

The only sticking point is that the ODF file format change proposal has not yet
been officially approved.  But if we could stick in the change as part of the
"extended" format that's being proposed for 3.2, we can ship this feature in 3.2.
Comment 9 kyoshida 2009-09-03 04:19:14 UTC
fixed in koheidatapilot03 cws.
Comment 10 kyoshida 2009-09-03 17:08:40 UTC
reassign to oc for QA verification.
Comment 11 oc 2009-11-05 12:51:08 UTC
adjusting target according to cws target
Comment 12 oc 2010-01-07 08:21:32 UTC
Created attachment 67048 [details]
Comment 13 oc 2010-01-07 08:22:02 UTC
Created attachment 67049 [details]
Testdocument for TCS
Comment 14 oc 2010-01-07 08:22:46 UTC
verified in internal build cws_koheidatapilot03