Aspose.com » Public Forums for Customers an... » Aspose.Cells Product Family » detect orientation of a given data series

detect orientation of a given data series

Last post 05-14-2010, 6:01 AM by aspose.notifier. 5 replies.
Sort Posts: Previous Next

  •  04-20-2010, 12:01 AM 233498

    detect orientation of a given data series Java

    Hi, 

    I'd like to detect, if a chart's data series is horizontal or vertical oriented. While I'm able to set it when adding a new ASeries range, I don't see to how to find out, what a given ranges type is. Secondly, what is Aseries.getType() telling me?

    Immediate response would be very much appreciated.

    Jens 

    This message was posted using Aspose.Live 2 Forum
    Filed under: Aspose Cells for Chart
     

  •  04-20-2010, 2:54 AM 233535 in reply to 233498

    Re: detect orientation of a given data series

    Hi,

     

    Well, there is no such API available. It may not be possible to provide one API for such purpose because the datasource of a chart may be complex, such as, some series of a chart may be a vertical range of cells, some others may be a horizontal range of cells, and some others may be static value of non-adjacent cells.

     

    Also, Aseries.GetType() will return the series’s chart type. For example, the types of series in one chart may be different, such as one series is COLUMN chart and another series is LINE. In such situation, the first series.getType will return COLUMN and another will returns LINE.

     

    Thank You & Best Regards,

    Nausherwan Aslam
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     

  •  04-20-2010, 1:23 PM 233721 in reply to 233535

    Re: detect orientation of a given data series Java

    Hi, thanks for the quick reply.
    The constants you mentioned (LINE, COLUMN...): Are they defined as int constants somewhere?

    For the series: I see the point. So I've to figure it out by myself by testing for some assumptions.

    BTW, there is a strange thing, I noticed:I was not able to set a NamedRange's name in dataSeries.add(), while i was abel to use it for categories using setCategoryData(). Instead of using namedRange.getText() I had to use nameRange.getRefersTo(). using getText() I always got invalid range spec or so.
    Jens
     

  •  04-21-2010, 2:08 AM 233823 in reply to 233721

    Re: detect orientation of a given data series

    Hi Jens,

    For the issue of creating chart with "NamedRange" as data source, we have found the issue and will provide a fix for it soon. We have logged your issue into out issue tracking system with an issue id: CELLSJAVA-16180.

    Thank you.
    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     

  •  04-29-2010, 8:00 AM 235361 in reply to 233823

    Re: detect orientation of a given data series

    Attachment: Present (inaccessible)
    Hi,

    Please try the attached version, we     have fixed the issue of adding chart data by named range.

    Thank you    .
    Amjad Sahi
    Support Developer,
    Aspose Sialkot Team
    Contact Us
     

  •  05-14-2010, 6:01 AM 238013 in reply to 233498

    Re: detect orientation of a given data series

    The issues you have found earlier (filed as 16180) have been fixed in this update.

    This message was posted using Notification2Forum from Downloads module by aspose.notifier.
     
View as RSS news feed in XML

© Aspose 2002-2012. All Rights Reserved.

Live Chat