Created attachment 56588 [details] Chart Views I imagine this will be down the list of problems. I have a spreadsheet calculation file I created in MS Works 7.0. One of the associated charts was created using a format forsaken by MS for inclusion as a template in MS Office 2003 and 2007. Don't know about 2010. I have attached a picture that shows that LO misreports the chart. Both Office 2003 and 2007 report the chart format correctly, even though it is not presented as a template. I can think of a thousand uses for this format. Would be a nice twist to see it incorporated into the templates for a future version of LO. Primary uses would be revenues v. costs by month or year, etc., but there are numerous other examples of cases where total events can be compared against one type of the event over time, etc. Thanks for the hard work from all the developers at LO...
Sorry...in the pic, only the Office 2003/2007 chart should be compared with the LO chart for accuracy. The Works version pic of the chart was taken from an older version of the file. The file is updated annually, and I don't update the Works version anymore...
OK, and what is your problem? Also you may want to attach actual documents instead of screenshots.
The problem is the chart data is misreported. Sorry, it wasn't clear. The chart format is also altered. The chart data is misreported in LO=> The 2nd part of the screenshot shows how the chart appears in Excel 2003/2007, data represented correctly. The 3rd part of the screenshot shows how the format changes and how the data is misreported in LO. In my first comment I really should have said "I have attached a picture that shows that LO misreports the chart" + data, rather than just "I have attached a picture that shows that LO misreports the chart." The only way to duplicate the problem would be to import a chart from Works 7 to Excel 2003 and then to LO. However, Works 7 didn't embed charts in spreadsheet worksheets. They were created, then accessed through a menu command. From there they could be deleted, also. MS 2003 must have contained the template for the chart now that I think about it, or I wouldn't have been able to recreate it after transferring the spreadsheet from Works 7 to Excel 2003. I now use Excel 2007, which does not have this chart format in its templates, but I have kept the file in the 2003 format. The picture shows how the chart data is misrepresented in LO. If you like I could post the Works 7, Excel 2003, and LO versions of the entire file. However, to see the chart in Works 7, you would have to have the program. The Works 7 files can actually be saved in the Excel 97/2000 format, but the charts are omitted in the format change. Just thought you guys might appreciate an opportunity rather than another full blown bug. This chart format is one of my favorites, and in reporting the bug I thought I might be able to get in 2 cents for including it in a later version of LO.
Created attachment 56683 [details] Chart in Workbook Without Macro Pic shows that without a macro in an .xls, the chart is recreated successfully in LO. I did notice a chart creation option for a chart similar to this one which was a template in Works 7.0. Just my opinion, but somewhere down the line, I would like to see this exact format as a template...one column green numbers/one column red balls. It would be great to have the columns side by side and the chart be created easily. Again, just 2 cents. I know this is a small issue. Just for the record I would like to say that the charts and graphs interface in LO is nice. Seems to me to be way ahead of OpenOffice...
This should actually go before the pic comment. Didn't know the pic comment would show up down here when I decided to post the pic first, sorry... I have a short update...I have an earlier version of this file from around 2008, where the chart reports correctly in LO. The most recent version of the file is the one that shows the problem in LO. The key difference is that there are 2 macro driven buttons in the latest version. The buttons simply move to bottommost cells in a portion of a column of data. This second screenshot (posted above) shows that LO recreates the chart correctly from the an .xls version of the file without a macro. The original shows what happens with a macro in the sheet. I think it can be safely said that opening an .xls in LO which has a macro can cause funny things to happen... Macro issue aside, I really would like this format of chart to be available as a template in LO...
Charles: this bug is very confusing to read. Could you please try the following: * Install the latest LO and see if this bug is still valid at all * if that should be the case, please attach a testing file and provide a short description what's misinterpreted by LO * or even consider setting this bug to invalid and opening a new clean bug starting from scratch. I think that should increase the chances of this getting fixed. Thanks.
James: I think the problem was that LO reported one of the series' of data for this type of graph incorrectly ("Chart Views" attachment). The LO green arrows in pic 3 of "Chart Views" don't match up with the red dots of the Excel conversion (pic 2 of "Chart Views"). The red dots are the correct values. Apologies, the data for the Works 7.0 document ("Chart Views" pic 1) wasn't the same. I must have been hurrying and was likely there just showing the template. In the Excel and LO graphs the data was the same, having been updated since the time of the Works file, which is an old reference file. "Chart in Workbook Without Macro" is there to show that when the .xls file is opened in LO and, when there is no macro for the worksheet in the Excel version, there is no problem. Don't know why the macro in the Excel sheet caused the problem as it's just a button to go to a location on the sheet. It was added to the file shortly after it was converted from the Works 7.0 (.wks) format. Then I opened this macro enabled .xls in LO and noticed the problem. At the time I posted this, I didn't realize that the macro language of LO was in flux and not very functional. Just one last thing. The main thing I would like to see come from this is to bring back to life this old template from Works 7.0 (pic 1 "Chart Views"). It's a data v data chart (bars v dots) that can be used to compare very effectively costs to revenues or costs to profits. It could be improved of course and jazzed up. Just a by the way...I like the interface for selecting a chart type in Works 7.0 ("Chart Views" pic 1). Don't know how much anyone would agree with me, but it was quite nice I thought. I will try to see if I can duplicate the problem in the latest LO release.
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/FDO/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team
This is something I noticed in LO 3.4.5. It's a problem where data in a chart was being misrepresented in that version of LO when a Works 7.0 file was opened in LO. Please don't be confused by the first pictures (set of 3). The first picture is there only to show the TYPE of graph from the creation menu in Works 7.0. The actual graph in the background does not use the same data as the charts in the next two pictures. In the 2nd and 3rd picture it is clear that the chart results do not match as they should. The MS Excel 2003/2007 conversion shows the correct results for the graph and the LO version is clearly showing different results. The second picture set (2 pictures) is to show that the graph worked fine in a Works 7.0 file that was saved as .xls and then was opened in LO 3.4.5. The problem was only with Works 7.0 files opened directly in LO 3.4.5. I apologize that I cannot confirm this bug in LO 4.x. My computer with all the files on it is down, and I am on an old 1.5 GHz P4 PC at the moment... To test this, create this type of graph in Works 7.0, then open the file in LO. Then compare the charts. Again, sorry I cannot be of more assistance. If I can get my PC running again, I will try to remember to take another look at the issue...
1) Works has been discontinued 2007 (almost 7 years ago). 2) No actual file to even confirm this bug. 3) Not sure that even if this bug was confirmed it would not be a WONTFIX case, since developer time is somewhat rare. This bug might probably be laying around for years and then get set to wontfix once Works has been dead for 10 years or so. Setting to INVALID. If you have any chance of attaching a document and exact reproduce steps please re-open this bug and we'll try to confirm it.