To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=65998
User rainerbielefeld changed the following:
What |Old value |New value
================================================================================
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords|needmoreinfo, oooqa |needhelp, oooqa
--------------------------------------------------------------------------------
OS/Version|Windows 98 |Windows, all
--------------------------------------------------------------------------------
Priority|P4 |P3
--------------------------------------------------------------------------------
Subcomponent|ui |open-import
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Jun 5 07:12:56 -0700
2006 -------
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.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
