Cell auto size with Vertical Scroll

9 posts, 0 answers
  1. Yohan
    Yohan avatar
    32 posts
    Member since:
    Jan 2014

    Posted 22 Jan 2014 Link to this post

    I'm using OLAP connection to pivot grid. i have noticed that when i use AllowVerticalScroll="True"  with configuration panel enabled it doesn't fit to text size of cells when there are less columns, takes more space and unnecessary horizontal scrolling is  taken. but it works fine when used without the configuration panel. I have attached an image of the mentioned. 

    Pivot grid code :

    <telerik:RadPivotGrid ID="rpgDashboard" Width="100%" Height="480px" runat="server"
                 AllowPaging="True"  EnableZoneContextMenu="True" AllowFiltering="True"
                 EnableConfigurationPanel="True" OnNeedDataSource="rpgDashboard_NeedDataSource"
                 OnCellDataBound="rpgDashboard_CellDataBound"
                 OnPivotGridCellExporting="rpgDashboard_PivotGridCellExporting"
                 OnPivotGridCreated="OnResponseEnd"
                 ConfigurationPanel-DeferLayoutUpdateCheckBox-CssClass="PivotGridCheckBox"   
                 OnPreRender="rpgDashboard_PreRender" AllowSorting="False"
                 EnableEmbeddedSkins="True"
                 OnPivotGridBiffExporting="rpgDashboard_PivotGridBiffExporting" >
                 <PagerStyle Mode="NextPrevNumericAndAdvanced" AlwaysVisible="true" >
                 </PagerStyle>
                 <ClientSettings EnableFieldsDragDrop="True">
                       <ClientEvents OnPivotGridCreated="hideElements"></ClientEvents>
                       <Scrolling AllowVerticalScroll="True"></Scrolling>
                 </ClientSettings>
                 <ConfigurationPanelSettings Position="Left" LayoutType="Stacked"
                  DefaultDeferedLayoutUpdate="True"
                  EnableDragDrop="False" nableFieldsContextMenu="True"  
                  EnableOlapTreeViewLoadOnDemand="False">
                 </ConfigurationPanelSettings>
     </telerik:RadPivotGrid>


    in addition having row field only added it it doesn't show vertical scroll even though there  are more records than the view port. 
  2. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 24 Jan 2014 Link to this post

    Hi Yohan,

    It is expected the header row height to be larger, because in the RowsZone you have a button (Capture Day in your case) which requires this height and in order to prevent misalignment their heights are equal.

    However, you can decrease the button height as shown below and the column header div will also become smaller:
    <style type="text/css">
               .RadPivotGrid .rpgFieldItem,
               .RadPivotGrid .rpgUpdateButton
               {
                   height: 16px;
                   line-height: normal;
               }
           </style>

    I also tried to replicate the problem with the horizontal scroll that is not needed, but I did not manage to reproduce it. I am sending you my test project in order to see how the provided code is working on my side and check what might be the difference in your scenario.

    Regards,
    Pavlina
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Yohan
    Yohan avatar
    32 posts
    Member since:
    Jan 2014

    Posted 25 Jan 2014 Link to this post

    Hello Pavlina ,

    I've checked your project and i was able to recreate the  row field only added defect. i have attached an image of that.

    Yes, this doesn't give unnecessary scrolling. Can you try this on with a CUBE Connection to recreate and please try a scenario where column field have only 2-3 records. I have attached an image of the sample scenario form your data set which is working properly, you can try such scenario with a cube connection then it will give the unnecessary scrolling issue. and when no data is loaded even there is a horizontal scroll when cube connection has been made. Recommend to in IE 8 or chrome.

    use this code segment as-well.

    .RadPivotGrid td.rpgDataCell
    {  
        text-align:right;
    }


    Regards,
    Yohan
  5. Yohan
    Yohan avatar
    32 posts
    Member since:
    Jan 2014

    Posted 25 Jan 2014 in reply to Pavlina Link to this post

    Hello Pavlina ,

    Going through the code project you have attached I've found that you have used a fixed width and a height for ColumnHeaderCells which was not what i  expect.

    <ColumnHeaderCellStyle Width="100px" Height="10px" />

    I don't want this segment because i want column header cells to set width fit to its data. It works properly when vertical scrolling is not used. Remove the above segment and try then you will be able to reproduce. Try on chrome or IE 8.

    Ive noticed another issue when trying out your code. On Firefox when i re size the browser vertical scroll doesn't show up and part of the data goes missing. Take a look at that a swell. attached images describe the mentioned.

    Regards,
    Yohan
  6. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 30 Jan 2014 Link to this post

    Hi Yohan,

    Thank you for bringing this to our attention, we were able to verify the problem when 2-3 records are initially loaded in the pivotgrid and at the same time AllowVerticalScroll property is set to true. Our developers will investigate the issue further and will fix it as soon as possible. Your Telerik points are also updated as a token of gratitude.

    Regards,
    Pavlina
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the UI for ASP.NET AJAX, subscribe to the blog feed now.
  7. Yohan
    Yohan avatar
    32 posts
    Member since:
    Jan 2014

    Posted 31 Jan 2014 in reply to Pavlina Link to this post

    Hello Pavlina,

    Great that it will be fixed soon. I have used a lot of third party tools bus this has the most interactive support service. Keep up good work.

    Regards,
    Yohan 
  8. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 03 Feb 2014 Link to this post

    Hello Yohan,

    You can follow the status of this item here:
    http://feedback.telerik.com/Project/108/Feedback/Details/114451-when-data-is-less-than-the-scrollheight-in-radpivotgrid-populated-with-olap-data

    Regards,
    Pavlina
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the UI for ASP.NET AJAX, subscribe to the blog feed now.
  9. Yohan
    Yohan avatar
    32 posts
    Member since:
    Jan 2014

    Posted 13 Feb 2014 in reply to Pavlina Link to this post

    Hello Pavlina,

    Issue : Header doesn't render properly when restore down and maximized the browser window.
    Grid setting :  pivotgrid width is set to 100% as in my provided sample project, Scenario which does't appear horizontal scroll bars.
    Browser : Chrome , Firefox , IE
    Steps to Reproduce : 
    1) restore down the browser window to a small size.
    2) Maximize back to previous size.

    I've attached a snap with the mentioned.

    Thanks and Regards,
    Yohan


  10. Pavlina
    Admin
    Pavlina avatar
    6084 posts

    Posted 17 Feb 2014 Link to this post

    Hi,

    Following the provided instructions I have managed to replicate the problem with PivotGrid headers rendering. The bug is already logged and you can follow its status here. An additional 500 points are also added to your account.

    Regards,
    Pavlina
    Telerik
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the UI for ASP.NET AJAX, subscribe to the blog feed now.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017