I have tried to search for this bug in Bugzilla (and even Google) but with no luck. The only reference I've found is in OOo bugzilla. This bug is related to (or maybe I should say it's the same):
I'm really, really sorry if this is a duplicate, but I have not found a bug report concerning this one.
As you see, this bug is pretty old. I found it in Go-OO 3.2 and it's still present in LibO 3.3.3 (Windows x86, Linux x86_64) and Lib 3.4.1 (Windows x86).
How to reproduce it:
1) Open Calc
2) Make a scatter chart with 2 series and add the title of chart and axes title there
3) Open the OLE object, and then try to edit the format of a single character of the chart title or axes title.
4) Select that character and try to change its format.
5) There ISN'T any UI for that (I mean: one would want to change font and size as in simple text)
6) Select Format option from toolbar or via right click.
7) Select "font format tab" and change font type, size, and/or kind (bold, italic, etc) and exit.
8) It's impossible to select a "position" for the character, as the tab "position" is not shown in the windows
9) The format is applied to all text, instead a single character.
10) Hotkeys: Ctrl+B, Ctrl+I, Ctrl+P, etc, doesn't work
11) Customise the format toolbar present when editing charts adding "Character" button.
12) Select a single character again and the press the format button
13) The preview doesn't show the selected character.
14) There's now a "position" tab, being able to select superscript/subscript format.
15) The format is present in the chart title/axes title, but it disappear after exit the editing mode.
1) Make a text box from the draw toolbar.
2) and give it the text of the titles you need
3) the text remains (and "character" button is very helpful), but it's not well shown when sharing files with Excel.
I'm a PhD student who works a lot with charts of different variables. Formatted text in chart titles/axes titles is very often in physics (variables ARE in italics, units (ft/s, ºF, for example) are normal text, and there are sub/superscripts very frequently).
Although I used to use formatted titles charts and axes titles, this is not critical at all for me but, it's quite sad because it seems to be a "so basic" feature that I feel it's a pity it hasn't been implemented yet. And i'm not talking about "step 5", I'm talking about the ability to do it.
So I haven't found a report for this bug andI feel it was needed to make it.
Regards. And again, sorry if this is not the place to request this kind of features (but I haven't fund any other place).
Reproduced on LibreOffice 3.4 340m1(Build:12) for OpenSuse Linux.
Thank you for the thorough overview. It does seem like there is a problem fixing text boxes in charts in Calc, while editing text boxes anywhere else is ok. Hopefully this bug gets fixed soon.
(In reply to comment #1)
> Hopefully this bug gets fixed soon.
I can't deny it, I'm very happy to hear (read?) that! :D
[Reproducible] with "LibreOffice 3.4.3 RC2 - WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:302)]"
Especially subscript or superscript IMHO would be required urgently.
Heritage from OOo
This is an enhancement request, definitively not a "3.4 most annoying bug"
(In reply to comment #3)
> This is an enhancement request, definitively not a "3.4 most annoying bug"
Ok, I understand. I was just asking.
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Still reproducible with LOdev 3.5beta2, Build ID 8589e48-760cc4d-f39cf3d-1b2857e-60db978 on MS Windows XP SP3 x86 runinig on VirtualBox
This is a more general problem. I wonder whether also other objects might be affected.
Status of this bug report has been modified wrongly by a bulk change.
(In reply to comment #7)
> This is a more general problem. I wonder whether also other objects might be
So far, I have found it *only* in "chart" and "chart axes" titles. There are other problems with text boxes some times, but I think they are different.
> Status of this bug report has been modified wrongly by a bulk change.
Do you mean 3.4->3.5?
Don't want to be a ungrateful nor sound irritating, but, how possible is to fix this bug for 3.4.6? Just asking
Or maybe 3.6.5...? :-|
No, it's rather serious enhancement. Some people have been waiting for theirs about 12 years already.
Who needs that really will find out that he can integrate Draw Text boxes into the Chart.
But indeed, I think that would be a nice enhancement. I think it would be easy to enable corresponding context menu items, but the challenge will be to get that working without conflicts with the chart Title (and so on) edit menu. Currently I do not know whether there exist needs to keep these Chart-Title-Dialog functions (may be for some automated functions?). But it should be easy to disable the fields in the Chart-Title-Dialog after the text box has been edited as Draw Text box.
What do you think? Possible EasyHack or pie in the sky?
Created attachment 71204 [details]
Shows that the Title is something very similar to a Draw Text Box, but with limited edit capabilities
Created attachment 71210 [details]
buggy text box inside chart
> Who needs that really will find out that he can integrate
> Draw Text boxes into the Chart.
Yes, that's what I indicated in the proposed "workaround", and it is what I do when I have to present 1 or 2 charts.
But I use to work with many charts, in general, between 10 and 20 per paper. And I don't really know how many of them are in my thesis. In this cases, working with Draw text boxes is quite tedious, because adding all the needed titles for many charts is easier in the corresponding window.
But it's also tedious because shortcuts doesn't work, as I say in step 10 (for both, native and Draw textboxes). Maybe this is a different bug which needs a separate report. If that's the case, I'll do it.
Other problem with Draw textboxes is that its buggy, at least in v-3.5.6 (at least in both O.S. versions I've checked: Windows XP 32b, Kubuntu 12.04 64b). For example, this is what I see once I opened the chart you added in sample.odt through a double click (file 1.png). There are other problems with Maybe this is another bug...? I should check v-3.6.x but I think the problem is the version that Kubuntu ships.
Thank you Rainer, realized I uploaded the file with wrong class but I did not how correct it.
(In reply to comment #12)
> What do you think? Possible EasyHack or pie in the sky?
I don't know how does this stuff work, so to me it's pie in the sky. :( I can't provide any code pointers.
*** Bug 61676 has been marked as a duplicate of this bug. ***
This is still a problem in 4.0.2
As a research assistant in biology, I find it very frustrating not to be able to format as subscript of superscript for chemical formulas for example. This prevents to use the graphing capabilities of LO for publication-level graphics.
I added this to the "Vote for enhancement" page on the LibreOffice Wiki, if anyone is interested in giving this more visibility:
Thank you chtfn, I have voted right now.
Besides the proposed workarounds (adding custom Draw textboxes, which can be formatted), you may also use special characters of typefaces that has their own sub/supperscripts, like Libertine or Biolinum. Of course you cannot insert them from inside the chart, but you could insert them in a cell, and den copy/cut them in chart textboxes. Yes, tricky, It's just another option.
> Created attachment 71210 [details]
> buggy text box inside chart
So this bug tells about FILESAVE problem? Workaround: double-click textbox > click outside textbox > double-click textbox again > click outside textbox
Saving as xls or xlsx generates different results.
> As a research assistant in biology, I find it very frustrating not to be
> able to format as subscript of superscript for chemical formulas for
> example. This prevents to use the graphing capabilities of LO for
> publication-level graphics.
Though currently it can't be edited using 'Text Formatting' toolbar, we can do this as workaround: double-clicking text box > mark the texts > right-click > Character > Font Position
LO 22.214.171.124 (Win7 32bit)
I can't see the workaround you are talking about.
I just tried in LO 126.96.36.199, with a text range in the title of a chart. All I can see is "Format title" and "Position and size", but none of them let you use subscripts of superscripts...
Maybe I did not understand?
(In reply to comment #22)
> > Created attachment 71210 [details]
> > buggy text box inside chart
> So this bug tells about FILESAVE problem? Workaround: double-click textbox >
> click outside textbox > double-click textbox again > click outside textbox
> Saving as xls or xlsx generates different results.
Bug 58027 had been already filled for this issue.
> > As a research assistant in biology, I find it very frustrating not to be
> > able to format as subscript of superscript for chemical formulas for
> > example. This prevents to use the graphing capabilities of LO for
> > publication-level graphics.
> Though currently it can't be edited using 'Text Formatting' toolbar, we can
> do this as workaround: double-clicking text box > mark the texts >
> right-click > Character > Font Position
> LO 188.8.131.52 (Win7 32bit)
If you read the detailed steps for reproducing this bug, you will find that I have already stated that "Character" button doesn’t work for native chart textboxes. In fact, right click doesn't show "Character" option. You must customize a toolbar for that (step 11). But even in that case, as the title states, it is not possible to format single characters of native chart texboxes. Any format given to the native texbox (title, subtitle, axis titles) is given to all the text.
And, as a workaround, one must create a custom textbox, which *is* formateable. The problem with this arises when one has to work with many, many charts. My thesis has 79 figures, of which 70 could have had subscripts and italic individual characters in their axis title. But adding custom textboxes (which are not automatically centred as native texboxes), and formatting them, one by one, through "right click"->"character" is really tedious (and that's the reason of bug 58038). At the end, I preferred something a little less "professional looking" than doing that work. This is, of course, my personal experience.
@chtfn & Francisco
I'm sorry for the mess..I did testing with Draw/custom textbox. I didn't read clearly, & still have to learn alot :-)
(In reply to comment #25)
> @chtfn & Francisco
> I'm sorry for the mess..I did testing with Draw/custom textbox. I didn't
> read clearly, & still have to learn alot :-)
Don't worry :-)
I'd like to share my thoughts about this issue. I'm not a developer but I have had an idea and I'd like to share it.
This issue is a bit strange to me: native chart textboxes seems to behave completely different from the rest of the objects that can be drawn even inside charts. I think the reason is both textboxes have been coded separately, while chart texteboxes are more _basic_.
My idea is that, if this is the case, maybe it is easier to use directely Draw textboxes when the "chart title", "axis title" options are called, instead of _repairing_ Chart textboxes.
(maybe it's obvious, anyway since nobody says anything... :-| )
In order to limit the confusion between ProposedEasyHack and EasyHack and to make queries much easier we are changing ProposedEasyHack to NeedsDevEval.
Thank you and apologies for the noise
It's really sad that this hasn't been enchanced after such a long time (still not possible in 184.108.40.206) . I'm an engineer-to-be and often have to deal with sub- or superscripted things in diagrams.
I hope someone will try to fix it.
Thanks in adavance
(In reply to christian.pietzsch from comment #29)
> It's really sad that this hasn't been enchanced after such a long time
> (still not possible in 220.127.116.11) . I'm an engineer-to-be and often have to
> deal with sub- or superscripted things in diagrams.
> I hope someone will try to fix it.
> Thanks in adavance
If you haven't done it already, please vote this bug in the "Vote for Enhancement" page:
You only need an account in the TDF wiki, and edit that page adding your reason to vote for this bug.
not to be rude but VOTE literally means nothing at all...that page is not looked at by developers, has no impact on how fast an issue is resolved, etc...
That being said - this will only be implemented if a developer takes interest in it, someone cc'ed on this bug submits a patch, or someone(s) pays a third party to implement it.
Again - not being rude, just trying to explain how things work. Thanks
Migrating Whiteboard tags to Keywords: (needsDevEval difficultyInteresting skillCpp topicUI)
Still an issue on the 5.0 branch (Linux)
*** Bug 78025 has been marked as a duplicate of this bug. ***
Issue still present on 5.2.5.
*** Bug 108901 has been marked as a duplicate of this bug. ***