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
I'm using SetFontSize() to set the font size of a column. If set it to 10 then the size in the saved Excel document is 7.5. If I set it to 11, 8.5. 10.5 Shows as 8 but isn't really 8 because it's pixelated. Setting it to 8 in Excel shows a nice anti-aliased font.
So, how do I get SetFontSize() to set a real font size of 8 in Excel?
I currently need to format some columns to use the "Accounting format". In your documentation, you talk about the document model exposing number formats. However none of your examples show how to access the document model (def, they show how to create custom number formats. Can you please tell me how I can access the Accounting format?
worksheet.Cells[2, 5].SetFormat(
new
CellValueFormat( SomeEnum/Class.AccountingFormat ));
Hi,
How do I get rid of the warning on Excel that says 'This document was generated by a trial version of Telerik RadSpreadProcessing.'?
Is there a way to check if I have the right dll or license file somewhere?
Thank you!
I have a couple .docx documents to which I've added a few merge fields. When I MailMerge against the documents, the document layout completely changes, section headers get right shifted, underlining removed, form checkboxes vanish, etc.
I've hacked up the mail merge project from here and attached it to demonstrate what I mean (you'll need to remove the .png extension to revert it to a .zip). If you compare Doc1.docx and Doc2.docx to their mail merged versions, you'll see what I mean.
Is this something that's just unsupported or am I doing it wrong?
Hello,
I have an MVC application that I would like to take a PDF file and either convert it into HTML, edit the content, and update the new content into a new PDF.
OR
be able to edit the PDF content and update it into a new PDF file. Would appreciate if you could point to the right Telerik libraries and any examples would be great.I know I can split up pages using the PdfStreamWriter, however editing would need to be done within the page, so splitting is not an option.
Many thanks