Hello

I'm trying to create an Excel xlsx spreadsheet from data in a data table. I'm having trouble setting / defining cell borders. I would like to define a bottom black thin border for a range of cells.

I'm using this as a reference https://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/working-with-cells/get-set-clear-properties#borders-property

I've started with this...

Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets.Add();

ThemableColor black = new ThemableColor(Color.FromArgb(0, 0, 0, 0));
CellBorders blackBorders = new CellBorders(new CellBorder(CellBorderStyle.Thin, black));
worksheet.Cells[4, 0, 4, 9].SetBorders(blackBorders);

In Visual Studio, ThemableColor and Color are underlined in red. When I mouse over it says 'The name 'Color' does not exist in the current context'.

Am I missing a reference or using statement to be able to use ThemableColor?

My C# project targets net6.0-windows and enables windows forms:

<PropertyGroup>
 <TargetFramework>net6.0-windows</TargetFramework>
 <ImplicitUsings>enable</ImplicitUsings>
<UseWindowsForms>true</UseWindowsForms>
 <Nullable>enable</Nullable>
 </PropertyGroup>

In the code, I want to create PDF documents dynamically and show them by using the PdfViewer component.

Thus, I added the following references:

<PackageReference Include="Telerik.Documents.Core" Version="2023.3.1106" />
<PackageReference Include="Telerik.Documents.Fixed" Version="2023.3.1106" />
<PackageReference Include="Telerik.Documents.Flow" Version="2023.3.1106" />
<PackageReference Include="Telerik.Documents.Flow.FormatProviders.Pdf" Version="2023.3.1106" />
<PackageReference Include="Telerik.Zip" Version="2023.3.1106" />
<PackageReference Include="UI.for.WinForms.AllControls.Net60" Version="2023.3.1114" />

Here is a part of my code:

    internal class GenericPdfCombiner : IPdfCombiner
    {
        public RadFixedDocument Combine(List<string> fileNames)
        {
            using MemoryStream stream = new MemoryStream();
            using (PdfStreamWriter fileWriter = new PdfStreamWriter(stream, leaveStreamOpen: true))
            {
                for (var fi = 0; fi < fileNames.Count; fi++)
                {
                    var file = fileNames[fi];
                    using PdfFileSource fileSource = new PdfFileSource(new MemoryStream(File.ReadAllBytes(file)));
                    for (var p = 0; p < fileSource.Pages.Length; p++)
                    {
                        PdfPageSource sourcePage = fileSource.Pages[p];
                        using PdfPageStreamWriter resultPage = fileWriter.BeginPage(sourcePage.Size);
                        resultPage.WriteContent(sourcePage);
                    }
                }
            }
            PdfFormatProvider provider = new PdfFormatProvider();
            return provider.Import(stream);
        }
    }

but it shows the error Reference to type 'Size' claims it is defined in 'WindowsBase', but it could not be found on the lines like the following:

using PdfPageStreamWriter resultPage = fileWriter.BeginPage(sourcePage.Size);

How can I fix it?

Hi,

I would like to create a new style with the All Caps Font Effect enabled in my Word document (refer to the attached image).

How can I do this programmatically?

I was expecting to be able to do it like this, but I cannot find any property to set the All Caps.

var document = new RadFlowDocument();

var style = new Style("ALL_CAPS", StyleType.Paragraph)
{
    Name = "ALL_CAPS",
    BasedOnStyleId = BuiltInStyleNames.NormalStyleId
};

style.CharacterProperties.AllCaps.LocalValue = true;

document.StyleRepository.Add(style);

Thank you

Hello,

I am trying to upload the stream object received from the 'ToXlsxStream' method of Telerik SpreadSheet processing library to Azure blob container. Unfortunately, it is saving as a blank excel file. I have data in the List object which is getting converted to xlsx stream. Not sure why the excel file is blank. Tried to save the stream to my local file explorer as well. Still, the issue persists. 

Below is the code:

  try
   {
Stream exportStream = exportFormat == SpreadDocumentFormat.Xlsx ? workOrderList.ToXlsxStream(columnsData, (string)options.title.ToString(), cellStyleAction: cellStyle) : workOrderList.ToCsvStream(columnsData);

Task.Factory.StartNew(() => AzureHelper.UploadReportOnCloud(exportStream,fileName, ConfigurationManager.AppSettings[Constant.REPORTATTACHMENTCONTAINER]));

}

            catch(Exception ex)
            {

            }

Please help me to resolve this issue.  

I'm trying to convert a word document to PDF and the images and shapes it contains, along with their text, do not make it into the PDF. Are these not yet supported? 

The attached zip contains the original document and the result of the conversion.

The conversion code is pretty straightforward, basically just

DocxFormatProvider docxProvider = new DocxFormatProvider();
var pdfProvider = new Telerik.Windows.Documents.Flow.FormatProviders.Pdf.PdfFormatProvider();
RadFlowDocument document = null;

using (Stream input = File.OpenRead("WordDocWithGraphics.docx"))
{
    document = docxProvider.Import(input);
}

using (Stream output = File.OpenWrite(("WordDocWithGraphics.pdf"))
{
    pdfProvider.Export(document, output);
}

I have an HTML code with hyperlinks in the text, this must be converted to rtf and the hyperlinks in the text need to be removed, but I did not find a way to remove the hyperlink/uri.

Is there an example for that?

I am writing an application that that generates a pdf presentation based on a pdf "template" file.  The template file contains one or more images. The application replaces the images in the template file with other images the user has called out. 

How can I name or "tag" the placeholder images in the template file in order to identify what goes where?   

I thought of using the accessibility/alternative text field of each image but I understand that is not currently accessible via the Telerik library.

Are there other fields I could use to place identifiers assocated with the images?

I want to use Adobe acrobat to edit the template file and add the tags if possible.

Thanks.