Issue 22029 - DataPilot - allow to change labels
Summary: DataPilot - allow to change labels
Status: CLOSED FIXED
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
URL: http://wiki.services.openoffice.org/w...
Keywords: usability
Depends on:
Blocks:
 
Reported: 2003-11-02 17:36 UTC by wbruhin
Modified: 2017-05-20 10:20 UTC (History)
2 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
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
Add an attachment (proposed patch, testcase, etc.)

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