Hi,

I'm using the Telerik spreadsheet component to open an excel file embedded in a Winforms page.

I notice that dependent dropdowns do not work anymore, they show as empty.

What's the best way to have a dependent dropdown shown with Telerik?

I've tried multiple methods like https://www.contextures.com/xldataval02.html or with Index/Match combination in the Data Validation, all work directly in Excel .. but once opened in the embedded page with Telerik these dependent dropdowns  don't work anymore and show as empty.

I notice the named ranges dissappear once opened with the component.

Any advice / suggestions on this?

Thx in advance!

Hey there,

I have tried to use RadFixedDocumentEditor in order to have a continuous flow on the document. Before that, I was using FixedContentEditor and changing the position of the elements with the FixedContentEditor:

Ex: pageEditor.Position.Translate(351, 915) -- where pageEditor is FixedContentEditor instance which takes 2 arguments: offSetX and offSetY.

However, I can't seem to figure out how should I change the position of the elements (blocks, tables etc) when using RadFixedDocumentEditor?

Any advice would be much appreciated.

Thanks ever so much

Hi 

Greetings,

any clue on why this is misbehaving on one environment but works fine on another? File exists on both boxes and path is valid.

Its basically adding a doc to a blank doc, however when it use in production will be more than one.

Throws exception Invalid URI - Hostname could not be parsed.

Dim MainDoc as New RadFixedDocument()

Dim childDoc as RadFixedDocument = LoadFile('c:\folder\sample.pdf')

MainDoc.Merge(childDoc) <--- error occurs here. the error is when it attempts to clone in the merge

Private Function LoadFile(byval strFilePath as String) as RadFixedDocument

      Dim pdfProvider as new PDFFormatProvider()

      Dim returnRad as RadFixedDocument

      Using input as FileStream = File.OpenRead(strFilePath)

             returnRad = pdfProvider.Import(input)

     End Using

     returnRad

End Function

Hey, anyone knows how to set geometry borders?

Thanks

Hi.

I am attempting to create bookmark for several blocks on several pages, to create a Table of Content. Each page can contain more than one block. When reading your documents I have found this:

Location location = new Location();
location.Page = document.Pages.Last(); // The issue
location.Left = 10;
location.Top = 10;
BookmarkItem bookmark = new BookmarkItem(titleString, location);
bookmark.IsExpanded = true;
document.Bookmarks.Add(bookmark);

This works creating a ToC with the help of this method:

private static void ToC()
{
	RadFixedPage toc = new RadFixedPage();
	document.Pages.Insert(1, toc);

	FixedContentEditor editor = new FixedContentEditor(toc);
	int offSetVal = 0;

	foreach (BookmarkItem bookmark in document.Bookmarks)
	{
		int pageNumber = 1;

		if (pageNumber > 0)
		{
			int factor = 20;

			int offsetX = 70;
			int offsetY = offSetVal + 20 + factor * pageNumber;
			offSetVal += 10;
			editor.Position.Translate(offsetX, offsetY);

			Block block = new Block();
			block.InsertLineBreak();
			block.GraphicProperties.FillColor = new RgbColor(255, 5, 99, 193);
			block.InsertText(bookmark.Title);
			Size blockSize = block.Measure();
			editor.DrawBlock(block);


			var location = bookmark.Destination;
			GoToAction goToAction = new GoToAction();
			goToAction.Destination = location;

			Link uriLink = toc.Annotations.AddLink(goToAction);
			uriLink.Rect = new Rect(offsetX, offsetY, blockSize.Width, blockSize.Height);
		}
	}
}

The problem is that each action links to the same page. When debugging I can also see that "document.Pages.Last()" has the same value. How can I make it so the correct page is connected?

PS: Please let me know if any value is needed.

Thanks

-Steffen

I want to be able to feed a table of data into the html importer, and have it figure out how many pages it needs to generate, but while doing that, have it add a page header to every page that the text from the table must always come under.

Is this possible or am I going to have to determine if the line i want to add for every html row can still fit on the page and if not, create a new page myself?

In a huge pdf, some part of table is placed previous page and the rest is placed next page. I need to keep a table together in one page. 

I only find a way might work (but didn't work) TableRow CanSplit property. To achieve this, I created wrapper table 1 row, 1 cell and set row CanSplit property to false. Then, added actual table to wrapper table cell. But this doesn't work.

Is there any way to keep them together?

Edit 1 : Using RadFlowDocument to create document and PdfFormatProvider to export.