Apache OpenOffice (AOO) Bugzilla – Issue 82676
Graph lines disappear when legend was changed
Last modified: 2013-02-24 21:21:00 UTC
I have an X-Y chart with data and correlation line displayed. I attempted to resize the Y-Axis font size and embolden it. The data points and correlation line disappeared immediately when finished. I am submitting the Calc sheet entitled "GRAPH BUG" to illustrate the bug.
Created attachment 48947 [details] Graph Bug Illustration
There are two sheet tabs at the bottom. The tab labeled ORIGINAL is the beginning point. After only changing the y-axis label the graph changed to that of the sheet named PROBLEM ILLUSTRATED. The particular graph that I was working on is the bottom graph, entitled "OPS GIVING TREND (LAST 4 YEARS Data projected as Exponential Regression."
wrong component, changed to Chart and re-assigned
->joeconner: The attched bug doc seems to completely broken. All charts are empty after double clicking, as there is no data attached to them. So I cannot reproduce the described problem.
The data is in rows 1 and 2 on each sheet. The sheet "ORIGINAL" has two graphs. The first occupies approximately rows 10 through 20. The second occupies approximately rows 27 through 47. When I clicked enough times to open the y-axis label "OPS GIVING" I was able to enlarge the size of the letters. When I clicked outside the label to retain the changes, then the X-Y data points disappeared along with the exponential trend line. The two sheets, "ORIGINAL" and "PROBLEM ILLUSTRATED" contain "before" and "after" effects of the label change. If the data has somehow lost the data attachment, then that is precisely the nature of the bug. Changing the letter size of the y-axis label causes the data to uncouple from the graph. When you initially open the file, you do see the lines and data points on the chart don't you? They did not get there by some hocus-pocus.
Created attachment 49013 [details] Original file before label change
I have just attached a copy of the unaltered original file before I changed the Y-axis label font size. This one has the data attached so reproducing the problem should work. It would probably be illuminating to examine the difference between the files to discover just how the data became decoupled. That is above my ability.
Additional thought, maybe it has nothing to do with the bug, BUT: When I initially tried to modify the font of the y-axis TITLE, I entered the text box and changed the size with the Object Properties context drop-down Character Tab, and clicked on the outside to make the change, initially the y-axis label did not modify. Instead the right hand LEGEND box reflected the change. I used the undo button, reentered the y-axis title box and made the changes, this time the change was applied to the correct text. Additional observation #1: The arrow keys can move the title box and the legend box but using the mouse to drag and drop will not leave the boxes where they are dropped. They spontaneously move elsewhere by themselves. Additional observation #2: You cannot grab the green tabs to resize the box. You do not get a double-arrow cursor. Only the "+" cursor which to move the box.
Joeconner, when you see the lines and data points in Graph Bug.ods then these are only replacements images. The real chart comes up after double click. And in that document all charts have lost their data, not only the one where you manipulated the title size. With the new document your problem is still not reproduceable. Changing the font size of the y axis title or setting it to bold works fine. Please try to reproduce the problem in your environment and give a detailed description of what you have done. What version of OOo do you use? Is the system really WinXP?
@iha: pls cover this issue. For me its works fine. thx
fixing Caps-Lock problem in subject
Yes, my operating system is really Win XP Pro with SP2. OS Specs: Name : Microsoft Windows XP Professional|C:\WINDOWS|\Device\Harddisk0\Partition1 Description: WinXP Manufacturer : Microsoft Corporation Version : 5.1.2600 CSD Version : Service Pack 2 Computer Specs: Name : AMD Sempron(tm) Processor 2800+ Description: x86 Family 15 Model 44 Stepping 2 Manufacturer : AuthenticAMD Version : Model 12, Stepping 2 DataWidth : 32 Bits Socket Designation : Socket 940 Type : Central Processor CPU Id : 078BFBFF00020FC2 Bios: Name : Phoenix - AwardBIOS v6.00PG Manufacturer : Phoenix Technologies, LTD Version : VIAK8M - 42302e31 Memory: Name : Physical Memory Memory Capacity : 1024MB Memory BankLabel : Bank0/1 Memory TotalWidth : 64 Bits DataWidth : 64 Bits Motherboard: Name : Base Board Manufacturer : MICRO-STAR INTERNATIONAL CO., LTD Product Name : MS-7181 Version : 2.0
->joeconner, could you reproduce the problem yourself? If so, please provide a description of the necessary steps, so that others can reproduce your problem.
Please *unmark* the issue as resolved. I *can* reproduce the bug and have done so on the following using the http://www.openoffice.org/nonav/issues/showattachment.cgi/49013/GIVING%20TREND%20STUDY%202007.ods attachment: Linux: OpenOffice 2.3 Linux: Ubuntu OpenOffice 2.3 Linux:Professional: StarOffice 8/8 Windows: Go-oo OpenOffice 2.3 I *cannot* reproduce using StarOffice 8/7 (Windows or linux). However I also discovered the following: 1. The document contains a style type called "Excel_Builtin_Currency". If this style type is deleted, and the entire spreadsheet is then set to "Default", the datapoints remain and the graph can be edited. I am unsure of where this "Excel_Builtin_Currency" comes from, but suspect that it is perhaps part of an OOo Excel to OOo filter. 2. If I save the document as is to an MS Excel .xls file, I can reopen in OOo, the datapoints are preserved *and* I can then edit the graph without removing the "Excel_Builtin_Currency" style. 3. If I open the saved .xls file in MS Excel 2002, the file opens fine and all datapoints are present. 4. If while in Excel 2002 I click on cell A1 and then select: Format|Style I get a rather odd style. The style name is "Currency", and it is listed as number format w/no borders. But the number format is listed as "Custom" and is given as mm:ss, indicating that the style is actually a time format (minutesminutes:secondsseconds) rather than a traditional currency number format. 5. If I attempt the above on the http://www.openoffice.org/nonav/issues/showattachment.cgi/48947/Graph%20Bug.ods file I find: a. Removing "Excel_Builtin_Currency" and reformating all to "Default" does not correct the problem in any of the above mentioned programs (including StarOffice 8/7). b. If I save the Graph%20Bug.ods file to an .xls and then attempt to open in MS Excel 2002, Excel hangs and the file does not ever open completely. To reproduce all that is needed is to follow the original bug description and double-click on a graph with datapoints. The datapoints disappear with the "Excel_Builtin_Currency" style in the spreadsheet.
Added note: I've found that on the "Going Trend Study 2007.ods" file, if I format all of the cells in Row 2 to Currency, the OPS Giving 9 Year Trend graph can be edited and the problem goes away. Not so on the Graph Bug.ods file. Tested in WinXPPro & linux.
I cannot reproduce the described problems with document Going Trend Study 2007.ods in OOo 2.3 with windows: After double clicking the charts the data is still visible. Changing the font size of the y axis and of the y axis title works also fine. observation #1 is a different issue 79262 observation #2 is a different issue 76724 The document Graph Bug.ods is indeed broken. The data is decoupled from the spreadsheet. When double clicking on any chart in this document all data vanishes. But the file does not tell anymore why the data is decoupled. So the problem still cannot be reproduced. Maybe we need the original excel file? Sorry we cannot solve the problem when we cannot reproduce how it happens. What indeed sounds strange is that the legend should have been changed while the axis title was edited. Maybe you can reproduce how that has happened?
No response, so i will close this issue. Feel free to reopen if its possible to submit more information.