Hi,

 

I wanted to ask if it is possible to rotate the text of a cell. See the screenshot for an example.

 

Best regards,

Philipp

Hi,

Is it possible to configure the printing as for the library RadSpreadProcessing ?

Thank you

Hello,

i have an issue with WordsProcessing. After i have replaced text, borders from tables disappear.

 

 

You can see it at the attachements. Have anyone an idea what i have made wrong?

Best regards

Jens

Hi,

I am trying to replace my current zip library with Telerik's one.

My goal is to improve the transfer of huge objects between SL and WCF.
I can sucessfully zip my serialized object as in (note that I am using IsolatedStorage instead of memory stream as the objects some times are so big that using memory stream would throw an Out of Memory Exception):

public static byte[] SerializeAndCompress(T obj)

{

    var filename = DateTime.Now.ToString("ddMMYYYYhhmmss") + ".xml";

  

    var appStore = IsolatedStorageFile.GetUserStoreForApplication();

  

    if (appStore.Quota < TamanhoStorage) appStore.IncreaseQuotaTo(TamanhoStorage);

  

    byte[] bobj;

  

    using (var fileStream = appStore.OpenFile(filename, FileMode.Create))

    {

        var serializer = new DataContractSerializer(typeof(T));

        serializer.WriteObject(fileStream, obj);

  

        fileStream.Position = 0;

  

        bobj = new byte[fileStream.Length];

        fileStream.Read(bobj, 0, (int)fileStream.Length);

    }

  

    using (var fileStream = appStore.OpenFile(filename, FileMode.Create))

    {

        using (var zip = new ZipOutputStream(fileStream))

        {

            zip.Write(bobj, 0, bobj.Length);

        }

    }

  

    byte[] cobj = null;

  

    using (var fileStream = appStore.OpenFile(filename, FileMode.Open))

    {

        cobj = new byte[fileStream.Length];

        fileStream.Read(cobj, 0, cobj.Length);

    }

  

    appStore.DeleteFile(filename);

  

    return cobj;

}

This will compress my object as intended. My problem is reverting this process.
The only way I was able to achieve this was using a stream reader's ReadToEnd Method, but that won't work, as it will return a string, and I need a byte array (I know I can convert the string back to a byte array, but I'd like to make it in a better way, as in filestream.Read). Code sample:



After I call the sr.ReadToEnd method I can see the zip properties filled correctly with the compressed and uncompressed size.
What I need is the byte array of the decompressed object. Is there a way to achieve this? 

I tryed the following approach but it didn't work, as I can't foresee the size of the uncompressed object and the decompressed byte array won't be correct:


That will not read the decompressed object correctly, and will waste memory if the object is smaller than the byte array "bobj".

Thanks in advance.

Regards

Take Care

Jhon

Hi,

I have Performance Issues with the Excel spreadprocessing export. I just migrated an Excel export that used until now the libraries "Component One". The export takes now 30 seconds for 7221 rows and 88 columns, against 5 seconds before. Here is the code:

 

The code that takes the most time is:

 - Lines 42 - 77: Fill the sheet with data: 12 seconds
 - Line 122: AutoFitWidth(): 6 seconds --> (It's important, cannot be removed)
 - Line 22: formatProvider.Export(excBook, fsOutput): 11 seconds --> That's very long !!!

Can you check my code and tell me if there are any improvements, please? So i can unfortunately not use the libraries.

Thanks in advance

Given a set of strings, how should I compute a pattern from it? For example, (see picture), would provide me "Cadastro de Pessoas Físicas de Inscrição  Nome  Nasc". Of course, I could do it manually by analyzing the strings, but I need an automatic procedure for it because they would be more complex. Any ideas? I realize that this issue has do more with algorythms that Telerik products themselves.

 

 

Hallo,

when i read the result of a cell with a formular how has a function (like SUM()) or a referenz (sheetname!Range) linked to a worksheet (itself or another) in the workbook the result (.GetResultValueAsString ) ist "0" or a text (the formular itself) and not the result. Simple formulars related to cells in the worksheet are ok.

Example:

The cell formular looks like this:

1. =SUMME(L23:L30) ==> GetResultValueAsString result = "0"

2. {=WENNFEHLER(INDEX(Bestellliste!E:E;KKLEINSTE(WENN(Bestellliste!$A$1:$A$1131="x";ZEILE($1:$991));ZEILE(A3)));"")} ==> GetResultValueAsString result = "=WENNFEHLER(INDEX(Bestellliste!E:E;KKLEINSTE(WENN(Bestellliste!$A$1:$A$1131="x";ZEILE($1:$991));ZEILE(A3)));"")"

VB code:
Dim iCellValue As ICellValue
iCellValue = TryCast(workbook.ActiveWorksheet.Cells(row, col).GetValue().Value, ICellValue)
If iCellValue IsNot Nothing Then
    Dim format As CellValueFormat = workbook.ActiveWorksheet.Cells(row, col).GetFormat().Value
    Dim valueAsString As String = iCellValue.GetValueAsString(format)
    'valueAsString
    Dim resultValueAsString As String = iCellValue.GetResultValueAsString(format)
    'resultAsString
    Dim valueType As CellValueType = iCellValue.ValueType
    'valueType = Formula      ' ==> allways Text{4} with komplex formular
    'resultValueType = Number
    Dim resultValueType As CellValueType = iCellValue.ResultValueType
End If

DLL Version: 2015.2.728.40

What's wrong? Are their any restriction to resolve formulars?

 

Regards

Harald

 

 

 

I'm trying to zip a PDF file, it creates zip file correctly, but if I try to open compressed PDF file, it show me error message "Corrupted file" (I'm trying to open by my PDF reader), where I wrong?

Hi !

I searching another way to generate my PDF document by WordsProcessing.

Compositing it and convert to PDF

After install by Configure project (CfgProject.png) the Document.Flow (RadWordsProcessing) when i want convert it like this sample :

Telerik Sample export to PDF

the namespace "Telerik.Windows.Documents.Flow.FormatProviders.Pdf" is not found

The dll wasn't copied by Configure project ?! (FormatProvidersPdf.png)

it's a bug ? why ?

 

Thanks.

 

Hello,

Iam creating a pdf document wherein iam trying to set the size of the RadFixedPage object but the size property is showing as 

page.Size=new System.Windows.Size()

instead of page.Size = new Size();

What am i missing ? Any reference? 

I have already included the below references on my aspx page 

using System.Windows;
using Telerik.Windows.Documents.Fixed.FormatProviders.Pdf;
using Telerik.Windows.Documents.Fixed.FormatProviders.Pdf.Export;
using Telerik.Windows.Documents.Fixed.Model;
using Telerik.Windows.Documents.Fixed.Model.ColorSpaces;
using Telerik.Windows.Documents.Fixed.Model.Editing;
using Telerik.Windows.Documents.Fixed.Model.Editing.Flow;
using Telerik.Windows.Documents.Fixed.Model.Fonts;
using Telerik.Windows.Documents.Fixed.Model.Graphics;

 

Thanks in Advance

Sushanth.B