Issue 22029

Summary: DataPilot - allow to change labels
Product: Calc Reporter: wbruhin <wernerfbd>
Component: uiAssignee: oc
Status: CLOSED FIXED QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues, pagalmes.lists
Version: OOo 1.0.1Keywords: usability
Target Milestone: ---   
Hardware: All   
OS: All   
URL: http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_custom_display_names
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Changing labels is not possible
none
How this could be implemented
none
TCS
none
Testdocument for TCS none

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
spreadshett.

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

1 4 u.

Frank
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]
TCS
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