Summary: | FORMATTING single characters in titles, axis titles and other labels in charts is not possible | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Francisco <franciscoadriansanchez> |
Component: | Chart | Assignee: | Balázs Varga (allotropia) <balazs.varga991> |
Status: | VERIFIED FIXED | ||
Severity: | enhancement | CC: | bruno.binet, divaker, franciscoadriansanchez, ign_christian, jeffdchang, jmadero.dev, kantert, LibreOffice, lur78tbfhpw, mattia.b89, mhillat, ovari123, robinson.libreoffice, stephane.guillou, thb, timofeev.i.s, yfjiang |
Priority: | medium | Keywords: | difficultyInteresting, needsDevEval, skillCpp, topicUI |
Version: | Inherited From OOo | ||
Hardware: | All | ||
OS: | All | ||
See Also: |
https://issues.apache.org/ooo/show_bug.cgi?id=6521 https://issues.apache.org/ooo/show_bug.cgi?id=1489 https://bugs.documentfoundation.org/show_bug.cgi?id=58038 https://bugs.documentfoundation.org/show_bug.cgi?id=78027 https://bugs.documentfoundation.org/show_bug.cgi?id=123206 https://bugs.documentfoundation.org/show_bug.cgi?id=134985 https://bugs.documentfoundation.org/show_bug.cgi?id=143581 https://bugs.documentfoundation.org/show_bug.cgi?id=145309 https://bugs.documentfoundation.org/show_bug.cgi?id=160517 |
||
Whiteboard: | target:24.8.0 inReleaseNotes:24.8 | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108542 | ||
Attachments: |
Sample Document
buggy text box inside chart |
Description
Francisco
2011-07-07 16:07:33 UTC
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: http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1 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 > affected. 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. @Ivan: What do you think? Possible EasyHack or pie in the sky? Created attachment 71204 [details]
Sample Document
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) > @Ivan: > 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: https://wiki.documentfoundation.org/Vote_for_Enhancement#Bug_39052_-_FORMATTING_single_characters_in_titles.2C_axis_titles_and_other_labels_in_charts_is_not_possible Cheers Thank you chtfn, I have voted right now. @chtfn 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. @Francisco > 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. @chtfn > 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 4.0.4.1 (Win7 32bit) @Christian I can't see the workaround you are talking about. I just tried in LO 4.0.3.3, 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? Hi Ign. (In reply to comment #22) > @Francisco > > 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. > @chtfn > > 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 4.0.4.1 (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 4.2.7.2) . 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 Christian (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 4.2.7.2) . 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 > Christian Christian: If you haven't done it already, please vote this bug in the "Vote for Enhancement" page: https://wiki.documentfoundation.org/Vote_for_Enhancement#fdo.2339052_-_FORMATTING_single_characters_in_titles.2C_axis_titles_and_other_labels_in_charts_is_not_possible 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) [NinjaEdit] 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. *** Changing priority back to 'medium' since the number of duplicates is lower than 5 Maybe this feature (axis titles) should just disappear and be replaced by text boxes? And with an Excel file (opened and re-saved in LO), the labels would be converted to text boxes. At least, formatting would not be lost. Reproduced in a recent master build: Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: b2130ad3fda841c68a0436fbddf29bcedede0af5 CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2021-08-09_13:03:07 Calc: threaded *** Bug 143581 has been marked as a duplicate of this bug. *** Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/4f994cec388377cc5c2bddb804bd92eb4cd7dc8d tdf#39052 - Chart: make characters formatable in editable chart textshapes It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Balazs Varga committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/55e9a27afd2d6a13cf76b39641bf121c3ec4b45c Related: tdf#39052 - chart ooxml: export formatted chart titles It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. (In reply to Commit Notification from comment #42) > Balazs Varga committed a patch related to this issue. > It has been pushed to "master": > > https://git.libreoffice.org/core/commit/ > 55e9a27afd2d6a13cf76b39641bf121c3ec4b45c > > Related: tdf#39052 - chart ooxml: export formatted chart titles > > It will be available in 24.8.0. > > The patch should be included in the daily builds available at > https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More > information about daily builds can be found at: > https://wiki.documentfoundation.org/Testing_Daily_Builds > > Affected users are encouraged to test the fix and report feedback. I think I should give it a try... |