Hi,
othman wrote:
Hi Ingrid,
thanks for the elaborated response. I will discuss your propositions with
our project manager & probably post the feedback in this mailing list .
meantime , i hope we can continue on the issue of date formatting.
Ingrid Halama wrote:
It is not possible to set a min date and a max date at the category
axes. You will need to provide strings in the spreadsheet that can be
taken as text for the category axes. Then choose the range oAddr in that
way that the first column has the dates as text.
i think you mean i can set the range for dates in string formats like this :
XCellRange myRange = oRange.getCellRangeByName("A1230:E1740");
this did the trick for setting a min date and max date .what remains is only
to set a step for my range within the String range . i suppose this could be
done using a formula like :
oRange.getCellRangeByName("A1230:E1740:DATE_RANGE"); (i'm not sure if this
is possible)
is it possible to set a step range in string range formula ? if yes how to
specify this range step ?
No, this is not possible.
if chart2 API is not able to format dates ranges , can i do it with standard
chart API ? and how ?
There is no concept of date range at a category axis in neither API.
There is only a sequence of texts that are displayed in order.
The values in the stock chart are also only displayed in order. They are
not displayed regarding any specific date or x value.
Kind regards,
Ingrid
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
