Hi Ingid ,
thanks for providing the hack ..it is never a good Idea to hack ; but if i
have no other choice then i'll try your method.
there is a small issue i'm facing with the diagram vertical grid : i want to
have a dashed line vertical grid . i wrote code to get this effect (see code
below) .it indeed displays the dashed line for vertical grid ..but the
problem is when i tried to play with the attributes of LineDash, it always
gives me same dashed grid.
it seems that this line code is not executed : xGridProp.setPropertyValue(
"LineDash", aDash );
because if i comment this line code i get the same grid as if i don't
comment it .
can you point me what is the issue with LineDash ?
thanks .
code:
// x major grid
XPropertySet xGridProp = (XPropertySet) UnoRuntime.queryInterface(
XPropertySet.class,
( (XAxisXSupplier) UnoRuntime.queryInterface(
XAxisXSupplier.class, maDiagram )).getXMainGrid());
if( xGridProp != null )
{
LineDash aDash = new LineDash();
aDash.Style = DashStyle.ROUND;
aDash.Dots = 2;
aDash.DotLen = 10;
aDash.Dashes = 1;
aDash.DashLen = 200;
aDash.Distance = 100;
xGridProp.setPropertyValue( "LineColor", new Integer( 0x000000
));
xGridProp.setPropertyValue( "LineStyle", LineStyle.DASH );
xGridProp.setPropertyValue( "LineDash", aDash );
xGridProp.setPropertyValue( "LineWidth", new Integer( 30 ));
}
Ingrid Halama wrote:
>
> Hi,
>
> othman wrote:
>> Hi Ingrid,
>> I believe the zooming feature might be beyond the scope of my project
>> requirements now..
>
> Ok.
>
>> anyway i wish if you can think adding the feature of scaling the dates
>> x-axis values for candle charts : date objects are a widely used data
>> type
>> and offering this feature of scaling date ranges would be a good Idea.
>>
>
> I agree and I know. There are still a lot of issues of similar quality.
> Work is ongoing.
>
>> i have a small issue :
>> There is concern on the x-axis labels. I need to display only one date
>> label for each month. For instance, if the chart starts from Dec 6 2007,
>> there should be labels of 12/6/2007, 1/6/2008, 2/6/2008, 3/6/2008,
>> 4/6/2008,
>> 5/6/2008 on x-axis. and other date labels should not be displayed on
>> x-axis
>> . how can i implement this ?
>>
>
> At the moment there exists no good/normal/acceptable way to do that
> (neither API nor user interface). You can only try to hack:
>
> Assuming you have a data point for each day (ordered in time) and you
> have a cell range containing all those days you can try the following:
> Copy all the dates to another location in the calc. Calculate which of
> the days you want to display and which not. Clear the cells with the
> dates that you do not want to display. Use the newly created cell-range
> (including all the cleared cells) for display of the categories. To use
> the new range for category display you need to do the following:
> Query the com::sun::star::chart2::Diagram for interface
> XCoordinateSystemContainer
> (http://api.openoffice.org/docs/common/ref/com/sun/star/chart2/XCoordinateSystemContainer.html).
> Get the first coordinate system:
> http://api.openoffice.org/docs/common/ref/com/sun/star/chart2/XCoordinateSystem.html.
> At the coordinate system use method getAxisByDimension(0,0) to get the
> primary x axis
> (http://api.openoffice.org/docs/common/ref/com/sun/star/chart2/XAxis.html).
> At the axis get the scale data by using method getScaleData
> (http://api.openoffice.org/docs/common/ref/com/sun/star/chart2/ScaleData.html).
> At the scale you will find a member "Categories" of type
> XLabeledDataSequence. You know already how to create such objects from
> cell ranges. Set the role of the values to "categories" in this case.
> Then set the new sequence to the Categories member and set the changed
> scale back to the axis (setScaleData). Be careful when playing around
> with the other scale settings as not all of them are saved and loaded,
> some do not have an effect at all so far.
>
> This hack has a problem. When the user changes the original dates after
> creation of the chart, the chart will not reflect those changes. Don't
> know whether that is important in your scenario.
>
> Kind regards,
> Ingrid
>
>> thanks.
>>
>> othman.
>>
>>
>>
>>
>> Ingrid Halama wrote:
>>> Hi,
>>>
>>> othman wrote:
>>>> Hi Ingrid,
>>>> as we all know the candle chart has two bars (black and white)
>>>> I guess that by changing the bar width, the chart can have a larger
>>>> date
>>>> range displayed.
>>> No.
>>>
>>>> I am not sure whether this is the correct direction to fix
>>>> the x-axis scale problem . what you think about that ? and is it
>>>> possible
>>>> to
>>>> change the width of candle chart bars ?
>>> No, that is not the right direction to fix the problem. It is not
>>> possible to set a manual width to the candles. The width is calculated
>>> automatically dependent on the amount of data and the place provided.
>>>
>>> So again, I would suggest to change the data ranges on your zooming
>>> control.
>>>
>>>> thanks
>>>>
>>>> othman
>>>>
>>> Kind regards,
>>> Ingrid
>>>
>>> ---------------------------------------------------------------------
>>> 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]
>
>
>
--
View this message in context:
http://www.nabble.com/discussing-com%3Asun%3Astar%3Achart2-API-tp19268400p19555243.html
Sent from the openoffice - api dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
