https://bugs.freedesktop.org/show_bug.cgi?id=45603
--- Comment #7 from Charles McCullough <[email protected]> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
