Hi, I am working on a program that uses queries that are hard coded into the program. Within the program, I have pages (radpageview) and then grids on the pages. Then each grid is programmed to load in data from the queries. 

I am running into trouble because my grids are based on the first grid... I have this hard coded into the SQL Query and it will look at a specific cell value to then run the query with that in the where statement. 

I need a cell value that is in the template, but I am having no luck. 

As you can see below, I can get the cells from my main grid... but not from the template.

Example to explain...

I set this: selectedOrder = grdCustPOListing.CurrentRow.Cells["Order Num"].Value.ToString();

So that selectedOrder can now be used in my query: 

Background:

• Given a spreadsheet template, to generate a new spreadsheet by filling the information and barcode.
• E.g. the screenshot (template) below, the barcode to be inserted at the cell location.

What I have done:

• I manage to locate the target cell index (by searching the keyword $PART_NAME_LABEL$).

Question:

• How to insert the barcode (image) at the target cell index location?
• Any other suggestions for barcode generation? (Instead of inserting the barcode image, e.g. using barcode font)

I have referred to the sample in this page but it doesn't work.

https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/shapes-and-images

XlsxFormatProvider formatProvider = new XlsxFormatProvider();
            Workbook workbook = formatProvider.Import(File.ReadAllBytes(@"C:\temp\temp.xlsx"));

            var worksheet = workbook.Sheets[0] as Worksheet;

            FindOptions f = new FindOptions();
            f.FindWhat = "$PART_NAME_LABEL$";

            IEnumerable<FindResult> result = worksheet.FindAll(f);

            foreach(var i in result)
            {
                worksheet.Cells[i.FoundCell.CellIndex].SetValue("");
                //Add barcode here
                RadBarcode radBarcode1 = new RadBarcode();
                Telerik.WinControls.UI.Barcode.Symbology.Code39Extended code39Extended1 = new Telerik.WinControls.UI.Barcode.Symbology.Code39Extended();
                radBarcode1.Symbology = code39Extended1;
                radBarcode1.Value = "123456";
                radBarcode1.LoadElementTree();

                var ms = new MemoryStream();
                Image barcode = radBarcode1.ExportToImage();
                barcode.Save(ms, ImageFormat.Png);

                FloatingImage image = new FloatingImage(worksheet, i.FoundCell.CellIndex, 35, 10);
                image.ImageSource = new Telerik.Windows.Documents.Media.ImageSource(ms, "png");
            }

I'm having an interesting issue with the VS Designer and Telerik forms.  My forms are shrinking!  Sure, I can set the size in code behind, but I shouldn't have to.  This is a problem with all my Telerik Winforms projects.

Create a new Telerik Winforms project.  Expand the original form and add a grid.  Anchor the grid.  Save and close the form.  When the form is reopened, the grid is the correct size, but the window shrinks.

It appears the designer fails to set the Size property.

Is it just this machine?  

Please advise.

VS2022, Telerik Winforms 2023.1.117

I'm doing lots of updates and deletes in my Spreadsheet, but the UseCellRange parameter doen't seem to get updated.

How is it calculated?

I don't really want to create my own version of it, but I can't seem to make it accurate.

Even when I can see that rows are empty, it thinks they have some content, then those blank rows get processed when they should not.

Any ideas?

I have some controls which get embedded inside another application, so they don't have aparent Form.

But they need to share the same Theme as all the forms.

Setting the Theme for the forms is easy.

But I can't see where to apply the same Theme to a Control? Is this even possible?

Hi Team

Please suggest one Example realated to  "Replace Infragistics toolbar  by using Telerik controls"

Thanks.

I want to change the highlight color of a selected row. But, I can't. 

Could you tell me how to do it?

I'm using PatternFill.CreateSolidFill to add colors to some of my spreadsheet cells, and it works fine.

But when I come to reset those colors back to 'normal' , their borders have gone:

Here, I apply the fill to some cells, but want to reset the color where the formatting rules does not apply. I am applying a solid fill, like:

PatternFill.CreateSolidFill(ThemableColor.FromArgb(255, 255, 255, 255))

..but this is where the border goes away.

How should I reset the border as well as the original color ?

Thanks