Telerik Forums
UI for WinForms Forum
1 answer
145 views

Hi folks.  There seems to be a lot of questions about this and every answer I could find pointed me at some web solution.  This is Winforms and nothing I've seen so far has been in line with my current issue - so here goes!

WinForms .Net 4.7.2 VB

A simple grid (See gridPIC.png)

3 Columns:

  • Decimal DecimalPlaces = 0  FormatString = {0:N0}
  • Decimal DecimalPlaces = 2  FormatString = {0:N2}
  • Decimal DecimalPlaces = 4  FormatString = {0:N4}

Export property settings:

  • HiddenColumnOption = HiddenOption.DoNotExport
  • SummariesExportOption = SummariesOption.DoNotExport
  • ExportVisualSettings = False


When using ExportFormat = SpreadStreamExportFormat.Csv you can see the integer shows 111, the 2 decimal data shows 222.22 and the four decimal data shows 333.3333 as expected. (See csvPIC.png)

But when using ExportFormat = SpreadStreamExportFormat.Xlsx the results are incorrect (*See ExcelPic.png)

 

I was expecting that the export file would include the format information.  I thought perhaps because I'd set spreadStreamExport.ExportVisualSettings = False that this was the cause but I can flip that to True and the output is identical.

The DATA that gets into Excel IS CORRECT.  It's just not formatting the cells as expected.

Is there any way for spreadStreamExport to output the proper Decimal formatting? 

If yes, can you point me at a sample?  C# is just fine if you folks aren't vb.net users.

 

Thank you all!

Curtis

 

Nadya | Tech Support Engineer
Telerik team
 answered on 15 Aug 2024
4 answers
2.1K+ views

I have  abound gridview that i have added a checkbox column to as the first column.
i cannot check any checkboxes in any row, only able to check the headercheckbox which selects all checkboxes of every row.

Dim checkboxcolumn As New GridViewCheckBoxColumn
checkboxcolumn.DataType = GetType(Integer)
checkboxcolumn.Name = "SelectedColumn"
checkboxcolumn.FieldName = "Select"
checkboxcolumn.HeaderText = "Select?"
GV_Assets.MasterTemplate.Columns.Add(checkboxcolumn)
checkboxcolumn.EnableHeaderCheckBox = True

 

Julian
Top achievements
Rank 1
Iron
Iron
Iron
 answered on 15 Aug 2024
8 answers
877 views
Hi,

I am unable to highlight the full dropdown list (including the text box and button) 

The attached file will show how it is currently highlight but would like to highlight in the same way(color and thickness) as the textbox in the attached file. I used the below code but it did not highlight the button.

Thanks in advance for your help.



radDDL.DropDownListElement.TextBox.Fill.BackColor = Color.Red;
Todor
Telerik team
 updated answer on 12 Aug 2024
1 answer
273 views

How to convert PDF pages to images in .NET Framework app? I've scoured the site, and it seems you recommend something like this:


RadPdfViewer pdfViewer = new RadPdfViewer();

pdfViewer.DocumentLoaded += (sender, e) =>
{
	if (sender is RadPdfViewerElement pdfViewerElement)
	{
		for (int i = 1; i <= pdfViewerElement.Document.Pages.Count; i++)
		{
			Image pageImage = pdfViewerElement.ExportPage(i, 1, true, ImageFormat.Jpeg);

			// Use pageImage
		}
	}
};

pdfViewer.LoadDocument(pdfPath);
pdfViewer.LoadElementTree();
Application.DoEvents();

Is this really the best way for .NET Framework apps? There is an example that uses PdfProcessing instead of PdfViewer, but requires the assembly Telerik.Documents.Fixed.FormatProviders.Image.Skia, which I don't have available in my Visual Studio with latest update of Telerik UI for WinForms 2024.3.806.462. Nor is it available on nuget, or I don't know how to find it.

Dinko | Tech Support Engineer
Telerik team
 answered on 08 Aug 2024
2 answers
243 views

Hi everyone,

I’m currently using RadRichTextEditor to print logs. I have the following scenario:

  • The first line prints "Hello" in black font.
  • The second line prints "world" in red font.

How can I change the font color for different lines in RadRichTextEditor?

Thank you!

Kevin
Top achievements
Rank 2
Iron
Iron
 updated question on 05 Aug 2024
1 answer
112 views
I know how to copy text using context menu, but I also need copy text using shortcut.
Nadya | Tech Support Engineer
Telerik team
 answered on 05 Aug 2024
1 answer
170 views

Created a column like this:


if (operation == "viplata")
            {
                GridViewCheckBoxColumn checkBoxColumn = new GridViewCheckBoxColumn
                {
                    DataType = typeof(bool),
                    Name = "Выбрать",
                    FieldName = "Выбрать",
                    HeaderText = "Выбрать",
                    EditMode = EditMode.OnValueChange,
                    ReadOnly = false
                };
                checkBoxColumn.EnableHeaderCheckBox = true;
                radGridView1.MasterTemplate.Columns.Add(checkBoxColumn);
            }

The column is shown, but nothing can be selected. I have an event connected to DataGridView1_DoubleClick, so the checkboxes must be set by one click. How can I implement it?

I have grouping enabled in my grid.How can I make it so that when I press a key, only open checkBoxColumn groups are selected?Thanks for your help.

Jesse
Top achievements
Rank 1
Iron
 updated answer on 05 Aug 2024
3 answers
151 views

Hi, I am customizing the theme VisualStudio2022Light. I have changed the purple color to the teal. However, I am not able to change the background and selected row in the theme.

 

When I run my application, it is still in purple.

I found a similar issue where I couldn't find where I can change the close button during click in the RadForm.

Henri
Top achievements
Rank 2
Iron
Iron
Iron
 answered on 01 Aug 2024
2 answers
107 views

Create new Word-inspired project and add CommandExecuting event handler with the following code:


private void radRichTextEditor1_CommandExecuting(object sender, Telerik.WinForms.Documents.RichTextBoxCommands.CommandExecutingEventArgs e)
{
	if (e.Command is Telerik.WinForms.Documents.RichTextBoxCommands.SaveCommand)
	{
		e.Cancel = true;

		var newForm = new MainForm();
		newForm.Show();
	}
}

When I click on Save quick-button I expect to see new form active and in focus, but what actually happens is that new form is created, gets in focus briefly, and then the old form steals the focus. How can I fix the focus steal? I need new form to be non-modal.

In theory I should be able to do it if I call Show(this) instead of Show(), and in OnShown overload set Owner = null, but even though the active window now is the new form, the keyboard focus is still on old form (type something to see). I suspect there is some OnTimer interference. Do you have an adequate solution?

 

Mihajlo
Top achievements
Rank 1
Iron
 answered on 30 Jul 2024
1 answer
99 views

Hi,

is there a way to clear the selection completely in a VirtualGrid?

I have a simple VirtualGrid with SelectionMode=FullRowSelect and MultiSelect=true. When I use the ClearSelection method the arrow in the row header is still visible and also the last clicked cell (see the attached video in the zip file).

Thank you very much.

 

Emanuele

Nadya | Tech Support Engineer
Telerik team
 answered on 30 Jul 2024
Narrow your results
Selected tags
Tags
GridView
General Discussions
Scheduler and Reminder
Treeview
Dock
RibbonBar
Themes and Visual Style Builder
ChartView
Calendar, DateTimePicker, TimePicker and Clock
DropDownList
Buttons, RadioButton, CheckBox, etc
ListView
ComboBox and ListBox (obsolete as of Q2 2010)
Form
Chart (obsolete as of Q1 2013)
PageView
MultiColumn ComboBox
TextBox
RichTextEditor
PropertyGrid
Menu
RichTextBox (obsolete as of Q3 2014 SP1)
Panelbar (obsolete as of Q2 2010)
PivotGrid and PivotFieldList
Tabstrip (obsolete as of Q2 2010)
MaskedEditBox
CommandBar
PdfViewer and PdfViewerNavigator
ListControl
Carousel
GanttView
Diagram, DiagramRibbonBar, DiagramToolBox
Panorama
New Product Suggestions
VirtualGrid
Toolstrip (obsolete as of Q3 2010)
AutoCompleteBox
Label
Spreadsheet
ContextMenu
Panel
Visual Studio Extensions
TitleBar
SplitContainer
Documentation
Map
DesktopAlert
CheckedDropDownList
ProgressBar
MessageBox
TrackBar
Rotator
SpinEditor
CheckedListBox
StatusStrip
CollapsiblePanel
LayoutControl
ShapedForm
SyntaxEditor
Wizard
TextBoxControl
Conversational UI, Chat
DateTimePicker
TabbedForm
CAB Enabling Kit
WaitingBar
GroupBox
DataEntry
ScrollablePanel
ScrollBar
ImageEditor
Tools - VSB, Control Spy, Shape Editor
BrowseEditor
DataFilter
FileDialogs
ColorDialog
Gauges (RadialGauge, LinearGauge, BulletGraph)
ApplicationMenu
RangeSelector
CardView
WebCam
BindingNavigator
RibbonForm
Styling
Barcode
PopupEditor
TaskBoard
NavigationView
Callout
ColorBox
PictureBox
FilterView
Accessibility
VirtualKeyboard
DataLayout
Licensing
ToastNotificationManager
ValidationProvider
CalculatorDropDown
Localization
TimePicker
BreadCrumb
ButtonTextBox
FontDropDownList
BarcodeView
Overlay
Security
LocalizationProvider
Dictionary
TreeMap
SplashScreen
Flyout
Separator
SparkLine
StepProgressBar
ToolbarForm
NotifyIcon
DateOnlyPicker
AI Coding Assistant
Rating
TimeSpanPicker
Calculator
OfficeNavigationBar
TaskbarButton
HeatMap
SlideView
PipsPager
AIPrompt
TaskDialog
TimeOnlyPicker
SpeechToTextButton
+? more
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
Boardy
Top achievements
Rank 2
Veteran
Iron
Benjamin
Top achievements
Rank 3
Bronze
Iron
Veteran
ivory
Top achievements
Rank 1
Iron
Iron
Rob
Top achievements
Rank 3
Bronze
Bronze
Iron
ClausDC
Top achievements
Rank 2
Iron
Iron
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?