Cell auto size with Vertical Scroll

[Yohan]

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. 

[Pavlina]

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

[Yohan]

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

[Yohan]

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

[Pavlina]

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

[Yohan]

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 

[Pavlina]

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

[Yohan]

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

[Pavlina]

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