Issue 6521 - formatting single characters in titles - subscript or superscript in chart titles
Summary: formatting single characters in titles - subscript or superscript in chart t...
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Trivial with 38 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: ms_interoperability
: 10836 38017 44311 59479 74810 90496 95470 102822 117139 (view as issue list)
Depends on:
Blocks: 24066
  Show dependency tree
Reported: 2002-07-23 11:02 UTC by Unknown
Modified: 2013-09-25 20:41 UTC (History)
7 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2002-07-23 11:02:53 UTC

I've been trying to use openoffice to complete the coursework of my science
course over the past six months.  I've been using lots of mathematical and
scientific symbols, and am finding it really frustrating that I can't use
subscript or superscript fonts in chart titles.  Please add this feature to
openoffice, I really don't want to have to use MS-Office ever again...
Comment 1 Unknown 2002-07-23 11:05:42 UTC
I forgot to mention that chart axes are affected in the same way too.


Comment 2 frank 2002-07-23 16:08:14 UTC
It's the wrong component.

I set the flags.

Comment 3 frank 2002-07-23 17:04:45 UTC
Hi Mark,

I pass this over to our feature guys.

As workaround please write your title into a cell, set the cell to
edit mode (F2) and format the string as needed (Format Cells). You can
do the formatting also on 'typing time' if you use CTRL+SHIFT+P for
Superscript CTRL+SHIFT+B for Subscript. Use the same keycombination to
switch this mode off.

Place the cell into the clipboard and select the Chart. Now place the
title into Edit mode and paste the content of the clipboard. 

It should work.

Best regards

Comment 4 frank 2002-07-23 17:06:03 UTC

I've forgoten to set the flags.

Here they come.

Comment 5 mestech 2003-09-12 16:44:59 UTC
Using 1.1RC4

I have the same issue and I have tried the work around.  The
formatting changes back to normal text.

I have inserted the formula as a subtitle.

If I use the technique of inserting the formula into the x-axis title
and then copying the title, sometimes the formatting stays.  Of course
once the title is copied, there is no ability to edit the copy.

The formatting of the text in titles should be able to be edited and
formatted seperatly.
Comment 6 mestech 2003-09-12 16:53:54 UTC
This is related to issue 10836
Comment 7 bettina.haberer 2003-09-19 15:37:33 UTC
Summary: All the text attributes which can be assigned to text in
cells should also be available for textobjects inside the chart
(including character positioning).
Comment 8 bettina.haberer 2003-09-19 15:40:43 UTC
*** Issue 10836 has been marked as a duplicate of this issue. ***
Comment 9 mestech 2003-10-06 21:40:33 UTC
Today while creating a new chart in 1.1RC5, I still have formatting
problems.  The format changes to one format.  I loose all

I have a work around.

I create a seperate object box for each superscript or subscript and
modify the text to suit.  The copied and pasted object cannot be modified.

I have used the subtitle for the above purpose.  If I want to enter a
formula such as 25^t45 I would enter t45 in the subtitle box and
modify the font size to represent the superscript size.  Then I copy
and paste the title and past to the chart.  I then edit the subtitle
box and enter the 25 and set the size.  Now drag the individual
objects to the correct location on the chart.

I hope that this helps others as it has made things easier for me.
Comment 10 falko.tesch 2003-10-08 09:27:20 UTC
Re-assigned to Matthias Müller-Prove for further evaluation.
Comment 11 matthias.mueller-prove 2003-10-08 17:46:18 UTC
to Bettina, our central dispatcher for RFEs
Comment 12 bettina.haberer 2003-10-16 11:00:22 UTC
Hello Björn, any chance for OO.o 2.0?
Comment 13 bjoern.milcke 2003-10-16 15:56:33 UTC
We already have addresses this problem in the new chart.  Formerly a
title was just one string with one format (i.e. also one Font).

We decided not to replace the single string by XText, because this
interface is far to complex and interwoven.  Instead the new chart
provides a sequence of formatted strings (XFormattedString), which
contain a string and arbitrary CharacterProperties.  Thus you will
still only have one paragraph, but you may format different parts of
the text with different formats (and you may insert CRs to start new

However, it is still not clear how we will offer the new functionality
via UI.  It should be similar to the way text obejcts in Draw/Impress
are formatted.
Comment 14 bjoern.milcke 2004-02-06 14:08:33 UTC
As a lot of things (especially getting to the old functionality with the new
implementation) for OOo 2.0 are more important than this, I will set the prio to P4.
Comment 15 bjoern.milcke 2004-04-05 17:17:07 UTC
The UI and the conversion into a <text:p> element in the fileformat are still
Comment 16 kla 2004-12-21 11:19:51 UTC
*** Issue 38017 has been marked as a duplicate of this issue. ***
Comment 17 Matthias Basler 2005-03-29 12:43:36 UTC
*** Issue 44311 has been marked as a duplicate of this issue. ***
Comment 18 IngridvdM 2005-04-18 17:59:21 UTC
I changed the summary to reflect that not only subscript or superscript should
be enabled per character but also other character formattings like bold or
italic for example.
Comment 19 lars 2005-12-17 16:31:50 UTC
*** Issue 59479 has been marked as a duplicate of this issue. ***
Comment 20 bettlerthomas 2007-02-19 20:32:37 UTC
Any news on this issue?
I really miss this feature!
Comment 21 IngridvdM 2007-03-02 11:31:06 UTC
*** Issue 74810 has been marked as a duplicate of this issue. ***
Comment 22 IngridvdM 2007-07-24 20:30:45 UTC
This issue is similar to issue 1489.
Comment 23 kla 2008-06-09 14:24:55 UTC
*** Issue 90496 has been marked as a duplicate of this issue. ***
Comment 24 IngridvdM 2008-07-03 11:39:33 UTC
change owner
Comment 25 IngridvdM 2008-07-22 14:21:51 UTC
reset to new
Comment 26 mark_connolly 2009-04-20 12:48:09 UTC
This really needs to be available if you want the charting application to be
taken seriously.
Comment 27 IngridvdM 2009-04-29 09:59:45 UTC
*** Issue 95470 has been marked as a duplicate of this issue. ***
Comment 28 IngridvdM 2009-06-22 15:13:35 UTC
*** Issue 102822 has been marked as a duplicate of this issue. ***
Comment 29 headbomb 2009-06-22 23:50:05 UTC
And bold/italics as well.
Comment 30 gmwatson 2009-07-20 20:18:39 UTC
This functionality is seriously important. Near showstopper for me.
Comment 31 dienacht 2010-03-19 05:24:40 UTC
wow, this issue was opened in 2002 and is still not resolved! 
Comment 32 owqcd 2010-05-09 19:51:57 UTC
2002... wow... is someone trying to fight bugs in OO ?
Comment 33 bzed 2011-01-31 01:09:22 UTC
As a university student in the sciences this is the most important feature I
need for Calc. I can't keep placing text boxes when I have dozens of similar
graphs that need to be resized and manipulated while still being up to quality
aesthetic standards.
Comment 34 Regina Henschel 2011-03-01 15:31:10 UTC
*** Issue 117139 has been marked as a duplicate of this issue. ***
Comment 35 sorath 2012-03-06 16:56:46 UTC
It is very strange that such useful feature is still not realized for such powerful office suit at the time more light "Gnumeric" can represents more powerful  abilities for Scietific format for Axis (Format Axis - Number - Categoty "Scientific") not only with "format code" such as 0.00E+000 (-1.23У+003) but with format such 1.00x10^2  or 1x10^2 (looking as record "1 times 10^2" in "Math") or just 10^2 where "^2" means usual superscript representation (if it's typed in "Math" editor of OpenOffice suit).