Hi all I have a problem during the import of an existing excel file with formula inside
(e.c. IF(H1<>"";IF(J1="";"";INDEX(INDIRECT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("Var_"&C1&"_"&G1&"_"&H1;" ";"hex20");"-";"hex2d");"(";"hex28");")";"hex29");"/";"hex2f");"+";"hex2b");"&";"hex26");".";"hex2e")&"_Daily");MATCH(J1;INDIRECT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE("Var_"&C1&"_"&G1&"_"&H1;" ";"hex20");"-";"hex2d");"(";"hex28");")";"hex29");"/";"hex2f");"+";"hex2b");"&";"hex26");".";"hex2e")&"_Levels");0)));""
or
==EOMONTH(startdate;-1)
These formula are used in different cells in different sheets and when I try to bind the generated json to a spreadsheet component I received this error:
As posted in some forum It seems due to the culture used during excel generation (I tried different approach: attached a different culture to the current thread server side, force kendo core library to use a specific culture client side, force spreadsheet to use a specific culture server side).
How can I resolved this issue?
I did not found any working solution on line.
Thank you in advanced
Eleonora
Hi Telerik.
Attempting to create a Header with your documentation. Link: Headers and Footers
The example code writes:
RadFlowDocument document = new RadFlowDocument();
document.Sections.AddSection();
document.Sections.First().Headers.Add(); // Creates the default Header.
document.Sections.First().Headers.Add(HeaderFooterType.First);
document.Sections.First().Headers.Add(HeaderFooterType.Even);
However I get the errorcode:
'object' does not contain a definition for'Headers'and no accessible extension method 'Headers' accepting a first argument of type
'object'could be found (are you missing a using directive or an assembly reference?)
Am I doing something wrong?
I'm doing a recursive file search through a lot of documents (1000000+) for a client, depending on the document type/age/size/name/path the app may read the document.
this is the read code
Dim docprovider As New Doc.DocFormatProvider()
Using input As Stream = File.OpenRead(_fname)
Dim TxtFormatProvider As New TxtFormatProvider
text = TxtFormatProvider.Export(docprovider.Import(input))
End Using
Occasionally the app will hang waiting for the
TxtFormatProvider.Export(docprovider.Import(input))
Thread to return.
I'm guessing the input stream of the .doc file is malformed in someway, and I'm not really concerned about it, but how can I get the thread to quit so the app can go to the next file?
Hello,
we are currently in need for a docx to pdf converter.
The docx file contains placeholders created in word. When we want to read it in with the Telerik documents package it gives us an error.
The Import() function returns:
Error: System.ArgumentException: 'An item with the same key has already been added. Key: 0'
Here is the code we are using:
static void ConverDocxToPdf(string path, string resultPath)
{
var docxPRovider = new Telerik.Windows.Documents.Flow.FormatProviders.Docx.DocxFormatProvider();
var pdfProvider = new Telerik.Windows.Documents.Flow.FormatProviders.Pdf.PdfFormatProvider();
byte[] docBytes = File.ReadAllBytes(path);
var document = docxPRovider.Import(docBytes);
var resultBytes = pdfProvider.Export(document);
File.WriteAllBytes(resultPath, resultBytes);
}
I attached one of the templates we are using. When you try to read it in, it will return the mentioned error.
Thank you in advance!
When using the Clone function from RadFlowDocument, the below exception is thrown :
[2022-10-07T13:06:32.329Z] Error: System.ArgumentException: The document element is associated with another document. (Parameter 'item')
at Telerik.Windows.Documents.Flow.Model.Collections.DocumentElementCollection`2.VerifyDocumentElementOnInsert(T item)
at Telerik.Windows.Documents.Flow.Model.Collections.DocumentElementCollection`2.AddClonedChildrenFrom(DocumentElementCollection`2 fromCollection, CloneContext cloneContext)
at Telerik.Windows.Documents.Flow.Model.Paragraph.CloneCore(CloneContext cloneContext)
at Telerik.Windows.Documents.Flow.Model.Collections.DocumentElementCollection`2.AddClonedChildrenFrom(DocumentElementCollection`2 fromCollection, CloneContext cloneContext)
at Telerik.Windows.Documents.Flow.Model.Footer.CloneCore(CloneContext cloneContext)
at Telerik.Windows.Documents.Flow.Model.HeadersFootersBase`1.CloneHeadersFootersFrom(HeadersFootersBase`1 headersFooters, CloneContext cloneContext)
at Telerik.Windows.Documents.Flow.Model.Section.ClonePropertiesAndHeadersFooters(CloneContext cloneContext)
at Telerik.Windows.Documents.Flow.Model.Section.CloneCore(CloneContext cloneContext)
at Telerik.Windows.Documents.Flow.Model.Collections.DocumentElementCollection`2.AddClonedChildrenFrom(DocumentElementCollection`2 fromCollection, CloneContext cloneContext)
at Telerik.Windows.Documents.Flow.Model.RadFlowDocument.CloneCore(CloneContext cloneContext)
at Telerik.Windows.Documents.Flow.Model.RadFlowDocument.Clone()
at Perspex.Shared.OOPGenerator.OOPGenerator.SetWordDocumentTemplate(Schools school, SchoolYear schoolyear) in D:\projecten\cip\Perspex\src\Perspex.Shared\OOPGenerator\OOPGenerator.cs:line 62
It occurs after I upgraded to the latetst version of RAD Document processing. In the previous version it worked as expected.
Steps I take to reproduce the issue :
1) Load a word document
2) Clone the document.
WordDocumentTemplate = await Storage.GetWordDocumentTemplate(school.Onderwijstype, schoolyear);
if (WordDocumentTemplate!= null)
{
WordDocument = WordDocumentTemplate.Clone(); <-- throws the exception
I need to load a PDF document and extract text.
Is this possible with PDFProcessing?
Thank you,
Guido
Hi,
I want to be able extract embedded images and text from a pdf. Is this even possible?
If so, can you point me in the right direction?
Thanks... Ed
Used with Blazor, anyway we can get rid of this warning?
Telerik.Documents.SpreadsheetStreaming 2022.2.613 requires Telerik.Zip (= 2022.2.613) but version Telerik.Zip 2022.3.906 was resolved
I would like to copy some pages from original document tonew pdf Document.
my Source code is based on merge document example proveded Telerik documenttaion:
Public Function ExtractPagesToPDF(pdfDocument() As Byte, pages() As Integer) As Byte() Implements IPdfPageExtractor.ExtractPagesToPDF Dim ms = New MemoryStream() Using pdfWriter = New PdfStreamWriter(ms) pdfWriter.Settings.DocumentInfo.Author = "TMS" pdfWriter.Settings.WriteAnnotations = True Using pdfStream = New MemoryStream(pdfDocument) Dim document = New PdfFileSource(pdfStream) For Each index In pages If index >= document.Pages.Count Then Throw New ArgumentException($"Page index {index} > Document page count {document.Pages.Count}.") End If pdfWriter.WritePage(document.Pages(index)) Next ms.Position = 0 Return ms.ToArray() End Using End Using End Function
if I try open new document with with Telerik WPF RadPdfViewer my programm throws exception:
NotSupportedException: StartXRef keyword cannot be found.
Do I miss some settings?