I have a pivot grid bound to a sql data source. When I attempt to export, the resulting excel file is gibberish (see screenshot). My version is 2017.1.118. What am I missing?
<telerik:RadPivotGrid ID="rpgResults" runat="server" DataSourceID="sdsSummary" Width="100%"
EnableTheming="false" EnableEmbeddedSkins="true" Skin="Default" RenderMode="Lightweight"
AllowFiltering="False" AggregatesPosition="Columns" ShowFilterHeaderZone="False" ShowDataHeaderZone="False" ShowColumnHeaderZone="False" ShowRowHeaderZone="False"
OnCellDataBound="RadPivotGrid1_CellDataBound">
<ClientSettings>
<Scrolling AllowVerticalScroll="True" ScrollHeight="600px" />
</ClientSettings>
<Fields>
<telerik:PivotGridRowField DataField="Year" />
<telerik:PivotGridRowField DataField="Qtr" />
<telerik:PivotGridRowField DataField="Month" SortOrder="None" />
<telerik:PivotGridColumnField DataField="InvoiceType" />
<telerik:PivotGridAggregateField DataField="Amount" Aggregate="Sum" DataFormatString="{0:C}" />
<telerik:PivotGridAggregateField DataField="Invoices" Aggregate="Count" DataFormatString="{0:N0}" />
</Fields>
</telerik:RadPivotGrid>
button click code for exporting...
rpgResults.ExportSettings.Excel.Format = PivotGridExcelFormat.Biff
rpgResults.ExportSettings.FileName = "Processed_Invoice_Summary"
rpgResults.ExportSettings.IgnorePaging = True
rpgResults.ExportSettings.OpenInNewWindow = False
rpgResults.ExportToExcel()
Hi,
I have two issues with Kendo exporting PDF.
I am following the example from:
https://demos.telerik.com/kendo-ui/pdf-export/index
First one:
Here are two images attached showing the difference between WebPage text and PDF text. The text is vertical in my webpage but was changed to horizontal after being exported to PDF.
Second One:
I added a div element on my page filled with a chart. I draw this chart using Google Chart Library.
However when I exported PDF my chart is lost.
Could you please take a look?
Thanks.
Hello!
I'm trying to implement a way to automatically resize the diagram to fit the canvas (i.e. automatic zoom) after it is loaded. But I could not find a built-in functionality. Is this possible?
Best Regards,
I need to provide character limit functionality in RadEditor and have been having a significant number of issues getting a comprehensive solution. I've read a number of items on the Forum that sometimes give conflicting and incomplete solutions.
Requirement:
The last article I was looking at was: http://www.telerik.com/forums/charector-limit-in-rad-editor#662718 which is pretty close in functionality to what I need, but when determining the length of the content on the clipboard the formatting from Word, or wherever you picked the text up from is included in that length.
If you could provide some code snippets or point me to an article that will correctly work I would appreciate it.
Rodney
Hi,
When I was designing a Splitter, is there a way for me to design my sliding pane as shown in the picture?
Thanks
i am using for UI for ASP.NET AJAX(Telerik.Web.UI.dll-version 2017.2.503.45)
After deploying the project, raddock & radhtmlchart are not displayed but this is not happening in the development system,the problem is observed in the production system.
How to solve this problem.please help me.
Thank you
Hello,
We developed a simple upload functionality which works correctly on test environment but not in prod.
The expected behavior is whenever clicked on "browse", the file being uploaded and written into the RadUploadTemp. Once clicked on "upload" button, the code behind is raised but UpladedFiles collection is empty.
Note that RadUploadTemp has been created automatically and even the zero bytes file name: RadUploadTestFile
The only apparent difference between test and prod seems to be that into prod's web.config this section is missed:
<
configSections
>
<
sectionGroup
name
=
"system.web.extensions"
type
=
"System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
>
<
sectionGroup
name
=
"scripting"
type
=
"System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
>
<
section
name
=
"scriptResourceHandler"
type
=
"System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
requirePermission
=
"false"
allowDefinition
=
"MachineToApplication"
/>
<
sectionGroup
name
=
"webServices"
type
=
"System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
>
<
section
name
=
"jsonSerialization"
type
=
"System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
requirePermission
=
"false"
allowDefinition
=
"Everywhere"
/>
<
section
name
=
"profileService"
type
=
"System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
requirePermission
=
"false"
allowDefinition
=
"MachineToApplication"
/>
<
section
name
=
"authenticationService"
type
=
"System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
requirePermission
=
"false"
allowDefinition
=
"MachineToApplication"
/>
<
section
name
=
"roleService"
type
=
"System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"
requirePermission
=
"false"
allowDefinition
=
"MachineToApplication"
/>
</
sectionGroup
>
</
sectionGroup
>
</
sectionGroup
>
</
configSections
>
ASPX:
<%-- uploader --%>
<
div
id
=
"divUploader"
runat
=
"server"
class
=
"divUploader"
visible=' <%# DataBinder.Eval(((IDataItemContainer)Container).DataItem, "uploadervisible") %>'>
<
span
class
=
"spText"
>Restituzione Documentazione</
span
>
<
a
runat
=
"server"
class
=
"tooltip"
href
=
"javascript:void(0);"
visible='<%# DataBinder.Eval(((IDataItemContainer)Container).DataItem, "tooltipvisible") %>'
title='<%# DataBinder.Eval(((IDataItemContainer)Container).DataItem, "tooltiptext") %>'>
<
asp:Image
ImageUrl
=
"~/images/icoTooltip.png"
runat
=
"server"
/>
</
a
>
<
telerik:RadAsyncUpload
RenderMode
=
"Lightweight"
runat
=
"server"
CssClass
=
"async-attachment"
ID
=
"FileUpload"
HideFileInput
=
"false"
MaxFileInputsCount
=
"1"
MultipleFileSelection
=
"Disabled"
CommandName
=
"Upload"
CommandArgument='<%# DataBinder.Eval(((IDataItemContainer)Container).DataItem, "iPtAcq") %>'
AllowedFileExtensions=".pdf" ControlObjectsVisibility="None">
<
Localization
Select
=
"Sfoglia..."
/>
<
Localization
Remove
=
""
/>
</
telerik:RadAsyncUpload
>
<
asp:Button
ID
=
"btnFileUpload"
runat
=
"server"
CssClass
=
"btnOrangeUpload"
Text
=
"Carica"
CommandName
=
"Upload"
CommandArgument='<%# DataBinder.Eval(((IDataItemContainer)Container).DataItem, "iPtAcq") %>' />
<%--<
asp:FileUpload
ID
=
"FileUpload"
runat
=
"server"
class
=
"file"
/>--%>
</
div
>
Can anyone give a clue how can I check in order to fix this?
Feel free to ask me more details if needed...
Regards.
I have a Grid which has a GridClientSelectColumn in it and multirow selection enabled. Because I wanted to be able to be able to select rows by clicking anywhere on the row rather than just hitting the tiny checkbox I am using the JavaScript below for these events:
Then as part of the code behind for a button click I am doing a RadGrid1.SelectedItems to get all the highlighted/Selected rows. However if I select a few rows and then deselect some of them then RadGrid1.SelectedItems is returning the unselected rows still?
foreach
(GridDataItem selectedRow
in
RadGrid1.SelectedItems)
{
Bookings.bookingRequest bookRow =
new
Bookings.bookingRequest();
bookRow.empID = txtEmpId.Text;
bookRow.keepCurrent = radioKeepBookings.SelectedValue;
bookRow.woNo =
int
.Parse(selectedRow.GetDataKeyValue(
"woNo"
).ToString());
bookRow.seqNo = selectedRow.GetDataKeyValue(
"seqNo"
).ToString();
bookings.Add(bookRow);
}
var
originalClickedRowState =
null
;
var
clickedRow =
null
;
function
rgGrid_OnRowClick(sender, args) {
clickedRow = args.get_gridDataItem();
originalClickedRowState = args.get_gridDataItem().get_selected();
}
function
rgGrid_OnRowDeselecting(sender, args) {
if
(clickedRow !=
null
&& clickedRow != args.get_gridDataItem()) {
args.set_cancel(
true
);
}
}
function
rgGrid_OnRowSelecting(sender, args) {
if
(clickedRow == args.get_gridDataItem() && originalClickedRowState) {
args.set_cancel(
true
);
originalClickedRowState =
null
;
clickedRow =
null
;
}
}
function
rgGrid_OnRowSelected(sender, args) {
originalClickedRowState =
null
;
clickedRow =
null
;
}
<
ClientEvents
<br> OnRowClick="rgGrid_OnRowClick"<
br
> OnRowSelecting="rgGrid_OnRowSelecting"<
br
> OnRowDeselecting="rgGrid_OnRowDeselecting"<
br
> OnRowSelected="rgGrid_OnRowSelected" />