Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | OpenOffice.org Calc, Candlestick chart plotting | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Product: | General | Reporter: | ybdsg <yawbanglow> | ||||||||
Component: | chart | Assignee: | AOO issues mailing list <issues> | ||||||||
Status: | CONFIRMED --- | QA Contact: | |||||||||
Severity: | Trivial | ||||||||||
Priority: | P3 | CC: | IngridvdM, issues, rainerbielefeld_ooo_qa, tony.galmiche.ooo, yawbanglow | ||||||||
Version: | 3.3.0 or older (OOo) | Keywords: | needhelp, oooqa | ||||||||
Target Milestone: | --- | ||||||||||
Hardware: | PC | ||||||||||
OS: | Windows, all | ||||||||||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- | ||||||||
Developer Difficulty: | --- | ||||||||||
Attachments: |
|
Description
ybdsg
2006-06-01 09:15:58 UTC
I can't reproduce it. Pls explain incorrect and attach the doc. thx Created attachment 36850 [details]
Chart ploted using MSExcel2000 Vs OOo-Calc 2.0
@ybdsg: Pls attach your spreadsheet with chart! Created attachment 36913 [details]
Excel file plotting of the candlestick chart
Created attachment 36914 [details]
Ooo File plotting the candlestick chart
I can confirm unexpected chart view with "2.0.3RC5 German version WIN XP: [680m5(Build9036)]" and also "1.1.4 (German) WIN XP: [645m52 (Build 8824)]". To be sure that no import effects disturb my investigations, I also tested with a new spreadsheet using values from 'Candlestick-Ooo.ods': same result. Unfortunately in HELP I can't find any information how OOo stock chart (= candle stick chart) should work, and I do not understand hints on <http://api.openoffice.org/docs/common/ref/com/sun/star/chart/StockDiagram.html> My knowledge concerning stock charts, which seems to meet with the way EXCEL will show them, is: 1. We have some values for different times (or dates) ('Candlestick-Ooo.ods': B2:B13) 2. Sort order of those values is "time" 3. Stock chart for those values shows 3.1. Range Min ... Max (2,8382 ... 4,2147) as a vertical line 3.2. Range between opening course and closing course as a rectangle 3.2.0 Opening course is first value (B2) 3.2.1 Closing course is last value (B13) 3.2.2. Rectangle black, if opening course > closing course 3.2.3. Rectangle white, if opening course < closing course 3.1. is as expected 3.2. is as expected 3.2.0 "Opening course" works as expected 3.2.1 "Closing course" does NOT work as expected, it seems, that OOo always takes value No. 4 (here: B5) as closing value - I can't understand that 3.2.2 "Rectangle black" works as expected (bot see 3.2.1) 3.2.3 "3.2.3. Rectangle white" works as expected (bot see 3.2.1) Currently, this definitively is a EXCEL import problem, because OOo does not show a chart as EXCEL does, so I change Subcomponent. I believe, this is a general problem, because I can not find any reason why Closing value always should be the forth one in the table, but that should be decided by someone with more chart design knowledge. I wasn't aware yet, that it is possible to have more than four values in a candlestick chart in MS Excel. OOo Chart expects the values in a fixed order: Open Low High Close. Additional values are ignoed. See service description: http://api.openoffice.org/docs/common/ref/com/sun/star/chart/StockDiagram.html To allow differently structured data is an enhancement. Of course, this enhancement makes much sense. ->ybdsg: How did you create the stock-chart in Excel? When I select the data in the Excel and try to create a stock chart from this, I get an error saying the data must have the layout "Open, High, Low, Close" and refuses to insert the new stock-chart. Even, if I don't select the first row (containing the years), which is interpreted as numbers (stock courses) per default. Hi bm, I actually safed the original Ooo file into Excel file. The chart was automatically ploted in Excel. I also managed to repeat your error in Excel when I attempt to plot the chart fresh from the data series. Changed Target to 2.x back to later change owner |