Display Chart and Data in same Page

Posted by: satson90 on 8 September 2017, 3:06 pm EST

  • Posted 8 September 2017, 3:06 pm EST

    <P>Hi,</P>
    <P>I want display in sheet data and chart in same with separator. if have more than column that time also the chart display in visual and am scroll the page data columns only move it and if i want to print data the data columns only printed. If i want print chart, the chart only printed</P>
    <P>It have any solution plz.....</P>
    <P>Thanks</P>
    <P>Sathish</P>
  • Replied 8 September 2017, 3:06 pm EST

    <p>Hello,</p><p>I apologize for the delayed response. Please have a look at the following forum links that discuss the similar issue:</p><p>               http://www.clubfarpoint.com/Forums/forums/thread/95365.aspx</p><p>               http://www.clubfarpoint.com/Forums/forums/thread/90179.aspx <br></p><p>Hope it helps. Please let me know if I missed something.</p><p>Thanks,</p><p>Manpreet Kaur <br></p>
  • Replied 8 September 2017, 3:06 pm EST

    <P>Hi kaur,</P>
    <P>Thanks for reply. But i want display chart and data with <FONT color=#cc0000>separator</FONT>. if i have 10 columns and a chart. A chart display in half of chart and 5 columns display in half of sheet. if i moving the scrollbar the columns only moved the chart display in the same place</P>
    <P>thanks</P>
    <P>sathsih</P>
  • Replied 8 September 2017, 3:06 pm EST

    <p>Hello,</p><p>You can divide the sheet into viewports to display the data in one viewport and chart in the second viewport. Please have a look at the attached sample that implements the same. However, there is not a way to stop the chart from scrolling when the columns on which the chart is placed are scrolled.</p><p>Hope it helps.</p><p>Thanks,</p><p>Manpreet Kaur <br></p>
    2013/03/ChartData.zip
  • Replied 8 September 2017, 3:06 pm EST

    <P>Hi kaur,</P>
    <P>Thanks for reply, the viewport separator is moveable. How can i set to does not moveable</P>
    <P>thanks</P>
    <P>sathish</P>
  • Replied 8 September 2017, 3:06 pm EST

    <p>Hello,</p><p>You can set ColumnSplitBoxPolicy property to set the
    display of the split box in the viewport so as to avoid the user from
    splitting the viewports further. Please refer to the following link that
    describes the same:</p><p>                  http://helpcentral.componentone.com/NetHelp/SpreadNet6/WF/spwin-sheetsplitboxes.html <br></p><p>Hope it helps. Please let me know if I missed something.</p><p>Thanks,</p>Manpreet Kaur
  • Replied 8 September 2017, 3:06 pm EST

    <P>Hi Kaur,</P>
    <P>Thanks for a reply. If set ColumnsplitBoxPliocy is never that time also the separtor is moveable. I mean the separator is split chart and data. i want that control is not moveable</P>
  • Replied 8 September 2017, 3:06 pm EST

    <p>Hello,</p><p>Unfortunately, I am not able to understand your requirement clearly. Could you please share some screenshots depicting your requirement as it would help me understand the issue better and provide you with an appropriate solution.</p><p>Thanks,</p><p>Manpreet Kaur <br></p>
  • Replied 8 September 2017, 3:06 pm EST

    <P>Hi kaur,</P>
    <P>Sorry,  I am unable upload anything because that option blocked bu my MD. </P>
    <P>Set that example. </P>
    <P>The viewport separtor by one border. I Want that border doesn't Moveable</P>
    <P>Thanks</P>
  • Replied 8 September 2017, 3:06 pm EST

    <p>Hello,</p><p>The separator that you are referring to is basically used to change the width of the viewports and is not exactly splitting the viewports further. This is a design behavior that lets the user to resize the viewports so as to display more or less columns in one of the viewports. Unfortunately,  I could not find a way to override this design behavior.<br></p><p>Thanks,</p><p>Manpreet Kaur <br></p>
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels