Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Chart title from a cell|
|Component:||chart||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P4||CC:||issues, matthias.mueller-prove, tony.galmiche.ooo|
|Version:||3.3.0 or older (OOo)|
|Issue Type:||FEATURE||Latest Confirmation in:||---|
Description ooo 2002-10-06 22:57:38 UTC
It would be great if you could have the chart title as a reference to a cell so you should only change the cell to change the title of a chart. The reference could automatic be the cell between the x axis titles and the y axis title: A1: Chart title B1: X axis title 1 C1: X axis title 2 A2: Y axis tilte 1 B2: Value C2: Value A3: Y axis title 2 B3: Value C3: Value
Comment 1 frank 2002-10-07 07:14:30 UTC
Hi Falko, 1 4 u Frank
Comment 2 daniel.rentz 2002-10-10 12:40:30 UTC
FYI: It's already on the chart wish list, see http://graphics.openoffice.org/chart/featurewishes.html
Comment 3 eric.savary 2003-04-16 15:39:15 UTC
Set to "NEW"
Comment 4 falko.tesch 2003-10-15 09:44:48 UTC
It would be great if you could have the chart title as a reference to a cell so you should only change the cell to change the title of a chart.
Comment 5 matthias.mueller-prove 2003-10-15 16:50:47 UTC
to Bettina, our central dispatcher for RFEs
Comment 6 bettina.haberer 2003-10-15 17:25:40 UTC
Very good idea referring cell content (text) to the title as a part of the chart. Hello BjÃ¶rn, please give approval for this evaluated OO.o 2.0 flagged issue. If you confirm with the target OO.o 2.0, then please keep it on your owner (or the owner of the concerning developer) for implementation. In case you want this issue for 'OOo Later', then please reset the target milestone. If you decline the issue finally, please set the resolution to 'Wontfix' (but do not close). In case of 'OOo Later' or 'Wontfix' please reset it on Bettina's owner. Thank you.
Comment 7 bjoern.milcke 2003-11-03 08:50:40 UTC
The automatic detection of a cell that contains titles is a bit difficult. The only intuitive thing would be to use the "upper left empty cell" for the main title. Title Cat1 Cat2 ... Ser1 1 3 ... Ser2 3 2 ... ... However, it would be useful to offer a tab-page in the title dialog (for any of the titles), where you can choose the cell from where the content of the title comes from. ->Bettina: I suggest to postpone this feature to "OOo Later"
Comment 8 dfrench 2003-12-09 23:04:59 UTC
I would be happy just to be able to set the title, subtitle to the value of a cell. Figure out the smart selection of that cell at a later date. To me, the shortcoming is that these features of the chart are strings and not fully functional text objects. I suggest that the charts team aim to make all the chart annotations (including data labels, axis descriptions) text objects. We could then include data from the spreadsheet cells, or anywhere else, using textfields (com.sun.star.text.TextField...). At the user interface level, I suggest that actually having to specify the cell by name is a particular difficulty. I have been doing that for years in MSExcel. If issue 22788 was resolved we could simply replace the title with a textbox containing data linked to the cell or whatever.
Comment 9 dfrench 2003-12-09 23:08:02 UTC
my comment should read ....NOT a particular difficulty ....
Comment 10 bettina.haberer 2004-11-29 18:01:45 UTC
Reassigned to BjÃ¶rn.
Comment 11 shanx 2005-12-29 19:37:10 UTC
I would like to add to this discussion the following: include the axis (x or y) Maximum, Minimum, Major Interval, Minor Interval and "Axis at" to be referenced to cells as well. I have wished that Excel has had this option for a long time now. It seems that if other numerical values can be referenced, why can't the axis max/min/scale. Shanx
Comment 12 IngridvdM 2006-03-17 15:35:17 UTC
*** Issue 12460 has been marked as a duplicate of this issue. ***
Comment 13 kpelckmans 2006-03-27 08:43:22 UTC
Any idea which version will implement this feature ?
Comment 15 IngridvdM 2007-10-19 17:57:36 UTC
*** Issue 82730 has been marked as a duplicate of this issue. ***
Comment 16 dudson 2007-10-20 17:20:45 UTC
Still not in OOo 2.3
Comment 17 IngridvdM 2008-07-03 11:39:08 UTC