We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Picture link

With Aspose.Cells, is it possible to copy a range and paste it as a linked picture?

With Excel: http://j-walk.com/ss/excel/usertips/tip039.htm

In fact I want to copy 2-3 sheets on another sheet. But since the sheets are very different in styles, column width,... that was the best way I found to do that. If there is something else that does the same job, I can try it...

Thank you

Alexandre

This feature is not supported.

Do you have any plans to support it?

No. This is a complex feature and I don’t have any ideas about how to make it.

Hello:

I have a related question in another thread (252819). Is this feature supported now? It seems as though it it based on the answer that I got, but I still can't get the link to update. When I open the linked spreadsheet and save it under another name the pictures are there, but I cannot get the pictures to update with the latest data from the linked source.

So please let me know if this feature (linked picture) is supported or not. I need to get this working before purchasing.

Thanks very much.

Mark

Hi Mark,

Please post a sample file here, we will check it soon.<o:p></o:p>


Thank you.

Here is the code I am trying:

Workbook wbSrc = new Workbook("D:\\test\\shapes source.xlsx");Workbook

wb = new Workbook("D:\\test\\shapes dest.xlsx");

CellsHelper.StartupPath = "d:\\test\\";

wbSrc.CalculateFormula();

wb.CalculateFormula();

wb.UpdateLinkedDataSource(new Workbook[] {wbSrc});

wb.Save("D:\\test\\shapes dest.xlsx");

wb.Save("D:\\test\\shapes dest.pdf", FileFormatType.Pdf);

I am attaching the two spreadsheets. Thanks very much.

Mark

Hi,

Please try our latest version v5.1.2, it should work fine.

Kindly let us know if your still find any issue.

Thank you.