Apache OpenOffice (AOO) Bugzilla – Issue 106736
Chart data ranges messed up,when Stock Chart selected in SRB
Last modified: 2013-02-24 21:22:31 UTC
It is true for OOO320_m4, and DEV300_m63. Not first priority I issued as m63 bug. It is a part of my testing with Stock Charts, and as I try to find some problems in more details raised up in issue:103589. Preparation: - Open database file attached to this issue - Go to the report section - Create new report in dsign mode, add report header/footer to report, - Select report footer, - Click into Report toolbar, select Chart, - Draw rectangle on Report footer, Chart will be inserted-Open - Go to the Chart properties Data tab, - Select Content type "Table", - Select "Content" Table1, the chart will show data. - Double click on Chart, opens in edit mode, check Chart Type = "Bar", and Data ranges, First Column as label allowed, and Data series tab: all other fields listed (Volume,Open,Low,High,Close) - Save it as "Empty", - Or open "Empty" Report in attached file. Bug: - Double click on Chart, opens in edit mode, - Set chart type to Stock, and select Type "Stock Chart Type1", press OK, - Open Data ranges, click to the data series, Data series you can find: Low, Unnamed series; and data ranges messed up. The changed chart can be found in "NEW_Type1_after_chart_type changes" report. If you opens "Empty_with_bar_chart", and change Chart type to "Stock Chart Type2" or "Stock Chart Type3", the data ranges messed up in different way. Only if you select "Stock Chart Type4" the changes will happens nearly as you expected. (Only thing what is wrong is a data series can not be set as in Chart in Calc, only selectable from field names, which is a separate issue, and I will submit)
Created attachment 66021 [details] example database created in m4
confirming, assigning, targeting
@r4zoli, for stock charts the data has to be arranged in a special way if it should work out of the box: stock 1: Low, High, Close stock 2: Open, Low, High, Close stock 3: Volume, Low, High, Close stock 4: Volume, Open, Low, High, Close So there is no bug here. Just the given data is not suitable for default creation of a stock 1 chart. The data is only suitable for a stock 4 chart.
->setting to 'works for me'
I created queries to arrange data as described by iha, and created new reports with stock charts, without problems. Closing.