Apache OpenOffice (AOO) Bugzilla – Issue 6521
formatting single characters in titles - subscript or superscript in chart titles
Last modified: 2013-09-25 20:41:59 UTC
Hi, 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...
I forgot to mention that chart axes are affected in the same way too. Thanks, Mark
It's the wrong component. I set the flags. Frank
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 Frank
Ooooppppssss, I've forgoten to set the flags. Here they come. Frank
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.
This is related to issue 10836
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).
*** Issue 10836 has been marked as a duplicate of this issue. ***
Today while creating a new chart in 1.1RC5, I still have formatting problems. The format changes to one format. I loose all super/subscripts. 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.
Re-assigned to Matthias Müller-Prove for further evaluation.
to Bettina, our central dispatcher for RFEs
Hello Björn, any chance for OO.o 2.0?
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 lines) 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.
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.
The UI and the conversion into a <text:p> element in the fileformat are still missing.
*** Issue 38017 has been marked as a duplicate of this issue. ***
*** Issue 44311 has been marked as a duplicate of this issue. ***
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.
*** Issue 59479 has been marked as a duplicate of this issue. ***
Any news on this issue? I really miss this feature!
*** Issue 74810 has been marked as a duplicate of this issue. ***
This issue is similar to issue 1489.
*** Issue 90496 has been marked as a duplicate of this issue. ***
change owner
reset to new
This really needs to be available if you want the charting application to be taken seriously.
*** Issue 95470 has been marked as a duplicate of this issue. ***
*** Issue 102822 has been marked as a duplicate of this issue. ***
And bold/italics as well.
This functionality is seriously important. Near showstopper for me.
wow, this issue was opened in 2002 and is still not resolved!
2002... wow... is someone trying to fight bugs in OO ?
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.
*** Issue 117139 has been marked as a duplicate of this issue. ***
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).