Is there a way to use a Worksheet "Or Convert it to" a dataSource that would be compatible with RadGridView?

I'm currently working on building a list from the activeWorksheet but it cause multiple issues "Header name, Columns Type, ect..

 

Thank you!

Hello, Telerik,

 

Is Conditional Formatting supported in RadSpreadProcessing? If not, will it be ever available?

 

Hi,

We are using PdfProcessing to read PDF file.

The code used:

However, some of the text are converted to weird characters.

Here is the document used: http://upload.ximnet.com.my/huisheng/sample_pdf.pdf

The text are converted from "DATO’ SERI AHMAD HUSNI MOHAMAD HANADZLAH" to "'A72’ 6(5, A+0A' +861, 02+A0A' +A1A'ZLAH"

Is there any setting that we need to set in the code?

Thanks.

 

compressing and decompressing functions -

 

private string CompressString(string str, string strInflateDeflate)
        {
            string strReturnValue = "";

            if (str != "")
            {
                MemoryStream memoryStream = new MemoryStream();
                CompressionMethod method = (CompressionMethod)Enum.Parse(typeof(CompressionMethod), strInflateDeflate, false);
                CompressionSettings settings;
                switch (strInflateDeflate)
                {
                    case "Deflate":
                        {
                            settings = new DeflateSettings();
                        }
                        break;
                    case "Lzma":
                        {
                            settings = new LzmaSettings();
                        }
                        break;
                    default:
                        {
                            settings = new StoreSettings();
                        }
                        break;
                }

                using (CompressedStream compressedStream = new CompressedStream(memoryStream, StreamOperationMode.Write, settings))
                {
                    //byte[] decBytes = Encoding.UTF8.GetBytes(str);
                    byte[] decBytes = Encoding.UTF8.GetBytes(str);
                    compressedStream.Write(decBytes, 0, decBytes.Length);
                }

                strReturnValue = Convert.ToBase64String(memoryStream.ToArray());
            }

            return strReturnValue;
        }

        private string DecompressString(string str, string strInflateDeflate)
        {
            string strReturnValue = "";

            if (str != "")
            {
                MemoryStream memoryStream = new MemoryStream();
                MemoryStream outputStream = new MemoryStream();
                CompressionMethod method = (CompressionMethod)Enum.Parse(typeof(CompressionMethod), strInflateDeflate, false);
                CompressionSettings settings;
                switch (strInflateDeflate)
                {
                    case "Deflate":
                        {
                            settings = new DeflateSettings();
                        }
                        break;
                    case "Lzma":
                        {
                            settings = new LzmaSettings();
                        }
                        break;
                    default:
                        {
                            settings = new StoreSettings();
                        }
                        break;
                }

                byte[] byteArray = Encoding.ASCII.GetBytes(contents);

                memoryStream = new MemoryStream();
                memoryStream.Write(byteArray, 0, byteArray.Length);

                using (CompressedStream compressedStream = new CompressedStream(memoryStream, StreamOperationMode.Read, new DeflateSettings()))
                {
                    compressedStream.CopyTo(outputStream);
                }

                strReturnValue = Convert.ToBase64String(outputStream.ToArray());
            }

            return strReturnValue;
        }

 

 

The above functions are not giving proper output.

Can anybody suggest what corrections are required ?

 

Thanks

 

Milind Shevade

The IfError and Match functions are not implemented. Any chance of getting these implemented?

 

Also Vlookup, but this has already been mentioned on another thread

I add a table to my document. I can add text to a table cell and style it (bold, italic, etc), but I don't know how to add a hyperlink to a table cell. All I see is "editor.InsertHyperlink()", but it adds the hyperlink below my table, not in my table cell.

Hello,

This is a pre-sale question. We're asked to allow corporate users to view online existing Excel files that contain multiple sheets.

We know viewing is possible when the Excel file contains only one sheet.

Does anyone know whether this is possible to do when the imported Excel file contains more than one sheet (in our case more than 10)?

 

Thanks much in advance.

A field in my PDF has the Scroll long text option set. When I fill in this field programmatically, it does not render properly: the plus sign displays, but not the text (initial display.PNG). If I hover over the field, the field border shows (hover.png). If I then click the field or the plus sign, the text displays (and the plus sign vanishes) (clicked into.PNG). If I then click off the field, the display reverts back to the initial display of just the plus sign (initial.PNG)

However, if I click into the field and type some additional text, then click off the field, the text and plus sign display (after typing.PNG). It would be nice, I think, if this last state was what happened initially.

If I don't have the Scroll long text option set on the field, the initial display shows the field without the plus sign, but the text is offset to the south (NOT Scroll long text.PNG) which also seems wrong; I could live with this not having the plus sign indicator if the text wasn't offset.

Hi,

See attached files. In the excel-file there are some checkbox controls. I use the following code to convert the excel file to a pdf:

        public static byte[] ExcelToPdfBytes(byte[] documentData)
        {
            var provider = new XlsxFormatProvider();
            var workbook = provider.Import(documentData);
            var pdfProvider = new PdfFormatProvider();
            return pdfProvider.Export(workbook);
        }

When I open the exported pdf the checkbox controls are gone. Why?

 

I to open a docx file to make a mail merge with it, you can download here:

//mega/#CtBHdEDQEmAR74q9awHNqjLou5vF8_Q_pHs9Xgu4z5Y

I receive this error:

SystemCollectionsGenericKeyNotFoundException occurred
  =0x80131577
  Message=The given key was not present in the dictionary.
  Source=
  :
    SystemCollectionsGenericDictionary`2get_ItemTKey key)
    TelerikWindowsDocumentsFlowFormatProvidersDocxImportRadFlowDocumentImportContextGetResourceByResourceKeyString )
    TelerikWindowsDocumentsFlowFormatProvidersDocxModelElementsVectorCreateImageSourceFromRelationshipIdString , IDocxImportContext context)
    TelerikWindowsDocumentsFlowFormatProvidersDocxModelElementsVectorOnAfterReadChildElementIDocxImportContext context, OpenXmlElementBase )
    TelerikWindowsDocumentsFormatProvidersOpenXmlModelElementsOpenXmlElementBase`3OnAfterReadChildElementIOpenXmlImportContext context, OpenXmlElementBase )
    TelerikWindowsDocumentsFormatProvidersOpenXmlModelElementsOpenXmlElementBaseReadChildElementsIOpenXmlReader reader, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFormatProvidersOpenXmlModelElementsOpenXmlElementBaseReadIOpenXmlReader reader, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFormatProvidersOpenXmlModelElementsOpenXmlElementBaseReadChildElementsIOpenXmlReader reader, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFormatProvidersOpenXmlModelElementsOpenXmlElementBaseReadIOpenXmlReader reader, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFormatProvidersOpenXmlModelElementsOpenXmlElementBaseReadChildElementsIOpenXmlReader reader, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFormatProvidersOpenXmlModelElementsOpenXmlElementBaseReadIOpenXmlReader reader, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFormatProvidersOpenXmlModelElementsOpenXmlElementBaseReadChildElementsIOpenXmlReader reader, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFormatProvidersOpenXmlModelElementsOpenXmlElementBaseReadIOpenXmlReader reader, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFormatProvidersOpenXmlModelElementsOpenXmlElementBaseReadChildElementsIOpenXmlReader reader, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFormatProvidersOpenXmlModelElementsOpenXmlElementBaseReadIOpenXmlReader reader, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFormatProvidersOpenXmlModelElementsOpenXmlElementBaseReadChildElementsIOpenXmlReader reader, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFormatProvidersOpenXmlModelElementsOpenXmlElementBaseReadIOpenXmlReader reader, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFormatProvidersOpenXmlModelPartsOpenXmlPartBaseImportIOpenXmlReader reader, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFormatProvidersOpenXmlOpenXmlImporter`1ImportXlsxPartFromArchiveZipArchiveEntry , OpenXmlPartBase part, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFormatProvidersOpenXmlOpenXmlImporter`1ImportStream input, IOpenXmlImportContext context)
    TelerikWindowsDocumentsFlowFormatProvidersDocxDocxFormatProviderImportOverrideStream input)
    TelerikWindowsDocumentsCommonFormatProvidersFormatProviderBase`1ImportStream input)
    TelerikWindowsDocumentsCommonFormatProvidersBinaryFormatProviderBase`1ImportByte] input)
    ProgramTelerikWay) in C:\Users\oscar.WAF\documents\visual studio 2017\Projects\WordTest\WordTest\Program.cs:line 45
    ProgramMainString] args) in C:\Users\oscar.WAF\documents\visual studio 2017\Projects\WordTest\WordTest\Program.cs:line 39

 

Some ideas?

Note: I'm using 2017.3.913 of WPF controls