Adding superscripts and subscripts in Chart titles of Calc

This has been an elusive topic for years now and Libreoffice (including the latest release 7.2.0.4) is somehow not interested in making this possible with ease. This is crucial for students, researchers and teachers who need to present scientific charts. I see that way back in 2016 a post was made on this and was closed then wo redressal. No remarkable progress in this aspect.
As of now the only way one can do this is by reaching out for the special character menu from the chart title dialogs. This too happens to be very buggy, since the special character menu is not presented from the format title but available only from the right click context menu of title creation box… If we invoke special character menu from the “insert” of main menu, the sub menu list is incomplete. Most of the Unicodes with which these are created are also not visible in the special character menu. But one can type in the Unicodes in the textbox of special character menu and reach them, Every time one types a character, you need to get out and get in again into this dialog to type the next. However it is at least possible to do super and subscripts in chart titles, without which charting can not be of much use.
Let me kindly know if the users have found any other easier method. I recently did a feature request and a bug report for correcting the unicode entries!

In the Insert Title dialogue box I cannot type the Unicode number in and get the resulting character. I can only call the special character dialogue from the context menu.
I think changing the workflow is best workaround.
There is no problem pasting in superscripts, etc., so you have to plan ahead. Type out the complete title as you would like it in a cell and copy it to the clipboard. Open the Insert Title dialogue and paste the clipboard with Ctrl+V or right-click menu

1 Like

I recently did a feature request and a bug report for correcting the unicode entries!

Then it would be really nice if you post the links here. Thank you.

1 Like

Bugzilla ID is 143581 - with the link below
https://bugs.documentfoundation.org/show_bug.cgi?id=143581

Thanks for your action.

One easy method for adding sub and superscripts is to use a text box when inside the chart. Without adding the chart title that needs a sub/ super scripted text, simply one can add text boxes and then create the title with the required sub and superscript, position and orient the textbox anywhere we want. Ctrl+Shift+P or M will do the job to insert the super/ subscripts.Or use the right click menu to use Character formatting. This will create the textbox as a drawing object in the chart. No need to type in a cell and copy it into the chart (which will also create a drawing object). If one cant find the drawing toolbar, use view > toolbar menu to invoke it when inside the chart.
But the caveat is that these drawing objects of LO inside the chart are not compatible with MS office. Under the latest MS office these are not even visible in the charts created thus.

If one wants compatibility with MS office, then the best thing is to go with doing the sub and super scripts using uni-codes. Although this is possible as discussed earlier in LO chart titles, using the special character menu and inserting the superscripts is cumbersome as of now. So the best work around is to use an online sub or superscript generator (such as lingojam.com) to type away the portion of title to sub or superscript, generate the code and paste it in the LO chart title. The chart titles with uni-coded sub/ superscript are totally compatible with MS office and many other compatible alternate suites.
Please be aware that many of the online office suites such as Google sheets or even MS Office online lack the capability of inserting super/ subscripts in chart titles. The former even suggests using uni-codes for doing this.
Hope the development team of LO addresses this issue so that this excellent suite attracts more students and scientists to use the LO charts for preparing publication ready papers, which may demand 100% ms office compatibility.

1 Like