Hi,

Please try the attached version.

We have supported copying Hyperlink in Range.CopyData in the new fix 5.1.0.1 (attached).


Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Amjad,

Range.CopyData method is still not working with the new V5.1.0.1 that you have attached.

In V5.1.0 I was able to solve this issue of copying the hyperlink address and text for the cell  by first calling Range.CopyData followed by Range.CopyValue, it worked for me with this combination, but in V5.1.0.1 of Aspose Cells even this stopped working.

Can you plase let me know if there is any order to call these API's?

Thanks & Regards,

Padmaja

Hi,

Could you post your sample code with template file(s) to show the issue regarding Range.CopyData(), we will check your issue soon.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Amjad,

You can check the issue in the code/sample application I have last posted((Post 9, HyperLinkIssue code), just need to change the reference, no additional steps required for reproducing the issue.

If you are not able to reproduce the issue still then let me know I will upload the sample application.

Thanks & Regards,

Padmaja

Hi,

Yes, we found the hyperlink text is not copied with the address for CopyData method, only hyperlink address is copied. I have re-opened the issue again. We will fix it soon.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Amjad,

Any update on this issue, please let us know by when can we expect this issue to be fixed.

Thanks & Regards,

Padmaja

Hi,

Unfortunately, the feature is not implemented yet. We will check if we can provide you an eta for it.

Thanks for your understanding!

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi Padmaja,

The issue has been fixed. Please try the updated version of Aspose.Cells.dll v5.1.2.3.

Thanks,

---

Sincere Regards,

Salman Shakeel
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

Could you please let me know through which API is this issue resolved, because I have tried with Copy, CopyData and also CopyValue API's on the range object , after installing the Aspose version you have sent but still it is not working, You can try this on the sample I have attached previously.If its working can you please share the code.

Thanks & Regards,

Padmaja

 

Hi,

I use the following sample code using your template file (with new fix we attached in the previous post) for CopyData it works fine.

I have attached my output file.

Sample code:
            Workbook workbook = new Workbook(@"E:\test\hyperlinkissue\HyperLinkIssue\Book1.xlsx");
           
            Workbook newWb = new Workbook();
            Range cpyRng = workbook.Worksheets[0].Cells.CreateRange(0, 0, 2, 2);
            Range pasteRng = newWb.Worksheets[0].Cells.CreateRange(0, 0, 2, 2);
            Range pasteRng2 = newWb.Worksheets[0].Cells.CreateRange(4, 4, 2, 2);
           
            pasteRng.CopyData(cpyRng);

            newWb.Save(@"e:\\test\\mycopydata_test.xlsx");

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Thanks Amjad, its working now with CopyData API.

One observation if we use CopyValue API after CopyData API then again the hyperlink is appearing as the cell value.

Thanks & Regards,

Padmaja

Hi,

I could not find the issue. Following is my sample code and attached is my generated file. I used CopyValue after CopyData in the code:

            Workbook workbook = new Workbook(@"E:\test\hyperlinkissue\HyperLinkIssue\Book1.xlsx");
           
            Workbook newWb = new Workbook();
            Range cpyRng = workbook.Worksheets[0].Cells.CreateRange(0, 0, 2, 2);
            Range pasteRng = newWb.Worksheets[0].Cells.CreateRange(0, 0, 2, 2);
            Range pasteRng2 = newWb.Worksheets[0].Cells.CreateRange(4, 4, 2, 2);
           
            pasteRng.CopyData(cpyRng);


            pasteRng2.CopyValue(cpyRng);

            newWb.Save(@"e:\\test\\tst_mycopydata_and_copyvalue.xlsx");


If you still have any confusion, kindly give us your sample code with generated file and complete details.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Thanks for looking into this issue.

The issue I specified i.e. hyper link  getting displayed while using CopyValue after CopyData is coming only when we use the CopyValue on the same range as that of CopyData. and the same thing happens while using Copy API as well. Please find below the sample code:

Workbook workbook = new Workbook(@"E:\test\hyperlinkissue\HyperLinkIssue\Book1.xlsx");
           
            Workbook newWb = new Workbook();
            Range cpyRng = workbook.Worksheets[0].Cells.CreateRange(0, 0, 2, 2);
            Range pasteRng = newWb.Worksheets[0].Cells.CreateRange(0, 0, 2, 2);
            pasteRng.CopyData(cpyRng);
            pasteRng.CopyValue(cpyRng);
            // pasteRng.Copy(cpyRng);
            newWb.Save(@"e:\\test\\tst_mycopydata_and_copyvalue.xlsx");

Thanks & Regards,

Padmaja

Hi,

I have found the issue, I have re-opened the issue again. We will let you know when the issue is resolved.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us

Hi,

Please try the attached fix.
We have removed code of copying Hyperlink of the Range.CopyValue() method.
We only copy cells’ value in Range.CopyValue() method.

Thank you.

---

Amjad Sahi
Support Developer,
Aspose Sialkot Team
Contact Us